Loading Report Data in Batches

[307sushant1527]

Hi Team,
I have a button "Load Report".
When i click on this button i pass a sql string "select fname,lname,bdate,email from DimEmployee" from javascript to sql and get dataset using a wcf service.
The table has 18,000 rows of data.So after clicking the button i have to wait approx 2 min for viewing the report.

So is it possible to load data in blocks?????????

Eg : initially first page will be loaded and then when i scroll 2nd page n so o.

I checked cache mode property but in that case also for caching the data i need to bring entire data first.

18,000 rows is just an eg data might be bigger than that.
Is there a solution for this????
If, Yes , Can you attach s sample for the same

[Alex K.]

Hello,

Unfortunately, this feature is not supported. Please try to split report or use the filtering.

Thank you.