Can't get Data Report to Show Special Totals!

[splaisance]

Hi,

I am using a data report connected to a data environment. My problem is that I need to calculate totals for each group - but not one of the predefined functions VB allows you.

Basically Total1 is sum of this years numbers.
Total2 is sum of last years numbers.

These i use the sum() function on fine... but i also need the following:

Total3 is Total1 - Total2
Total4 is Total3 / Total2

Can anyone help me? I have tried EVERYTHING I can think of and still no luck!!!

Thanks!!

-S

 

[sidanshu]

You may get some ideas from the link...

http://msdn.microsoft.com/library/d...ml/vbconaddingcalculatedfieldtodatareport.asp

 

[Morpheus1981]

Why don't u do this operation just manually.

U get it through
"report.sections("ursection&quot.lblWhatever.caption"
Try this. It's the best I have right now.

 

[splaisance]

Thank you both!

With your input and a couple of days playing... I am finally getting what I want in my test reports.

S-