database error in report
Printed From: Crystal Reports Book
Category: General Information
Forum Name: Talk with the Author
Forum Discription: Ask Brian questions about his books and give him your comments. Like the book? Hate the book? Have suggestions? Let me know!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19986
Printed Date: 02 May 2024 at 7:24pm
Topic: database error in report
Posted By: Ganesh Khuspe
Subject: database error in report
Date Posted: 04 Sep 2013 at 8:19pm
Hi guys,
i have made report..while showing report it is asking me for database credentials every time.can anybody tell me why it is so??
Thanks in advance..
|
Replies:
Posted By: kevlray
Date Posted: 05 Sep 2013 at 6:40am
Are you saying you are in designer and every time you click on the refresh you get prompted or every time you open the report you get prompted (or something else)? Crystal Reports will not remember the credentials once the report is closed, but should remember as long as it it open in designer.
I hope this helps.
|
Posted By: JagBuddy
Date Posted: 10 Sep 2013 at 12:26am
Thanks for reply http://www.crystalreportsbook.com/forum/member_profile.asp?PF=8671&FID=4 - kevlray ,
i have logined as different user coz have lost my credentials.
and
yes..the same as what u r saying m facing..first time reports doesnt asks for credentials but when i will go for Go To button or navigate to next report page it is asking me for credentials.
ganesh
|
Posted By: kevlray
Date Posted: 10 Sep 2013 at 5:17am
|
Two questions. Are you viewing the report in designer or a viewer (that includes BI enterprise)? Does this report(s) contain sub-reports?
|
Posted By: JagBuddy
Date Posted: 10 Sep 2013 at 5:54pm
m viewing report in viewer only..and its not contain subreport..but if m inserting any subreport and navigate on it then it is asking me for credentials..means the problem is for both main report and sub report..
|
Posted By: kevlray
Date Posted: 11 Sep 2013 at 6:03am
|
If the report is on BI Enterprise (Not sure what version of CR and what viewer you are using), then you can set the database credentials for the report in the CMC. I do not know if that option is available for other viewers.
|
Posted By: JagBuddy
Date Posted: 11 Sep 2013 at 9:04pm
|
i m using crystal report 10 and visual studio 2010.still i m getting the same issue...
|
Posted By: kevlray
Date Posted: 12 Sep 2013 at 5:44am
|
I do not know about VS 2010, but I know that in a older version of VS (I have been working with the programmer on a project). The programmer is using a OLE DB (ADO) connection to an MS-SQL DB. That is the connection in the report. I do not know how he passes the credentials (I have not see that part of the code). I hope this helps.
|
Posted By: JagBuddy
Date Posted: 12 Sep 2013 at 8:38pm
the same procedure i have did but i was getting the same....But now it is working fine.i have added new report and then did the connection with database.Now it is working fine.
Thank http://www.crystalreportsbook.com/forum/member_profile.asp?PF=8671&FID=4 - kevlray .
|
|