Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2550
  • Last Modified:

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

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
kishore_peddi
Asked:
kishore_peddi
1 Solution
 
kishore_peddiAuthor Commented:
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now