RDLC 报告：不止一页？ 自定义分页符？
我有一个 Microsoft Reporting Services 报告（本地报告，VS2005），并且正在尝试生成一个相当棘手的报告...
我有两个从 SQL 查询返回的表。 第一个表是一个主表，其中包含与第二个表中的记录集相对应的集合 ID 列表，并且具有如下所示的记录集：
+----------------------+
| SetID |
+----------------------+
| 1 |
| 2 |
| 3 |
| ... |
| |
第二个表是 bjorks 列表，让我们称之为 bjorks。 它看起来像这样：
+----------+-------+-----------+-----------
| BjorkID | SetID | BjorkName | ...
+----------+-------+-----------+-----------
| 1 | 1 | Bob |
| 2 | 1 | Jones |
| 3 | 1 | Smith |
| 4 | 2 | Jack |
| 5 | 2 | Daniels |
| 6 | 3 | Moo |
| 7 | 3 | Bean |
| 8 | 3 | Bond |
| 9 | 3 | Jim |
| ... | ... | ... |
| | | |
现在，我需要生成一个报告，为每个 Set 打印一页，并且每个 Set 的页面包含其 Bjorks 的列表。
谁能给我指明正确的方向，让 RDLC 这么做？ :)
干杯！
I have a Microsoft Reporting Services report (local report, VS2005) and am trying to produce a rather tricky report...
I have two tables returned from a SQL query. The first is a master table that has a list of set ID's corresponding to sets of records in the second, and has a record set like so:
+----------------------+
| SetID |
+----------------------+
| 1 |
| 2 |
| 3 |
| ... |
| |
The second table is a list of bjorks, let's call them. It looks like this:
+----------+-------+-----------+-----------
| BjorkID | SetID | BjorkName | ...
+----------+-------+-----------+-----------
| 1 | 1 | Bob |
| 2 | 1 | Jones |
| 3 | 1 | Smith |
| 4 | 2 | Jack |
| 5 | 2 | Daniels |
| 6 | 3 | Moo |
| 7 | 3 | Bean |
| 8 | 3 | Bond |
| 9 | 3 | Jim |
| ... | ... | ... |
| | | |
Now, I need to generate a report that prints off one page for each Set, and each Set's page contains a list of its Bjorks.
Can anyone point me in the right direction to mangle RDLC into doing this? :)
Cheers!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您只需使用表或列表上的第二个表/数据集以及父组和详细信息组即可完成任务。
SetID 上的父组。 BjorkID 上的详细信息组。 相应地设置分页符。
华泰
You can accomplish your task with just the second table/data set and parent and detail groups on a table or list.
Parent groups on SetID. Detail groups on BjorkID. Set your page breaks accordingly.
HTH