Skip to Content
author's profile photo Former Member
Former Member

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


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


Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on May 15, 2008 at 08:41 PM

    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 😉

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.