Thanks, Bob. I've found a jQuery project that looks pretty promising. I do appreciate the pointers, so many ways to skin a cat.
-----Original Message----- From: Bob Schellink [mailto:[email protected]] Sent: Friday, December 03, 2010 8:42 PM To: [email protected] Subject: Re: Pivot Data table structure I've experimented creating a one-to-one mapping to HTML 's Table at the ClickClick[1] project[1]. While Click's table is column based, ClickClick has a row/cell based Table which mimics HTML's table. However in practice I've found plain markup (or a macro) easier to use. Kind regards Bob [1]: http://code.google.com/p/clickclick/ On 4/12/2010 07:23, Bob Schellink wrote: > Hi John, > > It might be easier to use Velocity or a macro instead of a control? > > Kind regards > > Bob > > On 4/12/2010 02:29, Kuhns, John wrote: >> I need to present pivoted data in a manner similar to this: >> _________________________________________________________ >> _________|2008_______________________|2009_______________________| >> |Region__|Q1____|Q2____|Q3____|Q4____|Q1____|Q2____|Q3____|Q4____| >> |North___|__1234|__5678|__1234|__5678|__1234|__5678|__1234|__5678| >> |East____|___929|___829|___789|___934|__1200|__1450|__1400|__1198| >> |West____|__4444|__5555|__6666|__7777|__8888|__9999|__9999|__9999| >> |South___|__3456|__2345|__6789|__3456|__2352|__5464|__3426|__9837| >> >> There may be any number of sub groups in columns and rows, for example: >> ____________________________________________________________ >> ________|2008_______________________________________________________| >> |Region_|Q1____________|Q2____________|Q3____________|Q4____________| >> |_______|Jan_|Feb_|Mar_|Apr_|May_|Jun_|Jul_|Aug_|Sep_|Oct_|Nov_|Dec_| >> |North__|_123|_568|_124|_568|__92|_829|_124|_568|_124|_568|__99|_829| >> >> and: >> _________________________________________________________ >> ________________|2008_______________________|2009_______________________| >> |Region__|State_|Q1____|Q2____|Q3____|Q4____|Q1____|Q2____|Q3____|Q4____| >> |North |MI____|__1234|__5678|__1234|__5678|__1234|__5678|__1234|__5678| >> | |OH____|__4444|__5555|__6666|__7777|__8888|__9999|__9999|__9999| >> |________|IN____|__3456|__2345|__6789|__3456|__2352|__5464|__3426|__9837| >> |East |NY____|__1234|__5678|__1234|__5678|__1234|__5678|__1234|__5678| >> | |PA____|___929|___829|___789|___934|__1200|__1450|__1400|__1198| >> >> Or any combination thereof. I need to be able to add extra row headers and >> set >> colspan and also set rowspan and make the rows color scheme match the header. >> >> I started writing a subclass of Table, but then I figured someone out there >> has probably already done this. Anyone? >> >> > >
