Solved

SQL Server Reporting Services 2005 with ASP.NET 2.0 ReportViewer Control - Need Page Size....

Posted on 2007-11-27
2
2,519 Views
Last Modified: 2013-11-26
Hi,

I am using ASP.NET 2.0 with SQL Server Reporting Services 2005. I have created SQL Server Report and i am calling this report from ASP.NET web page using ReportViewer control (By embedding the report in reportviewer control). Here is my question:

How can i display 100 records per page using ReportViewer control while displaying the sql server report ? I have seen so many articles but never gave me an idea how can i achieve this ? Can you please provide me the sample code / properties needed to solve my issue ?

Thanks
0
Comment
Question by:kishore_peddi
2 Comments
 
LVL 29

Accepted Solution

by:
QPR earned 500 total points
ID: 20363088
0
 

Author Comment

by:kishore_peddi
ID: 20363386
Here is the summary:

Hello,

I am using a ReportViewer control in my web application. I was curious on how I can enable paging for the ReportViewer control so the user does not have to scroll endlessly through the data that is returned. I couldn't find any obvious properties on the control itself. Thank you for any advice.

 ~zero

I ended up finding the answer to this. Within ReportingServices you must set the "InteractiveHeight" to a number greater than 0. If it is set to 0 paging will be disabled which in my case it was. By setting it to 5, paging returned.

Thanks
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

867 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

15 Experts available now in Live!

Get 1:1 Help Now