Data Browser - Viewing Site  Sector 23 Code Bank Logged in as:  Guest  


SSRS - Comparing multi-value parameter to NULL crashes report viewer
In SQL Server Reporting Services 2005:

I have a multivalue parameter with options 0, 1, and 2 (@Category).

I have a table with options NULL, 1, and 2 in column Id.

I need to filter the table based on the mutlivalue options, with NULL = 0 (since multivalues cannot include null).

However, none of the following filters work. If you run the report and select the '0' option, the report freezes/crashes every time, forcing a kill from task manager.

Attempt 1:
ISNULL(Id,0) IN ( @Category )

Attempt 2:
(Id IN ( @Category )
OR (0 IN (@Category) AND Id IS NULL))

Attempt 3:
( Id IS NOT NULL AND Id IN ( @Category )
OR (0 IN (@Category) AND Id IS NULL))

How can basic SQL not be supported by the report???

It works fine if Id is not NULL.

Created By: amos 9/30/2011 11:24:38 AM