By Tim Dexter-Oracle on Jan 09, 2008
This was going to be a holiday posting but today I found Bill on the forum who I think might actually be able to use this post ... funny world. That said I may be completely 'off' and the following prose is completely useless.
Bill's question - I want to make the report colorful, the color should be same for same group, the color should be change for every other group. Kind of did some research but cannot figure out yet.
You'll see in my follow up question - do you want colored fonts or backgrounds - either are pretty straightforward. The background needs a trick but nothing like making an elephant disappear more like hiding a coin behind a 2 year olds ear.
If we take the font colors first, they are easy, just change the font color for each group you have in the template. So in my case the vendor group is red and the inner invoice group is green.
For the background, all I have done is put the whole template inside a table except for the Vendor group fields. Then just color the table first and then the inner grouping table so its kinda on the top of the first table.
and you're done. Of course if you have multiple groups, just color accordingly. Sample files here. Hope thats what you were after Bill ?