Formatting Borders 1

[hgg21]

I need to create my report such that this
single field will have alternate colors.
Example:

BucketName
AAAA (in green)
BBBB (in yellow)
CCCC (in green)
DDDD (in yellow)

How can I do this?
Now I can only make it in one yellow.

Please advise.
Thanks!
Jerry

 

[paulmarr]

Jerry,

Format the field by right clicking on the field and choose Format Field.

Then go to the border tab - and click on the x+2 button next to background color and write this formula.

If Remainder(RecordNumber,2)<>0 then green else yellow

Hope this helps


paulmarr@arcom.com.au

 

[hgg21]

Hi paulmarr,

thanks for replying.

Hmm I did what u say but it doesnt work.
I didnt get an alternating back_color.
All are in yellow.

Is there anything I need to do??
Thanks for your help
Jerry

 

[paulmarr]

Jerry,

What section is the field in question?

paulmarr

 

[hgg21]

Paulmarr,

The field is in the Group Footer section.

Jerry

 

[paulmarr]

Jerry;

Try this:

If Remainder(GroupNumber,2)<>0 then green else yellow

Cheers,

paulmarr

 

[hgg21]

Paulmarr,

thanks a lot for your help!
It's working now.

However, I have one question. Is it possible to use custom colors for this? If yes how do I specific the colors?

Thanks again.
Jerry

 

[paulmarr]

Jerry,

You need to know the RGB color settings and use the
Color(r,g,b,) function - instead of the keywords green and yellow - like If Remainder(GroupNumber,2)<>0 then
Color(255,126,57) else Color(123,211,122)

Hope this helps you!

paulmarr@arcom.com.au

 

[hgg21]

Oh great!!!

Paulmarr,
Really appreciate that!
Thanks!