Reporting Services 2008
I am working on creating a report that has multiple parameters in Reporting Services 2008. It would allow the user to select multiple counties or leave it blank. Since all customers do not have counties it needs to allow nulls as well. It seems that if you allow a user to select multiple values in a parameter drop-down box you cannot allow them to select nothing.Is there any way to get around this?
October 19th, 2009 5:23pm

Hi,If you leave the country parameter blank,which will the dataset query return,no data or all rows orthe rows with no country(null)? Please explain the reason why need the null value for the report parameter, then here will besomeone can help you.PS, is your dataset query T-SQL or MDX?thanks,Jerry
Free Windows Admin Tool Kit Click here and download it now
October 21st, 2009 5:45am

We have multiple parameters on the report.For Example: Customer CountyRegionWhat we want to be able to do is to select either a specific customer (i.e. Bob Smith) or be able to select all customers within a specific county (i.e. All customers who live in Putnam County) or be able or select all customer within a specific region no matter what county they are in (i.e. All customers, All counties, in the Midwest).I am passing this information back to a stored procedure.Any help is appreciated.Thanks.
October 22nd, 2009 5:29pm

I had figured out how to do this and here is the answer for anyone else running into this issue. Select null as CustomerPK, 'All Customers' as [Description], 1 as Sequence UNION Select CustomerPK, Name as [Description], 2 as Sequence From Customer Order By Sequence Then when they selected 'All Customers' null was passed back to the stored procedure for the report so in the where clause of the stored procedure I had Where (CustomerPK = @CustomerPK or @CustomerPK IS NULL). This returned everything for the report when 'All Customers' was selected. If anyone has any other questions please let me know and I will help you out. Thanks.
Free Windows Admin Tool Kit Click here and download it now
June 20th, 2011 3:13pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics