Hi All,

Chart in a report is programmed to populate for each record fetched from the dataset.
This is taking very long time for data with more than 200 records.
Is there any option is SSRS to process the dataset for first 20 records in first page
and display them.
However, when i goto next page the report should process the next 20 records and show them.
So that the processing time could be reduced and the first page of the report is rendered faster.

Thanks in Advance...

Hi, 

According to your description, you want to display 20 records on per page and only retrieve 20 rows records from data source each time when rendering, right? 

In Reporting Services, all the data from data source is pre-retrieved before rendering. And the query will only executed one time during data retrieval stage. Its unlike web application that we can pass a page number into query and make it query specific amount of records on each page. When it goes to next page, the query execute again and return the next 20 records. This working mechanism is by design in Reporting Services. So your requirement cannot be achieved. 

If you have any question, please feel free to ask. 

Regards, 
Shrek Li