locked
ReportViewer doesn't handle paging properly RRS feed

  • Question

  • I have a user that runs a report through the reportviewer control.  When they render the report it only shows 1 page, but if we run the report through report manager it shows 3 pages.  This happens using SQL 2008 SP1 reporting services.  This problem does NOT occur in the 2005 environment we have.
    Thursday, October 7, 2010 5:53 PM

Answers

  • I opened a case with MS, and this is a BUG with the ReportViewer control for SQL 2008.  They said this is fixed with R2, but I can't confirm that as I'm only on 2008 sp1
    Monday, October 11, 2010 6:57 PM

All replies

  • I've experienced issues with pagination in both Report Manager and ReportViewer.  I think the main issue is that they render in HTML which is not very page friendly.  Are these paging issues missing hard page breaks or soft page breaks?  It should handle hard page breaks pretty well--like showing a new customer on a new page because you set the paging in design view.  The soft page breaks always seem to be a gamble.

    Thursday, October 7, 2010 6:02 PM
  • The problem is occuring with both soft and hard page breaks.
    Thursday, October 7, 2010 7:32 PM
  • I opened a case with MS, and this is a BUG with the ReportViewer control for SQL 2008.  They said this is fixed with R2, but I can't confirm that as I'm only on 2008 sp1
    Monday, October 11, 2010 6:57 PM
  • I have same problem with VS 2010 and SQL server 2008 R2. Report viewer only shows first page. When I exported report as pdf, it had 2 pages. Same thing when I printed the report, 2 pages printed. Can you please tell me it is bug of report viewer in Visual studio 2010 or SQL server 2008 R2???
    Tuesday, December 7, 2010 9:18 PM
  • I am having the same problem with report viewer 10 and SQL server 2008 R2. What should I do to work around this? Paging in the report viewer only shows Page 1, but export displays them all.
    Thursday, October 25, 2012 4:43 PM
  • Same problem.... the viewer shows only one page but PDF renders into a few pages. An option to force page break at the end of each footer will be nice... 
    Wednesday, November 14, 2012 1:43 PM
  • Same issue I have.

    shahsank

    Friday, September 6, 2013 11:24 AM
  • They lied. The issue still exists in 2008 R2 AND 2012. They lied to you. Microsoft lies. A LOT!
    Tuesday, December 10, 2013 8:44 PM
  • So CLEARLY this has not been fixed. STOP LYING MICROSOFT AND JUST FIX THE SHIT!
    Tuesday, December 10, 2013 8:45 PM
  • i have worked on this,

    in my case Tablix property "Keep data on one page" was true. and to change it to "False" resolve my issue.

    So Please follow below steps:

    1. Right click on tablix control.

    2 Unchecked "Keep together on one page if possible".

    this may resolve your issue as it worked for me..

    hope this will help...mark it as answer if it help you.


    shahsank

    • Proposed as answer by ShashankJain Tuesday, May 20, 2014 6:07 AM
    Tuesday, May 20, 2014 6:07 AM