How to add summary functions in group footers

[MikeGarvin]

Hi,

I use a report that does not have any database fields, only formula fields. I already know how to add a group with the addgroup method, but need to know how are summary fields added?

I need to add a sub total for a money field in each group that has to show at bottom of eahc group but am unsure as to how this is done. Any help would be very much appreciated.

Again, I don't use any database field and so CR does not allow me to physically add a group section and paste any formulas. It seems this needs to be done by code.

I'm desperate!

Regards,

Mike

[brucevde]

I don't use any database field

So where does the data come from? A database can be text files, Excel, ADO Recordsets. It does not have to be SQL Server, Oracle etc...

A Summary field is just a formula that uses the Sum function.

Sum({Report Object}, {Group Name})

[MikeGarvin]

Hi,

Thanks.

I use this to populate the fields:

DistrSumm.Database.AddADOCommand AdoRSDistSum.ActiveConnection, AdoRSDistSum.ActiveCommand
DistrSumm.FormulaFields(2).Text = DistrSumm.Database.Tables(1).Fields(2).Name

Thanks.