Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pass Params from Primary to Sub-reports?

Status
Not open for further replies.

CraigBest

Programmer
Aug 1, 2001
545
US
Is there a way to pass a parameter from a Primary report to Sub-reports? I have a primary report that collects a numeric value as a parameter when invoked. This report also has two sub-reports, which also need to use that value as a parameter.

What's happening is my program passes the value to the primary report when it is called, but then the user is prompted for the same parameter for each of the sub-reports. I want to have the sub-reports get that value from the primary report without prompting the user -- how can I do that?

Thanks in advance

Craig in NJ
 
Don't create parameters in the subreports.

Instead link the Main report parameter directly to the field in the subreport (right click the subreport and select Change Subreport Links).

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top