ASP problem with SubReports

[aleksandarn]

I have created one big report that exists of many subreports. Using ASP help file from Crystal Decisions we, WEB designer and I, tried to make it work, but it usually gives us one or more errors. At the end we did it but only with report that does not have any subreports. WEB designer did not include any code for subreports because it treated subreports as finished part of main report. Do we have to open database connection for each subreport and what else has to be done in order to work. I would appreciate some code if it's possible.
We are using MS Access database and FrontPage as Publisher.

 

[imstac]

Here is the part of the ASP code we use for our subreport part...hope this helps.


'Set the userid and password for your database.
userid = "userid"
password = "password"

'Create a reference to the tables collection of the main report
Set mainReportTableCollection = Session("oRpt&quot.Database.Tables

For Each Table in mainReportTableCollection
Table.SetLogonInfo "Time-Deltek", "Deltek", CStr(Userid), CStr(Password)

'Create a reference to the subreport object by opening the subreport
'by using its name as specified in the report designer.

Set subReportOne = session("oRpt&quot.OpenSubReport("Job Summary Report Target (B&P).rpt&quot

Set subReportOneTablesCollection = subReportOne.Database.Tables

'Provide the logon credentials for the subreport
For Each Table in subReportOneTablesCollection
Table.SetLogonInfo "Time-Deltek", "Deltek", CStr(Userid), CStr(Password)
Next
Set subReportTwo = session("oRpt&quot.OpenSubReport("Direct Labor Report.rpt&quot

Set subReportTwoTablesCollection = subReportTwo.Database.Tables

'Provide the logon credentials for the subreport
For Each Table in subReportTwoTablesCollection
Table.SetLogonInfo "Time-Deltek", "Deltek", CStr(Userid), CStr(Password)
Next
%>

%>