Menu
I have a boolean parameter in a business report. If I use this parameter it shows at the parameterbar with the labels "True" and "False". Can I change the values without resorting to another parametertype (integer i.e.)?
247
According to Microsoft documentation you should be able to go to the properties of the column in the Report Model and set the Format attribute to either "truefalse" or "yesno" depending on how you want boolean values to display.
Boolean parameters define true or false values that are used as inputs for some LiveCompare actions. For example, the Write External Data Source action has a Boolean parameter as an action property to determine whether existing data is to be overwritten.
Open the dataset properties. In Expression find the dataset field with the BIT data type, set the data type to Boolean. In the Value field click on the fx symbol to build the expression. Go to Category > Parameters.
Yes, this can be done by setting Available Values for the report parameter:
However, this does change the input from radio buttons to a dropdown. Refer to this MS Connect issue for info on that bug as well as an apparent workaround.
102
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
