title: Report viewer taking a long time to load reports
body: <p>I have an form that prints all items, This is what the users sees when the form is first loaded:</p>
  
  <p><img src="https://i.stack.imgur.com/fM08z.jpg" alt="enter image description here">
  This report prints multiple pages with only 9 columns changing each time. There are a total of 4652 pages total and it takes 5 minutes to load all those pages onto the report viewer. Each item has two pages there are a total of 2326 items.</p>
  
  <p>When the user click print preview</p>
  
  <p><strong>page 1 of report</strong></p>
  
  <p><img src="https://i.stack.imgur.com/V9CxC.jpg" alt="enter image description here"></p>
  
  <p>**page 2 of report **</p>
  
  <p><img src="https://i.stack.imgur.com/flFzD.jpg" alt="enter image description here">
   The second time i ran the same report it loaded the report from cache in a time of 1 and 1/2 minute that is a significant difference </p>
  
  <p>My question is what can i do to enhance the performance of the report. The database and application are on the same machine and the performance is terrible, the user wants to install the application at the 4 plants with sql server and the performance is going to be a even bigger problem due to the fact that multiple people will be accessing the application, we will have network bottlenecks. From Sql Server point of view i added indexes, updated the statistics, try to see if there is a way i can make the query fetch the results faster but from a report viewer and report designer point of view i am clueless any help will be much appreciated.</p>