+ Start a Discussion

Custom Report using Visualforce and Controller--urgent



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..


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: