开发者

Passing distinct Multiple Parameters in SSRS

开发者 https://www.devze.com 2023-04-07 00:59 出处:网络
I\'m in a peculiar situation here. I have a report which takes @ProjectID as a parameter and shows all the info related to that project.

I'm in a peculiar situation here. I have a report which takes @ProjectID as a parameter and shows all the info related to that project.

Now I have to pass multiple project ids separately as 开发者_如何学运维parameters to the report and each report(ProjectID) should show in a distinct page.

I did research on Multivalues parameters but could not find a way to accomplish this. Any advice is much appreciated.


Create the @ProjectId parameter as multivalue

In your SQL query use the multivalue parameter using IN eg. WHERE ProjectId IN (@ProjectId)

Add a table group, grouping on ProjectId field. In the group settings enable "Page break at end"

0

精彩评论

暂无评论...
验证码 换一张
取 消