July 14, 2014 at 2:19 pm
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!
July 14, 2014 at 2:29 pm
If you disallow nulls, the checkbox will not be displayed. But you want to allow nulls but still hide it, right?
July 14, 2014 at 3:33 pm
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!
July 14, 2014 at 3:41 pm
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!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply