In my one-page report I have a header and footer. But then I need the main body to split into two repeatable sections and I only manage to create subsections or grouping sections of my first and only repeatable section. In my database have a Master table (M) with 2 independant details tables (D1 and D2). The details tables together do not have more rows than everything will fit on one page. So I want my report to be like this:
Page Header (M)
Repeatable Section (D1)
Repeatable Section (D2)
Page Footer (M)
But I cannot find a way to add the repeatable setion for D2. No matter where I click or drop D2 fields it will always mess with D1 and create subsections or group sections.
What am I missing?
Edit: spelling
I still don't know how to do in the on the report design UI, but I opened the igr file and hacked the XML to get my second repeatable section and got it to work.
This is not how I want to do it so if anyone knows how to do it in the UI, please let me know.
Hi,
I created a data object of two collections to simulate your database tables.
And I added a section containing two subsections to my report. Then I added my data object, which is an enumeration, as a DataSource and set it as the source for the section and for each subsection. Then in each subsection I added a table with its DataContext set to one of the underlying collections. (In my sample, I called them First and Second. So the first subsection's table has a DataContext of First and the second subsection's table has a DataContext of Second.)
Each table is a repeatable element, showing the data from its appropriate collection from within the data source. And since there isn't much data to show, I can show both subsections on the same page.
If your data was such that you could use Grouping based on some field in your data, you would perhaps have the repeatable sections you were looking for. Each subsection could have its own grouping if that was required and the table or other elements would be included in the group.
Please let me know if this sample helps.