CurrentRowIndex issue

[FireGeek21]

I received a sample report that would be of great use to us. Unfortunately, it is erroring out on CurrentRowIndex which appears to be a CR 2008 feature. I am using CRXi. Is there a way to tweak the formula pertaining to CurrentRowIndex so I can use this sample report?

Here is the code from a couple formulas using CurrentRowIndex:

**********
if remainder(CurrentRowIndex,2) <> 0
then rgb(209,209,197) else crwhite
**********

**********
if {?Measure} <> "Revenue" then
(
if remainder(CurrentRowIndex,2) <> 0
then rgb(209,209,197) else crwhite
)
else global numbervar columnhighlight
**********

Thanks,

RSGeek

 

[lbass]

Not sure what that is, but it sounds like a record count, so try substituting recordnumber for currentrowindex. This looks like a formula that will alternate row colors.

On the second formula, you are referencing a variable columnhighlight that must have been set up in another formula.

-LB