2

I am having report, that has thousands of records. At the first it loads all the data, and it takes so much time to fetch data.

Is there any way to apply my own logic for paging.

For Example

At the first Only 10 records must be displayed and when i click on next button another 10 records displayed.I mean to say on every action only 10 records must be fetched from the database.

JSuar
  • 21,056
  • 4
  • 39
  • 83
Aijaz Chauhan
  • 1,511
  • 3
  • 25
  • 53
  • I recommend checking out the [answers to this question](http://stackoverflow.com/questions/1079162/when-to-use-rdlc-over-rdl-reports). It sounds like you want a RDL rather than and RDLC (which is client-based). Then you could perform the paging on the server like you are requesting. – JSuar Dec 23 '13 at 13:59
  • Did my answer help at all? – JSuar Dec 30 '13 at 19:23
  • Actually i am using PostgreSQl as my back end, so is it possible to use rdl? – Aijaz Chauhan Dec 31 '13 at 05:24

1 Answers1

1

Edit 0

Resources for RDL and PostgreSQL:

You are interested in RDL which is the server side portion of the reporting services.

RDL files are created by the SQL Server 2005 version of Report Designer. RDLC files are created by the Visual Studio 2008 version of Report Designer.

RDL and RDLC formats have the same XML schema. However, in RDLC files, some values (such as query text) are allowed to be empty, which means that they are not immediately ready to be published to a Report Server. The missing values can be entered by opening the RDLC file using the SQL Server 2005 version of Report Designer. (You have to rename .rdlc to .rdl first.)

via https://stackoverflow.com/a/2918209/1085891

Pagination Resources

Understanding RDLC and RDL

Community
  • 1
  • 1
JSuar
  • 21,056
  • 4
  • 39
  • 83