In my report I want an optional parameter to filter all records with a specific field that is not blank. I tried several scenario's without result...
In the parameter I want to set a text value like "exampletext".
In the filter I want a check: if the parameter value is "exampletext", only show the records where field "abc" is not blank.
On the tab Filters from the Table properties I can set three values: Expression, Operator and Value.
Please help!
I've found the solution.
Expression: =Iif(Parameters!Parameter.Value="exampletext",(Fields!Fieldname),"NULL")
Operator: >
Value: 0
No comments:
Post a Comment