How to specify boolean tablix filter?
Yes, that is exactly what I did but this is not filtering out records.Ryan D
November 29th, 2011 5:08pm
Nevermind, I see now that ur solution does work correctly. Thanks!Ryan D
November 29th, 2011 5:16pm
I am developing an SSRS 2008 report and have added a tablix. Now I am trying to add a filter on this tablix according to the following expression: =iif(Fields!discharge_flag.Value=1, iif(Fields!Current_status.Value=1,1,0),0) And I set data type for this expression = "Int" with a value of "1". But instead of filtering records that match these values, it includes all records. How can I successfully implement this filter? Ryan D
November 30th, 2011 4:47pm
Hi ironryan77, Thanks for your post. According to your description, you want to use the specified expression to filter the data on your tablix. If so, please refer to the steps below: 1. Right-click the corner handle of the tablix, select Tablix Properties. 2. Switch to Filters tab, and click Add. 3. Click the fx button right adjacent to the Expression drop down list, type in your expression: =iif(Fields!discharge_flag.Value=1, iif(Fields!Current_status.Value=1,1,0),0) 4. Specify the type to Integer, Operator to ‘=’, value to 1. After you complete the steps above, rerun your report to have a try. Thanks, Bill LuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.
December 1st, 2011 3:12am