Refer to parameter in page header 1

[dianemarie]

Hello, I've seen several posts about getting the information entered into a parameter into the heading. In this case, I want to show the date range of the report. I put a hidden textbox (name:textbox1) in a table that says:

=Parameters!StartDate.Value & "-" & Parameters!EndDate.Value

Then I put a textbox in the page header that says:

=ReportItems!textbox1.value

This worked for me when I hid a textbox in the table showing fields from my data list (client # and name) and referred to that in a textbox in the header, but I get an error in the header textbox that is referring to parameters. The textbox referring to the parameters in the table works fine. Any help would be appreciated. Thank you.

 

[andrea96]

You can reference the parameters directly in the page header; you don't have to put them in a hidden textbox in the report first.

Andrea

 

[dianemarie]

Thank you Andrea. Worked great. To take this a step further, I have a multi-choice parameter. (This is a cascading parameter - the second in a set of 2, I don't think that matters here however.) If the user says "Select All" I would like the parameter to say that, and if the user selects one or more, I would like to list them separated by commas. Is this possible?

 

[andrea96]

I'm not sure. I have never used a multi-choice parameter, but it looks like it creates an array of parameter values. You can probably use custom code to format that array like you want. I don't know if there is an easier way.

Andrea

 

[amysdude]

Sorry about the month delay. I just joined the forum today after reading your post and thought I'd take a stab at it regarding listing the values of a multi-select parameter.

The following textbox expression will join the Multi-Valued Parameters with a comma:

=Join(Parameters!MyParameter.Label, ",")

Hope this isn't too late!