SQL Server Home
Custom Lables for Boolean Options Not Displaying
1/6/2009 5:36:39 PM
User(s) can reproduce this bug
When adding available values to a boolean data type input parameter the designed displays a drop down menu, but the SSRS server displays radio buttons in both IE and FF.
SQL Server 2005 SP2 - Standard Edition
Win2003 Standard Server (SP2)
Operating System Language
Steps to Reproduce
Create a report with an input parameter with the data type boolean. Put in two items into the list of available values; one with a value of true, and one with a value of false. Display the report in the designer and in a web browser.
In the designer a drop down box is showed with the values you entered.
In the browser radio buttons are displayed ignoring the values you entered.
Both should show the drop down menu.
to post a comment.
Please enter a comment.
on 9/21/2010 at 2:51 PM
My expectation is different from Qualicon's. I want a drop-down box, and it may have 3 items in it (when NULL is allowed). It is quite annoying that in Visual Studio it displays a drop down menu, but on the report server shows radio buttons. I *could* handle radio buttons, but they don't display the text that I specified, just True and False.
I did get the display I wanted, but only by changing the data type of the parameter to Integer, which isn't actually correct since it is passed in to a stored procedure against a boolean parameter.
on 4/24/2010 at 8:22 AM
My expection is:
Present the two custom-defined values (for example Yes/No) as radio buttons in the report viewer and NOT as a drop down box.
A boolean standard works with radiobuttons for True and False.
These texts for the radio button should be changable.
on 1/13/2009 at 4:00 PM
Thank you for reporting this issue. This issue has been addressed in SQL Server Reporting Services 2008. You can work around this issue in SQL Server Reporting Services 2005 by specifying an expression for the boolean valid value (ie ="True").
to post a workaround.
Please enter a workaround.
© 2014 Microsoft