I've got a report that has only one parameter, it determines the department (or departments) to base the report on, the parameter is set to allow for multiple values. The report
returns only on page per department, so the report could be anywhere from one to a hundred pages, one page per department.
I've included a text box in the report footer that displays the report name and the parameter value, the expression looks like this:
=Globals!ReportName & " For Department " & Parameters!Dept.Value(0) I know that in this example the zero inside of the parenthesis of the parameter value is what
is returning the actual value when the report is rendered, and I understand that the zero is value in the array of parameter values.
What I'm looking to do is adapt this expression so that the parameter value rendered on each page corresponds with the data (departement) displayed on the specific page. So using
the example of the data, if the user selected three departments in the parameter drop down, then each page that displayed the different department’s information would also display that departments name in the page footer text box.
I'm thinking that each time a page is rendered that there is a group or global variable that can be called to provide this dynamically but I can't seem to find the information.
Appreciate any help,
View Complete Post