Search code examples
reporting-servicesgroup-byparametersmulti-selectssrs-tablix

Group by multi select parameter in ssrs

I have a multi select parameter in SSRS report. I for each option selected there are records in table.

I wish to show a table which is grouped by "option" selected in multi select, as shown in image. I am using =Parameters!IncidentNo.Label(0) in first column but its picking up first record always.

Grouping is not a problem but first data should be correctly loaded in report.

Records highlighted with red belongs to second option selected.

enter image description here

enter image description here

Solution

  • By useing hte expression 

     =Parameters!IncidentNo.Label(0)

    You are telling SSRS that you want to show the first (index 0) entry from the list of parameter labels from the IncidentNo parameter.

    You need to simply choose the incident number field. If you click in the text box you should get a drop down to choose from, if not just edit the expression to something similar to this

    =Fields!MyIncidentNoField.Value