I'm actually using DisplayTag in fact; however, the performance to export to Excel 50,000+ records wasn't ideal or fast.
-----Original Message----- From: Chris Pratt [mailto:thechrispr...@gmail.com] Sent: Thursday, April 12, 2012 1:15 PM To: Struts Users Mailing List Subject: Re: Data Grids & Excel Exports You might want to look into something like DisplayTag or JQGrid. (*Chris*) On Thu, Apr 12, 2012 at 7:24 AM, CRANFORD, CHRIS <chris.cranf...@setech.com>wrote: > I have several queries that I perform against my SQL database to get a > list of records and then iterate over them in a paginated way in JSPs. > Presently, I have a JSP for each query's output because there are > various different columns being shown depending upon the report; > however I am wondering if there is a better streamlined approach to > this rather than relying heavily on the JSP to control the columns displayed? > > Taking this one step forward, I've added Excel exports; however it's > reliant on the report export service to iterate the result set (just > like the JSP does) and add the column headings, values for each row > and perform any formatting needed. The service then hands the struts > action a ByteArrayOutputStream object that gets streamed back to the > browser through the action. > > In both cases, the JSP/service are driving what columns are shown, > controls formatting, etc. This means should a new column be added, > formatting changed, or a column removed from the JSP, one has to > remember to update the adjacent export service as well and from a > design perspective that seems redundant. I'd rather have a single > place that controls what columns are shown/hidden, manages formatting, etc. > > How has others tackled similar designs in the past? > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscr...@struts.apache.org > For additional commands, e-mail: user-h...@struts.apache.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@struts.apache.org For additional commands, e-mail: user-h...@struts.apache.org
