function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Ramesh RageRamesh Rage 

Need to export results from VF page with pagination in Signle shot insted of per page is it possible ???

Hi Friends,

I have developed VF Page report for Portal Users which will displays records from one of Custom Object with Export Button to export results. This report can have min 200 records and max "46,000" records.

As we have view state limit in salesforce i can't display all records once so went for pagination option using Standard set controller and am displaying 2000 records at a time. Actual problem comes here, when user clicks on export button they could able to download only 2000 records (records from dat particular page not all 46,000 records at once).

Is there any way so that user can download all records once just like in salesforce report export functionality. i really Don't know to bring this functionality...looking for some ideas. Please share some piece of code or articles if you have already faced similar issue.

Thank you very much in advance.

Regards,
Ramesh
Ramu_SFDCRamu_SFDC
See if the below articles are of any help

http://www.salesforce.com/us/developer/docs/pages/Content/pages_controller_readonly_context.htm

http://salesforce.stackexchange.com/questions/794/how-to-query-more-than-50000-records-in-apex-and-bind-it-in-vf-page-in-jqgrid-an