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

How to display page specific parameter value for each page of report

Status
Not open for further replies.

Jacque

Technical User
Nov 9, 2001
301
US
I have a multivalue parameter.
The parameter I need to display in the page header is a child group in my report and each child group has it's own page.
I need to be able to display the applicable parameter value on the page header like my examples at the bottom.

I've tried the following expressions
=Parameters!FacilityType.Value (this displays as #Error (yes I know, duh - :-D )
=Parameters!FacilityType.Value(0) (this displays the first value on all pages)
=ReportItems!FacilityType.Value (referencing a field that's hidden on the report but it errors or doesn't show)

I'm not sure what else to try, I've tried googling it but no luck (yet).

I know how to make them all display together but I want each one to display correctly on their appropriate pages. Any Suggestions?

Page 1
Parent
Child1

Page 2
Parent
Child2

Page 3
Parent
Child3

Thanks in advance,
Jacque
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top