Tuesday, September 29, 2009
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.