If all values of dropdown parameter are selected - show ALL in report header

Hi,
I have dropdown parameter with multi-values allowed.
In my report headed I want to show all the dropdown values that were checked by the user to run the report. But since there could be a couple of hundred values I want to show ALL when all the values are selected instead of listing them one by one.
How can I do that?
Thanks,

Igor

Igor,

I recently had a similiar problem. While I'm sure that there is a more elegant solution, this seemed to work for me:

In the textbox where you are displaying the selected parameters you can write an expression that compares the selected item count from the parameter dropdown to the total count of the dropdowns data source.

For example, if you have a multi value parameter called Parm1 and it has a datasourse called Query1 (which selects a KeyID and TextValue) then the expression in your textbox might look something like:

=iif(Parameters!Parm1.Count = count(Fields!KeyID.Value, "Query1"),"All", join(Parameters!Parm1.Label,", "))

This above expression should display the word "All" if all values are seleted from the parameter drop down, otherwise it will list out the selected parameters individually.

Hope this helps.

|||

Hi,

I am getting error,Fields cannot be used on Header and footer.

Any work around.

Thanks