How to add ALL as report parameter in drop down

Hi ALL,
I would like to add 'ALL' to other report parameters.The other report parameters are counties.I would like to add 'all' so that user can select all counties from drop down.

I added union select 'ALL' to sub query.
in main query @.county='all' is it right or wrong.After I did this report is running very very slow.performance problem begins.
what exactly is the procedure to do.
thanks
r sankar

How are you using the counties? I do the same thing, but my countiesalso have a numerical county code. So I union the parameter to have thename as the label and an integer as the value. The query lookssomething like
Select 'All Counties' as nm_county, 0 as id_county
UNION
Select nm_county, id_county from dbo.county
The report still renders just as quickly, and I just check "If@.County = 0" in the stored procedure I use. Hope this helps.
|||Hi,
thank you very much for reply.I did not use @.county =0 in stored procedure .that is why it became slow.Now It is working fine.Thank you once again.If I get any more problems I will let you know.
thanks
sankar|||

You can also reference it directly in a query::

SELECT *
FROM Businesses
WHERE (county = @.county) or (@.county = 'ALL')

This way, you either get Businesses for a specific county or you get all businesses.