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

[igor22]

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

 

[Catadmin]

I actually created a stored procedure that forced a value called ALL at the top of my list, then proceded to list all the other possible values in the drop down list. In my case, I was listed tables in the DB for a data dictionary.

I passed what was chosen to a parameter in the report and all my succeeding stored procs would do an IF/THEN/ELSE test for the value of the passed in parameter. If param = ALL, then a cursor would run, pulling the names of all the tables and putting them in the report in alphabetical order.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"