I have a metrics report designed in SSRS 2012 which uses a SharePoint list as the base parameters for an Oracle back end.
I have been able to get multiple parameters to work in my reporting but have come to a road block.
My issue is that some of the parameters could have multiple values themselves.
My base query is:
SELECT service, app
FROM Event
WHERE SERVICE_ID IN (:service)
GROUP BY service, app
I have the parameter set to allow multiple values.
Example parameter data is (service):
1 Trench
2 Disk, Rake, Truck
3 Plow
If I select all the parameters, my expected output should give me:
1 Trench Northern
2 Disk Midwest
3 Rake LineDrive
4 Truck Alpine
5 Plow GreenStar
Any assistance and direction is greatly appreciated!