database connection string in Crystal ver9.0

[ausmoran]

In version 8 and 8.5 when I saved a report which retrieved it's data from a SQL database, I never seemed to have any problems with database permissions or access. However, when I am working in Crystal Reports version 9.0 each time I attempt to preview a report, I get the SQL login dialogue box. Is there a way to save the connection string with the report? Or can someone tell me how to programatically use the connection string in a standard ASP page?

Thanks in advance,
Austin Moran

 

[vannojl]

I use the following ASP page to display my reports. This works well as long as the report only uses one data source.

<%reportname = &quot;report.rpt&quot;%>
<!-- #include file=&quot;AlwaysRequiredSteps.asp&quot; -->
<% clientDoc.databaseController.logon &quot;username&quot;,&quot;password&quot; %>
<!-- #include file=&quot;CrystalReportsInteractiveViewer.asp&quot; -->

Where AlwaysRequiredSteps.asp and CrystalReportsInteractiveViewer.asp come from:

http://support.crystaldecisions.com/communityCS/FilesAndUpdates/ras_asp_samples.exe.asp

Joe Van Norman
ABS Associates

 

[ausmoran]

Thanks so very much for you helpful response. We are still struggling with this one. I will have a look at your suggestions to see if it might make a difference.

Cheers,
Austin Moran

 

[Jobim]

Does anyone know how to change the database name in the .asp page? The clientDoc.databaseController.logon &quot;username&quot;,&quot;password&quot; works great to change the user, but I need to also change the database from time to time. Is there a method on the databaseController to change the database name?

 

[Slonoma]

Hey all,
I have the exact same question as Jobim and was wondering if anyone knew the answer yet.

Thanks!

Slo-No