Paginated Query
Hi,
I want to load large amount of data from MSSQL DB onto a report. I would like to paginate the query so that I only load X rows of records for the first page and then continue to load/query the rest of the records page by page until the entire query result is loaded.
I can use paginated query in my query statement but how do I integrate this with report builder (as where & when to make call for next page)?
I want to load large amount of data from MSSQL DB onto a report. I would like to paginate the query so that I only load X rows of records for the first page and then continue to load/query the rest of the records page by page until the entire query result is loaded.
I can use paginated query in my query statement but how do I integrate this with report builder (as where & when to make call for next page)?