I'm trying to use SSRS to print a "batch" of 1-page invoices. The invoice has a "header" that lays out well in a list data region linked to dataset1. The "detail" section lays out well in a table data region linked to adataset2.
Dataset 2 have a FK reference field to dataset1. I've tried using parameters to pass the values of the "header" to the "detail" region, but running the report simply prints all the "header" instances (one per page like it should), and then lamely prints 1 collection of detail records on the last page.
I have the same problem if I lay out the report as a List data region followed by a subreport. When the report is run, I still get all the "headers" printed in the collection, with only the last page having any details.
Any suggestions and/or pointers to tutorials will be most welcome. Note: the layout requires a list area (e.g., not table or matrix) for the header information. I can get all the data to print just fine in a classic tabular layout. Likewise, I can create a combination List + Table layout where dataset1 selects a single instance (e.g., I print exactly 1 page per report run) AND dataset1 and dataset2 accept feed a report parameter to a query parameter that consists of the PK of the header. What I'm missing is how one lays out a non-tabular report where there is a collection of headers that need to iteratively pass an "inner parameter" to a nested table.
Thx.