Talk with the Author
 Crystal Reports Forum : General Information : Talk with the Author
Message Icon Topic: database error in report Post Reply Post New Topic
Author Message
Ganesh Khuspe
Newbie
Newbie


Joined: 06 Feb 2013
Online Status: Offline
Posts: 18
Quote Ganesh Khuspe Replybullet Topic: database error in report
    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..




Edited by Ganesh Khuspe - 04 Sep 2013 at 8:22pm
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet 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.
IP IP Logged
JagBuddy
Newbie
Newbie


Joined: 04 Sep 2013
Location: India
Online Status: Offline
Posts: 6
Quote JagBuddy Replybullet Posted: 10 Sep 2013 at 12:26am
Thanks for reply 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
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet 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?
IP IP Logged
JagBuddy
Newbie
Newbie


Joined: 04 Sep 2013
Location: India
Online Status: Offline
Posts: 6
Quote JagBuddy Replybullet 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..
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet 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. 
IP IP Logged
JagBuddy
Newbie
Newbie


Joined: 04 Sep 2013
Location: India
Online Status: Offline
Posts: 6
Quote JagBuddy Replybullet Posted: 11 Sep 2013 at 9:04pm
i m using crystal report 10 and visual studio 2010.still i m getting the same issue...
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet 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.
IP IP Logged
JagBuddy
Newbie
Newbie


Joined: 04 Sep 2013
Location: India
Online Status: Offline
Posts: 6
Quote JagBuddy Replybullet 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 kevlray.


Edited by JagBuddy - 12 Sep 2013 at 8:39pm
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.