ASP and Linked Subreports

[Jill50]

I have searched Tek-Tips and Crystal Decisions knowledge base for information on how to pass logon parameters in ASP to linked subreports. I found some code examples in FORUM: Crystal Decisions: Crystal Reports 4 Other topics SUBJECT: Running reports from the web; however, it is not working for us. I also downloaded the asp examples from Crystal Decisions which included a Subreport example .asp and .rpt, but the subreports are not linked to the main report, so it did not help much either. Can someone please tell me how to pass not only the logon information for the subreport, but also the field it is linked to on the main report?
Thanks in advance for any help!

 

[cedawson]

I am having the same problem, did exactly what you did, and still no luck. I have searched throughout the Crystal Decisions support and knowledge base to no avail.

Guess you could say I have "Nahta' Klu".

 

[pgtek]

hi here this might hekp you
In Crystal Reports version 8 and 8.5 ASP applications main report parameters must be set on the main report and subreport parameters must be set on the subreport. Below is some example code for passing values to a main report and subreport.
-----------------------------------------------------------

In this example the report is seen as having 4 main report parameters and 2 subreport parameters.

Note: Subreport-linking parameters do not need to be set with version 8 and 8.5.

set ReportDatabase = Session("oRpt&quot.Database

'Set the Table object and logon (1 table only)
set crdatabasetables = ReportDatabase.Tables
set crtable = crdatabasetables.Item(1)
crtable.SetLogonInfo "ODBCDSNname", "", cstr(userid), cstr(password)

'Create subreport database object, get table(s), login
set CRSubreports = session("oRpt&quot.OpenSubReport("testsub.rpt&quot
set ReportDatabase2 = CRSubreports.Database
Set crdatabasetables2 = ReportDatabase2.tables
Set CRtable2 = crdatabasetables2.Item(1)
crtable2.SetLogonInfo "ODBCDSNname", "", cstr(userid), cstr(password)

'Get handles to parameters in main report (there are 2)
set Session("ParamCollection&quot = Session("oRpt&quot.Parameterfields
Set ThisParam1 = Session("ParamCollection&quot.item(1)
Set ThisParam2 = Session("ParamCollection&quot.item(2)

'Set values for the parameters
ThisParam1.SetCurrentValue cstr("paramvalue1&quot,12
ThisParam2.SetCurrentValue cstr("paramvalue2&quot,12

'Get handles to parameters in SUB report (there are 2)
set Session("SubRptParamCollection&quot = CRSubreports.Parameterfields
Set ThisParam1 = Session("SubRptParamCollection&quot.item(1)
Set ThisParam2 = Session("SubRptParamCollection&quot.item(2)

'Set values for the parameters (these were previously set in the main report.
ThisParam1.SetCurrentValue cstr("paramvalue4&quot,12
ThisParam2.SetCurrentValue cstr("paramvalue3&quot,12

For more sample ASP applications to use as templates for your Crystal Reports web applications please download the file aspxmps8.exe (for version 8.0) or aspxmps85.exe (for version 8.5) from our support site at:

http://support.crystaldecisions.com/downloads