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!