Tuesday, September 29, 2009

SSRS-Keep Together

I was working on a building a SSRS report for the end users, got all the data ready and the queries worked out. Got to design the report by using the tablix control and attached the dataset to the control, the groups were created. I started to preview the report, the data was groupd by ID at the parent level and then there were the details. In the report the detail data for a one ID was spawning over several pages. This was getting difficult to understand the data on the report. Basically I wanted to keep the detailed data for a particular ID all together on one page. In the properties of tablix control, in the general section, under Page Break Options. there is an option called Keep Together On One Page If Possible. I checked this option and re-ran the report in the preview mode, this time the results were more in line with the users expectations. The detailed data for a particular ID was fiited on one page, then there was a page break to display the data for the next ID. I find this option very useful especially in complex reports where there are 2 tablix controls with the same dataset using the same grouping but displaying different parts of the detailed data.

3 comments:

  1. What is difference between "keep together" property in Property window for a given table and this property for the Tablix (keep together on one page if possible)?

    ReplyDelete
  2. Hi,
    The table/tablix control, the tablix is a new control which was introduced in sql server 2008. The keep together option applies to
    to individual detail
    rows i.e. if you have multiple detail lines, they can still span pages.
    For the table/tablix the keep together attempst to keep the individaul detail rows on one page if possible.
    There are bugs which users have identified with this property and filed...

    ReplyDelete
  3. Table is subset of the tablix and nothing else.

    ReplyDelete