[X] My Assistant

[reCoded]

I have a report and in my SQL query I have the following:

CODE

SELECT 'All' AS number FROM dual
UNION
SELECT  DISTINCT number
FROM default_orders
ORDER BY number

Now in my SSRS report I preview my report and it runs my report fine. Only thing is that my drop down parameter list looks like this.

01
03
293
300
All
R#
RFE

My problem here is that I would like to have "All" be at the top of the list. I looked through everything and I am not sure if there is an option so when the report loads it will default to "All" instead of "01". I hope someone can help me out.

Thanks.