Formatting: Alternate shading within a report w/custom color

[mbaml]

Need to create alternate shading within a report that skips over the grouping names I have setup. So one line blue, next line white...etc. Also, need to use a custom color code.

 

[swiss2007]

if remainder(@yourgroupname,2) = 0 then crblue else crnocolor

for custom color use: color(red,green,blue)

 

[mbaml]

Thank you! Can you tell me where exactly I setup this formula?

 

[swiss2007]

Go to Section Expert, choose the required section on the left and on the right you will see Color tab, write the formula

 

[mbaml]

I went into section expert, selected a white background color, and then clicked on the formula button and enterer the following formula:

if remainder(Group #1 Name,2) = 0 then cr#DAE5F7 else crnocolor

I am getting an error "(is missing". The "crDAE5F7" is the custom color I want alternating through the report. What am I doing wrong?

 

[swiss2007]

dont know what is "crDAE5F7"
For white you have to use cr(255,255,255)
but if you use white, I think you cannot differentiate in the report as the report background is white.

 

[mbaml]

crDAE5F7" is a custom color, based off of a color in a client's logo. I want that color and white alternating through the details field....

 

[fisheromacse]

that is a hex color value.
it should be the same as RGB color (218,229,247)

 

[mbaml]

OK, I got it, thank you very much for your help!!!!!!