Displaying Null value on MS SQL Server Report Builder Parameters

Question

Sorry for the edit...

I am trying to display Only 'Null' option when the user choose @select=2 on the drop down list of Parameters (MS SQL Server Report Builder). The parameter displays the type from watable by querying. The problem is that the table (watable) does not contain null value. Even if it contains the Null, how to display only null option on the drop down list???

    --display type  

    IF @Select = 1
     BEGIN
         SELECT DISTINCT type
         FROM   watable
     END 
    --display null
     --display type  
    IF @Select = 2
     BEGIN
         SELECT DISTINCT type
         FROM   watable
     END

Adriaan Stander · Accepted Answer · 2015-04-30 18:04:55Z

2

How about a UNION?

Something like

IF @Select = 1
 BEGIN
     SELECT DISTINCT type
     FROM   watable
     UNION
     SELECT NULL
 END

answered Apr 30, 2015 at 18:04

Adriaan Stander

167k32 gold badges294 silver badges288 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Brian Pressler · Accepted Answer · 2015-04-30 18:06:42Z

0

Is this what you need?

--display type  

IF @Select = 1
 BEGIN
     SELECT DISTINCT type
     FROM   watable
     UNION
     SELECT NULL type
 END

answered Apr 30, 2015 at 18:06

Brian Pressler

6,7332 gold badges21 silver badges42 bronze badges

Collectives™ on Stack Overflow

Displaying Null value on MS SQL Server Report Builder Parameters

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related