(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?