Hello,
I am relatively new to Reporting Services. My problem is to retrieve all rows if a parameter is left blank. This works fine for single input parameters like date, string, etc. by checking the checkbox in the report parameters properties.
However, if I have a parameter that is coming from a dataset, it doesn't display the 'null' checkbox even if I select the "Allow null value" checkbox. Does anyone know of a workaround or solution to this?
Any help is appreciated.

SELECT ...
FROM ...
WHERE MyColumn = @MyParam OR @MyParam IS NULL


This will return all rows if the parameter value is null.

Paul Turley, MCSD, MCDBA, MCT, MSF Practitioner

Appologies.. I didn't read your question thoroughly. You'll need to include a row in the result set conaining a null value - such as:

SELECT NULL AS ID, '(All)' AS Description
UNION
SELECT ID, Description FROM WhatEver

Paul Turley, MCSD, MCDBA, MCT, MSF Practitioner

Thanks for your solution. I think the 2nd one works best even though it is not the most elegant one.