Report Footer Summary

[Former Member]

Hi All,

I have a report having summary on formula field in report footer.But i am not getting the result(result should be 30727).

Please find the report.

In report if we suppress the page footer section(there is a text box with red fonts) then  i am getting the correct result.

I did every thing but unable to find the problem.

Please help

TenderInfomationReport.txt.zip

[abhilash_kumar]

Hi Divya,

The section with the Text Box in Red color is on the Page Header and not the footer.

Suppressing or un-suppressing the section does not change the Grand Total for me; it always shows: 30760.350

-Abhilash

[Former Member]

Hi Abhilash,

Sorry .

But when i suppress the page header i am getting the result 30727.I don't know what is the problem.

Please suggest.

[abhilash_kumar]

Very strange!

Try creating another formula with this code and place it beside the @total_amount formula on the GF3a:

EvaluateAfter({@total_amount});

numbervar g;

g := g + {@total_amount}

And, then create another to display the Grand Total just like the @grand_total formula.

Does this formula show the right results? But honestly, I'm not too sure why the report on your machine shows incorrect results when the same report shows right on my machine (I'm using CR 2011 SP02)

-Abhilash

[Former Member]

Hi Abhialsh,

I created the formulas(blue color) as you suggested but still i am not getting the result.

Now please find the report here i suppressed the page header .so it is showing correct result.

If i show the page header again 30760 is coming.

My cr version is cr 2011 14.0.2.364 RTM

Please help

TenderInfomationReport.txt.zip

[abhilash_kumar]

In this new report I get 30760 whether the section is suppressed or unsuppressed.

Is 30760 not correct? Have you tried manually adding the Sub-Totals and find out whether 30760 is right result?

P.S: The figure 30760 arrives after you subtract two other formulas from the Grand Total.

If you're saying 30760 is wrong result

a) what is the right Grand Total figure without the subtraction

b) what should be the right figure after the subtraction?

-Abhilash