Hello!
This is just a question to improve an already working report(s), nothing is broken: We have some complex reports in which we need to highlight (light gray) every even row on the report and we already do that thanks to examples found on the DR documentation. Our code looks like this:
Code:
if (Mod({&Record Number},2) = 0) then
return (Rgb(200,200,200))
end
return drWhite
It works flawlessly. However, we want it to work with groups as well. When we define a group, as the Record Number is a "global variable" and keeps on counting (it doesn't take the group into account), depending on the number of records we might get some groups which get their odd rows highlighted instead of the even rows. It still works but it is a bit ugly: having the first row highlighted, just after the group caption or the details header is a bit weird.
Do you know any equivalent counter similar to Record Number which takes into account the number of records since the begining of a group?
I have attached a preview.
Thank you!