I have to dynamically set the custom background color for every other row. I tried the following code in the formula editor for the bakground color.
if RecordNumber mod 2 = 0 then crCustom else crNoColor.
1) It didnt work. DO I have name the custom color. If so how do i do it?
2) I have 3 detail sections which gets suppressed conditionally and all 3 sections have the above background color formula to display background color for alternate rows. My question is does this formula gets applied for each detail section or the entire report ?
Thanks,
Kiran