Reports work in CR 8.5, not in CR XI R2 SP3

[Former Member]

I have a number of reports that manually calculate running totals in the detail and prints the running totals, then uses the last value in the Group Footer in a formula to print a calculated field. Plain and simple. This works okay in CR 8.5.

Running the same report in CR XI R2 SP3 the running total is being calulated 2 times on the last item in the the detail. I can subtract the extra calculation to print the correct value, but that does not solve the problem.

Formula for (@RunningQty) detail field:

{@SharedAvail} + {@RunCaseQty}

Formula in GF:

{@SharedMin} - {@RunningQty}

Any ideas of what is wrong?

-Kevin

[Former Member · Accepted solution]

Thanks Raghavendra.

I tried what you suggest, but Formula Workshop shows an error for @Evaluate. It wants a number to the right of the = sign.

-Kevin

[Former Member · Accepted solution]

Try this

whileprintingrecords;
numbervar i;
i:=i+tonumbet({@SharedAvail} + {@RunCaseQty});

I hope both the formulas {@SharedAvail},{@RunCaseQty} are numeric fields

Regards,

Raghavendra

[Former Member · Accepted solution]

Thank you Raghavendra.

I have successfully implemented your suggestion.

-Kevin

[Former Member]

To award points

[Former Member]

Try this

Create a formula like

@Initialize:

whileprintingrecords;
numbervar i:=0;

place this in group header

Now create one more like

@Evaluate:

whileprintingrecords;
numbervar i;
i:=i+{@SharedAvail} + {@RunCaseQty};

place this in details section

and create 3rd one like

whileprintingrecords;
numbervar i;

place this in group footer.

I hope this helps!

Regards,

Raghavendra