TIP: Alternating GROUP band colors...

[jschodde]

If you would like to have alternating white/silver band colors on your group sections, here's what you do:

1. Right-click on the group footer and select "Format Section..."

2. In the section expert dialog box, click on the "Color" tab and check the "Background Color" to be ON.

3. Click on the formula editor button next to the "Background Color" checkbox to display the formula editor.

4. Type in this formula and save:

if remainder(groupnumber,2)=0 then crwhite else crsilver

5. Now print preview and you should see alternating white/silver rows on your group!

-Jeff

 

[mbarron]

One problem though. If you have multiple grouping layers, your secondary groups are counted as a group in the calculation. You could be left with some funky looking colorations.

Also you may want to consider using defaultattribue instead of crWhite Mike

 

[jschodde]

Good points...thanks!

-Jeff

 

[lyanch]

I usually put a counter in and increment it every place I want the color to change (ie to make it look like it is on greenbar)

So my formula looks something like:

numbervar counter;

counter := counter + 1;

remainder(counter,2)=0 then crwhite else crsilver

I usually put all my intializers in the report header format sections.

Lisa

 

[jschodde]

Very cool idea...thanks Lisa.