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