Summing mutliple columns

[MikeC]

I'm working on a report that has Sum fields for 3 columns of data (Land value, Building value and Dwelling value). All 3 are on the group footer.

I need a total for all 3 for each and I'm not finding a way to do it. How does the software handle sums when there are multiple columns?

[Jan]

Hello,

You can use expresssion something like this:

Code: Select all

{Sum(MyDataSource.Land + MyDataSource.Building + MyDataSource.Dwelling)}

Thank you.

[MikeC]

Thanks-worked perfect.

[Andrew]

That is very good!