I created a report as part of a C# application using Reporting Services and I cant find some functionality I am used to seeing in other environments. I believe both MS Access and Crystal reports have an option called "Keep Together" so that you can keep a specific grouping of data on one page instead of the information being split over two pages.
How do I do that using 2005 Reporting Services when my report is rendered locally in a C# app and viewed using the .net report viewer. Essentially, I want to keep all records for a certain year on one page. I am using Visual Studio 2008.
The year is one of the columns and the number of rows for one year is always smaller than a page. My report uses just one table and has an innermost grouping by year and then another outer grouping by client name.
Currently I can fit two years of data on the report, however, if the data starts half way through the first year, then I get the following:
Example:
Page one: 1/2 of 2004 because the data started half way through 04
All of 2005
First half of 2006
Page2: Second Half of 2006
What I would rather do is push all of 2006 to page two.
I am currently using a table for all of the data in the report. There is a keep together option at the Table level, but I need one at the Group level. In this case the Grouping by year.
Any help that can be provided will be much appreciated.
Thanks,
Jeremy