+ Start a Discussion
mohimohi 

Custom Report using Visualforce and Controller--urgent

Hi,

 

i am facing issue lik i have 3 object OBj1,Obj2,Obj3, and show data as per role hierarchy, if i am top hierarchy level that is pulling data for all user in the org bt ,

My data is more than 4 lack for a object and for a single user more than 50 thosands, i am makig aggregate results.

 

Facing error :too many query row reterived.. cany any one tell me how to handle this situation.with best approach ,standard reprt not required..

bob_buzzardbob_buzzard

If you need to access more than 50,000 records, you have a couple of options :

 

(1) Use batch apex

(2) Use a readonly page - this allows you to retrieve up to 1 million rows. There's information at:

 

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