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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding a Main Report Parameter to a Subreport

Status
Not open for further replies.

Garyjr123

MIS
Sep 14, 2010
139
US
I have a main report with a parameter called '@print' that is linked to a formula 'print' that I would like to filter down to the subreport. Basically, I want the information in the subreport to be effected by the parameter in the main report.

Formula:
IF {?@print} = 0 THEN 'All'
ELSE IF {?@print} = 1 THEN 'Charges currently being interfaced'
ELSE IF {?@print} = 2 THEN 'Charges completed successfully '
ELSE IF {?@print} = 3 THEN 'Charges completed with errors'

Parameter:
Name: @print
Type: Number
Allow Custom Values: True
Allow Multiple Values: True
Allow Discrete Values: True
Allow Range Values: True
 
Create a parameter in the subreport and use in select expert as required.

In SR linking window, drage param from main report into linking window. In lower left hand drop down scroll down until you find parameter name and link the two.

Ian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top