Post reply

Is custom paging available - pulling 500,000 records into a report!

  • December 20, 2005 at 4:09 pm

    #166271

    Hello,

    As the subject atests, I am doing a query on a large database and a report may bring back half a million records. Preliminary tests look like the whole report (all 500K) are coming back instead of a page at a time.

    Is there a switch (wishful thinking?) or do I have to code some custom paging?

    Thanks in advance.

    Greg

  • December 22, 2005 at 7:11 am

    #611115

    You might look here:

    http://www.codeproject.com/aspnet/PagingLarge.asp#xx820606xx

     

  • December 22, 2005 at 11:42 am

    #611201

    That's a great page James and I am away of this issue. This is the reason I want to find out if there is a simpler workaround for Reporting Services.

    Hoping for a config switch or other magic.

    My thinking so far is to have all of my paging done in the db and have my *.aspx page send the page number needed as a parameter to a stored procedure that does my query and returns the group (page) of results I'm after along with how many pages in total.

    Greg

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply