ASP Login for Subreports

[vannojl]

I have a report that shows our help desk's performance metrics. Some of these metrics come from our CRM database, and some come from our ACD database. This report is a main report with subreports gathering data from different MS SQL servers.

When calling a report with only one data source, the ASP code below works perfectly, but when calling reports with multiple data sources, it is prompting for multiple sets of login information.

My ASP code for calling the report is:

<%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

Is it possible to set the username & password for each subreport or data source?

Joe Van Norman
ABS Associates