使用迭代参数的 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 值
  • 为组设置分页符