开发者

Passing distinct Multiple Parameters in SSRS

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜