sql - SSRS report repeat table for every parameter value -

guys sorry general question here have been looking on internet , cant find solution.

i have ssrs report. there 1 parameter user must put in before running, @location.

in query specified return results location matched. i.e. where company.location = @location

the results displayed in table. works fine, want change parameter contain multiple values.....and repeat table every location user chooses.

any appreciated.

step 1: create dataset multi-valued parameter, this:

select locationid, locationname mylocations

step 2: create parameter @locationid, available values above dataset, , set allow multiple values.

step 3: create dataset along these lines actual table:

select * mydatatable tbl tbl.location in (@locationid)

step 4: create list, bind second dataset (select list, find "dataset" property).

step 5: open properties details of list, group on locationid.

step 6: drop tablix inside list, , pick fields dataset2 tablix @ leisure.

step 7: ...

step 8: profit!

ps. there several alternatives available this, including:

KHS