January 24, 2012 at 10:52 pm
Hi Guys, I have a report with 2 tables. The 1st table(LOGS) is a summary of the data and needs to appear on each page. The other table(TASKS) is a break down of the 1st and can extend over many pages.
The 1st is only ever 1 line.
How can I get the 1st table to repeat on each page? In Crystal you could just put the table in a page header.
Can I use some other tool to achieve this?
Thanks
Ian Cockcroft
MCITP BI Specialist
January 25, 2012 at 7:11 am
I have never tried to put a table in the header in SSRS so I don't know if it is possible, but I assume you have tried it already. You can construct a "table" in the header using individual textboxes and populate them with the First record of each column in the dataset. Since your dataset is always one record this shouldn't be a problem.
January 25, 2012 at 4:52 pm
I think what you want to do is add a single Tablix control. Add a row group for whichever field makes LOGS unique, make sure to include a group header. Make the group page break between each instance. (Group Properties > Page Breaks). add all of your LOGS columns to the group header row (add more rows if needed). Add the TASKS data in the Details row.
This should produce a report with the LOGS info in the first row, the TASKS detail in subsequent rows until the group is done, then new page and etc.
This is assuming that you have the data in one data set. If it's not, then you can probably use a sub-report in the detail row instead.
and fyi - can't add any data except globals in the page header/footer
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply