Focal Point
Summary

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7071088331

August 05, 2005, 03:37 AM
Paul C.
Summary
Ihave a report that has several Table Files. I need to take values from the "ON TABLE COLUMN-TOTAL AS 'Total'" from each file and create a summary at the end of the report. How can I grab values from each table file and dump them into my end of report summary?
August 05, 2005, 04:48 AM
susannah
here's what i might do, if the summaries were all the same..or could be made to appear to be the same...
to each Table file paragraph, add a second Table File paragraph
TABLE FILE CAR
..do stuff
ON TABLE HOLD AS MYTABLE1 FORMAT HTMTABLE
END
-RUN
TABLE FILE CAR
..sum stuff up
ON TABLE HOLD AS MYHOLD1
END
-at the end
TABLE FILE MYHOLD1
PRINT * ON TABLE HOLD AS MYHOLDSUM
MORE
FILE MYHOLD1
MORE
FILE MYHOLD2
END
TABLE FILE MYHOLDSUM
...make it pretty
ON TABLE HOLD AS MYTABSUM FORMAT HTMTABLE
END
-RUN
-HTMLFORM BEGIN
!IBI.FILE.MYTAB1;
!IBI.FILE.MYTAB2;
..etc
!IBI.FILE.MYTABSUM;
-HTMLFORM END
August 05, 2005, 01:16 PM
Paul C.
Is there any performance hit to dumping tables to a hold file? In my case there will only be about a page of data as it is a summary type of report. I'm concerned about the performance of having to create multiple hold file before generating the final result.