cancel
Showing results for 
Search instead for 
Did you mean: 

Can a subreport parameter entry be delayed until the subreport is required

Former Member
0 Kudos

Hello

(Oracle 10g DB & CRXI CR 2008)

I have a report that reads all records from a table. There are no parameters on the report, whatever is in the table is printed.

I want to put a subreport in the Report Footer of this report.

This subreport will call a SP and it has one parameter.

At the moment when i preview the report, i am asked to supply the parameter for the subreport before the entire report runs

What i would like to be able to do is have the main report display its data and when this is displayed THEN have the prompt for the subreport come up i.e. when the report reaches the Report Footer

Is that possible please?

Thanks

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

The answer is NO.

Sub report params are generated in pass 1 of the report. This is the way Crystal builds a report

The sub report can be anywhere on the report but the param will always be looked for at the start of the report

(my subreport here is not linked to data in the main report)

There is good info about PASS in the help for CR 2008 - RTFM