Solved

MSSQL ReportViewer - Paging Not Working

Posted on 2009-07-01
1
945 Views
Last Modified: 2012-05-07
I've got a reportviewer control in C# utilizing ASP.NET (provided by Microsoft for MS SQL 2005 reporting service, and it's the most current SP1 redistribution.) The reports are populating in the control fine, the only problem is that it's not paging. If the report calls for multiple pages, then the control makes it into one long page.

The "Interactive Height" and "Interactive Width" are both set in the report (to 8.5 x 11) so I'm not sure what else could be going wrong here.

Thanks!
-Tyler
0
Comment
Question by:TogaMario
1 Comment
 

Accepted Solution

by:
TogaMario earned 0 total points
ID: 24760697
I found the solution to this to be much more simple than any troubleshooting that might come from this thread. I piped the ReportViewer1.ServerReport.Render function output of byte data into a PDF file created on our file server (which it needed to do anyway ...) and then just linked to that file with Response.Redirect.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now