title: Keep Group on One Page using Reporting Services
body: <p>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.  </p>
  
  <p>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.</p>
  
  <p>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.</p>
  
  <p>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:</p>
  
  <p>Example:</p>
  
  <p>Page one:
  1/2 of 2004 because the data started half way through 04</p>
  
  <p>All of 2005</p>
  
  <p>First half of 2006</p>
  
  <p>Page2:
  Second Half of 2006</p>
  
  <p>What I would rather do is push all of 2006 to page two.</p>
  
  <p>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. </p>
  
  <p>Any help that can be provided will be much appreciated.</p>