I am using SSRS 2005 SP3. I have the following query that I use for my parameter:
SELECT 0 AS c1, 'NOT Specified' AS c2 UNION
SELECT 1 AS c1, NULL AS c2 UNION
SELECT 2 AS c1, 'Test 1' AS c2 UNION
SELECT 3 AS c1, 'Test 2' AS c2
Let's call my parameter prm1. The type of prm1 is string and it has "Allow null value" and "Allow blank value" options ticked. C1 is the value field and C2 is the label field for prm1.
When I preview the report, and I didn't see NULL in my drop down list, but that record has been shown as 1 (which is the value).
I am wondering if this is a normal behavior of SSRS?
It's not a big deal. I can replace NULL with something else, but I am just curious.
View Complete Post