Summary in Group Footer

JerryEng
04-19-2004, 07:58 AM
I want to sum a field from the group header section with a field from the details section and place it in the group footer section of a VB6 data report. Is this possible? I can show a sum of the details but I can't seem to figure out how to sum it with another field.

I'm using the Shape/Append structure to create the recordset and setting all the data report fields in code (no data environment). Everything else in the report works great.

Would adding a SHAPE/COMPUTE statement around the original SHAPE statement and adding another group to the report help??

Thanks
Jerry

Background:
I am selecting customer info and original contract value in the "group" section. In the details section, I am showing change orders and amounts to the original contract. In the summary field, I would like to show the adjusted contract value (original contract + change orders).

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum