Overriding Fetch()

[teertha13]

I have 5 five columns in a data row. They are GroupName, Date, AMT1 ,AMT2,AMT3.
My report is build by metadata i.e controls are created on run-time. For customization I need to override methods.
Data will be like this
GroupName Date Amt1 Amt2 Amt3
ABC 01-01-2007 100 100 100
02-03-2007 100 2002 300
05-06-2007 200 300 400
QWE 01-01-2007 100 100 100
02-03-2007 100 2002 300
05-06-2007 200 300 400
If groupname is different I need to do average for the columns AMT1 ,AMT2,AMT3.
How to override Fetch() for this.The report output should be like this.

GroupName Date Amt1 Amt2 Amt3
ABC 01-01-2007 100 100 500
02-03-2007 100 200 300
05-06-2007 100 300 400
Average: 100 200 400
QWE 01-01-2007 300 100 200
02-03-2007 100 200 300
05-06-2007 200 300 400
Average: 200 200 300

 

[tamhas]

Why would you add a row instead of just using a Group section and putting the averages in the After section?

 

[teertha13]

Hi Tamhas,

My report framework is different than usual. The report is built on fly at run-time using metadata. We have to do by customizing the report only. There is no other way other than overriding Fetch()

thanks for the reply.