使用迭代参数的 SSRS 创建报告
我正在修改现有报告,该报告设置为让您查看每个销售代表的统计数据.您可以通过更改报表视图中的参数 sales rep
来完成此操作.
I am modifying an existing report which is setup to let you view statistics per sales rep. You do this by changing the parameter sales rep
in the report view.
我需要修改报告,以便它可以为每个销售代表显示一个页面.然后将其导出到 Excel,每个销售代表的统计数据都显示在单独的选项卡中.
I need to modify the report so that it can display a page for each sales rep. This will then be exported to Excel with each sales rep statistics being displayed in a separate tab.
我对此进行了研究,发现有人在谈论重复报告,但我不认为他们所指的也正是我要问的:
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/27ffabcc-6286-4fed-a8bf-0e5d78560be3
http://jameskovacs.com/2005/08/04/深入挖掘报告服务/
I have researched this and found people talking about iterating over a report but I don't think that what they are referring too is what I am asking:
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/27ffabcc-6286-4fed-a8bf-0e5d78560be3
http://jameskovacs.com/2005/08/04/digging-deep-into-reporting-services/
你可以通过多种方式来实现,所以这里有 1 个建议
You can accomplish this several ways, so here is 1 suggestion
- 创建一个新的 tablix 报告,其查询返回一组(唯一的)所有销售代表
- 按销售代表分组
- 没有详细信息行,但在组页脚/页眉中添加子报表
- 子报表将是您已经在使用的报表,它的参数将是您的主报表查询中的 sales_rep 值
- 为组设置分页符