Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Remove Null checkbox in SSRS Expand / Collapse
Author
Message
Posted Monday, July 14, 2014 2:19 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 11:09 PM
Points: 21, Visits: 64
Dear all:

1. We had this requirement to remove the null checkbox next to the parameter. Anyone has any idea how to do that.
Please refer to Capture.JPG for the parameter color which is a single-valued parameter that allows null, how to remove the Null checkbox on the right.

2. For a single-valued parameter that has a dropdown list that allows null, please refer to the Capture2.JPG for parameter Lab ID2, how not to show null but rather a blank.

Are those doable at all in SSRS?
Thank you for the help!


  Post Attachments 
Capture.JPG (9 views, 8.80 KB)
Capture2.JPG (9 views, 9.60 KB)
Post #1592343
Posted Monday, July 14, 2014 2:29 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 10:45 PM
Points: 704, Visits: 4,497
If you disallow nulls, the checkbox will not be displayed. But you want to allow nulls but still hide it, right?
Post #1592347
Posted Monday, July 14, 2014 3:33 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 11:09 PM
Points: 21, Visits: 64
pietlinden (7/14/2014)
If you disallow nulls, the checkbox will not be displayed. But you want to allow nulls but still hide it, right?



That's correct!
Post #1592361
Posted Monday, July 14, 2014 3:41 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 11:09 PM
Points: 21, Visits: 64
MaggieW (7/14/2014)
Dear all:

1. We had this requirement to remove the null checkbox next to the parameter. Anyone has any idea how to do that.
Please refer to Capture.JPG for the parameter color which is a single-valued parameter that allows null, how to remove the Null checkbox on the right.

2. For a single-valued parameter that has a dropdown list that allows null, please refer to the Capture2.JPG for parameter Lab ID2, how not to show null but rather a blank.

Are those doable at all in SSRS?
Thank you for the help!


I think I just solved the first requirement by configure the parameter from 'Allow null Values' to 'Allow Blank Values' by doing so I need to change my SPs according in where Clause from where Color =@color or @color is null to Color =@color or @color =' '
However I still need a solution for the second requirement.
Thank you!
Post #1592365
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse