Microsoft Reporting Services 2008 - 多值参数 - 新页面
我正在创建一个报告,其中参数选择= customer_name,并且该报告是一页,并且有 5 个与客户相关的 tablix。我的团队希望能够一次选择多个客户以节省时间;但是他们希望每个 customer_name 有一个单独的页面。这可以通过多值参数来完成吗?如果可以,我如何分组以使数据不会相互混合?
前任。 ABC客户 租金表 费用表 分页符 EFG 客户 租金表 ExpenseTablix
我想太多了???请帮忙;-)
I am creating a report where the parameter selection = customer_name and the report is one page and has 5 tablix relating to the customer. What my team would like is to be able to select more than one customer at a time to save time; however they want a separate page per customer_name. Can this be done with multi-value parameter and if so, how do I group so that the data does not comingle with each other?
Ex.
ABC Customer
RentTablix
ExpenseTablix
PAGE BREAK
EFG Customer
RentTablix
ExpenseTablix
I am over thinking this??? Please help ;-)
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
在报告参数上启用多选选项。将其传递给您的报告过程,确保其得到正确处理(我认为这是一个以逗号分隔的列表)。在报表中添加一个列表控件,并将所有tablix控件放入列表区域。将列表区域上的分组设置为基于客户,并在列表控件中指定客户更改时的分页符。
On the report parameter enable the multi-select option. Pass this through to your reporting procs ensuring it's handled properly (I think it's a comma seperated list). In the report add a list control and put all the tablix control into the list area. Set the grouping on the list region to be base on customer and specify a page break on change of customer in the list control.