Colorful Groupings

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.


Background


Colors1:


Font


Colors2:


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.


Colors3:


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.


Colors4:


and you're done. Of course if you have multiple groups, just color accordingly. Sample files here. Hope thats what you were after Bill ?

Comments:

Hi TIm, Thank you for posting this out there. It was able to help me address part of my reporting problem. I am stuck with trying to get subtotal information from two groups that exist in my XML data. I hope this is clear. My two groups are account type and account rev_exp. My detail is at the accout rev_exp and my summary is at the account type level. I am now able to get the totals to show up in my report but at the end of it, not with the correct account type. If you could address this I would be most appreciative. Thanks Gwen

Posted by Gwen on August 26, 2009 at 05:35 AM MDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Follow bipublisher on Twitter Find Us on Facebook BI Publisher Youtube ChannelDiscussion Forum

Join our BI Publisher community to get the most and keep updated with the latest news, How-to, Solutions! Share your feedback and let us hear your voice @bipublisher on Twitter, on our official Facebook page, and Youtube!

Search

Archives
« July 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
  
       
Today