BAQ report sorting incorrectly

[Dilanka (Mohotti)]

I found Exactly What I wanted to do from another post. Mentioning it here so someone else might find it helpful.

SSRS reports BAQ report designer and setting filters / sorts

Make a Sort entry for each of those, with the “Sort Field” pane blank for each [image] In the SSRS Builder, setup the tablix (Tablix1) to show the info. Add any grouping and group sorting for how it should appear for Dept - EmpID Set Tablix1’s visibility to use “Show or Hide based on the expression”, and enter the expression like =iif(First(Fields!SortBy.Value, "BAQReportParameter") <> "Dept - EmpID", True, False) Tablix1 will now only be visible when the user selected the sort D…