How to pass uid/pwd from ASP to Crystal subreport???

[Guest_imported]

I can pass username/password to main report,but I also user
SQL Server tables in subreports,every time I run report it
will prompt me for the username/password for the subreports,
how to aviod that?

Thx !!!

 

[smsinger3]

Here's how I do it:

Set CRSubreports = oRpt.OpenSubreport("subrept.rpt&quot
set ReportDatabase2 = CRSubreports.Database
Set crdatabasetables2 = ReportDatabase2.tables
set crtable2 = crdatabasetables2.Item(1)
crtable2.SetLogonInfo Application("CRServerName&quot, Application("CRDBName&quot, Application("CRLogonID&quot, Application("CRPassword&quot
set ParamsSub = CRSubreports.ParameterFields

ParamsSub.Item(1).SetCurrentValue str1, 12
'item 2 is not passed via parameter. It's passed through Crstal Reports
ParamsSub.Item(3).SetCurrentValue str3, 12
ParamsSub.Item(4).SetCurrentValue str4, 12

oRpt.ReadRecords