Main report and subreport - two stored procedures - use same parameters

[mark_tractor]

I have a report with Main report and Subreport

Both execute a stored procedure

Both use the same parameters

When I run it now... it asks me to enter in parameters for both Main Report and Subreport

How do I change this so that I don't have to enter in parameters twice ?

[former_member198519 · Accepted solution]

Is the main Report Parameter linked to sub report Parameter?

I am assuming that there is a ?Main Report parameter in main report and you want to pass the same parameter selection(filter criteria) to sub report parameter.

Right click sub report >> change sub report links >> select ?Main Report parameter in "Field(s) to link to" >> select ?sub Report parameter from the "sub report parameter to use" drop down list >> edit sub report record selection to {Object} = {?sub Report}

Hope this helps

[abhilash_kumar · Accepted solution]

Just a small edit to Kuldeep's suggestion.

After you select the Subreport prompt from the 'Sub report parameter field to use' drop-down, you don't need to edit the Subreport's record selection formula.

The values from the Main Report are directly passed over to the Subreport's prompt.

-Abhilash

[former_member198519 · Accepted solution]

Thanks Abhilash, Almost forgot that you need not perform record select explicitly

[mark_tractor]

Thank you, these suggestions worked perfectly