开发者

Dynamic Grand-total with lists and multi-value parameters

Basically I've created a list that subtotals according to the group.

I then created a multi-value parameter that allows the user to choose which group is shown in the report.

How can I get the grand total to refl开发者_运维知识库ect the parameter since its currently outside of the list?


To have your grand total reflect the parameter, you could place it in a one-row table (with no header/footer). Group by the same expression as your list, then filter the table by your parameter:

=Fields!YourField.Value = Parameter.YourParam.Value(0)

Finally have your grand total field, in the table, use the expression =CountRows() to get the correct number.

Hope this helps! --Dubs

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜