Have Geek Brain

RDLC report: more than one page? Custom page breaks?

I have a Microsoft Reporting Service report (Local Report, VS2005) and I am trying to create a pretty tricky report ...

I have two tables returned from a SQL query. The first is a master table, which has a set ID list corresponding to the record sets in the second, and has an entry set like this:

+----------------------+
| SetID                |
+----------------------+
| 1                    |
| 2                    |
| 3                    |
| ...                  |
|                      |

The second table is a list of bakers, 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 one page for each set, and each Set page contains a list of its bakers.

Can anyone point me in the right direction to cripple RDLC? :)

Hooray!

0


a source to share


1 answer


You can only accomplish your task with a second set of tables / data and parent and detail groups in the table or list.

Parent groups in SetID. Detailed groups at BjorkID. Set appropriate page breaks.



NTN

+1


a source






More articles:


All Articles