JerryEng
04-19-2004, 06: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).
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).