Loading Report Data in Batches
Posted: Fri Jul 12, 2013 5:29 pm
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
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