We have some reports that allow null values for parameters and I find the "Null" label next the parameters in the report viewer to be completly the wrong thing i want to show to business users.
Has anyone worked out a way to change this label to something more meaningful?
aaron
The only solution for this could be using a conditional expression in the field which you are using to display the parameter. In the textbox, use an expression something like this:
IIf(IsNothing(Parameters!YourParameter.Value, "Some Meaningful Text", Parameters!YourParameter.Value))
Shyam
|||Shyman, I should have been more specific. This is to do with datetime fields, where the allow blank field is ticked and disabled but will not allow blank, so we had to set the allow null flag. Which is fine, i just hate the text it displays.thanks
aaron
No comments:
Post a Comment