Summing Two Columns 1

[spacemanspiffy04]

Hi, I'm new to crystal reports, so this is probably really simple.

I have created a report that includes 2 columns that I would like to sum.

I would then like to display the summed column and hide the other two columns.

Any help would be gratly appreciated!

Thanks!

 

[spacemanspiffy04]

I should have also mentioned that I am useing Crystal Report XI

 

[lbass]

Create a formula:

sum({table.col1})+sum({table.col2})

This would be for the report footer. If you want to do this at a group level, you would add in a group condition, as in:

sum({table.col1},{table.groupfield})+sum({table.col2},{table.groupfield})

...and place it in the group header or footer. No need to put the columns themselves on the report at all.

-LB

 

[spacemanspiffy04]

Thanks Lb!!!!