4GL reports
Posted in 2000
Topics: Stored Procedures & SPL, Connectivity: ESQL/C, 4GL & Embedded SQL
Hi, I'm the curator of about 30 4GL reports whose been asked to identify the possibilities of plugging the report data into an excel worksheet and html format. Most of the reports implement quite complex business logic to derive values etc, some of which are calculated or retrieved within the REPORT function itself. Liberal use is also made of temporary tables in intermediate steps to calculate various data. General background: - Each report generates a file before being printed. - printer codes are sent to the report for formatting when printed. - some of the reports can be upto 10MB file size My aim is to do minimal work on the 4GL code itself and was wondering about displaying the file (eg in html) and then "scraping" off the values from the screen. I would appreciate your help. Thanks Dave Males MSc Senior Developer SEMA Group Livingston Tel: 01506 475237 Fax 01506 475333 ___________________________________________________________________________ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of Sema Group. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the Sema Group Helpdesk by telephone on +44 (0) 121 627 5600. ___________________________________________________________________________