On Mon, May 27, 2013 at 11:40 PM, Ajas Mohammed wrote: > Can you share your experience in creating Report Design for HTML reports > returning 8000 or more than 8000 records from a DB (query or stored proc). > 8000 is just a number I picked. usually our reports return from 10, 100, > 1000, 10000 or even more records. >
I typically try to steer people to 100 of less records on the page at a time for web based reports. Search / pasing works to help reduce the number of records on the screen (and sent to the browser) at a time. If they REALLY want to see more than about 1000 records on a single continuous page, I push for Excel exports, or in a worst case scenario write it out to a static HTML file and redirect them there. At a certain point though, the browser will choke and there is nothing really technically that can be done about that. -Cameron
