How to use a multi-value parameters in report groupings

Question

I am building a new report that contains Location (ex. California, New York, Texas..), Department (ex. Finance, Enrollment, Claims..) which is setup to be a multi-value parameters. I was able to use 1 parameter in report row grouping, but i'm not able to use both location and department multivalue parameter in row grouping. Is this scenario possible in SSRS?

Answer 1

Assuming your parameters are labelled ParamDepartment and ParamLocation, you need to modify the sql dataset for the tablix to include at the end (after the group by clause):

HAVING (tbl_xyz.Location IN (@ParamLocation)) AND (tbl_xyz.Department IN (@ParamDepartment))