ReportWriter memory problem with long reports
Date: 9 May 92 17:17:47 GMT
Message-ID: <1992May9.191747.1_at_cc.helsinki.fi>
I have a bizarre problem which almost certainly is a bug in Oracle SQL*ReportWriter. I'm using an ancient version of ReportWriter (namely 1.1.8; even PCs have 1.1.12 nowadays) on an ancient platform (Unisys U6000 UNIX System V version 3.00 release 12.15 with Oracle RDBMS 6.0.27.7.1), so I hope this is fixed in current versions. However, I need a workaround, if there exists one.
I have a BIG report which results in a 1600000 byte listing file. I added some fields to the page header using the following kludge: create a summary of the data of interest as follows:
Name Source Function Print group Reset group the_field_kludge the_field First REPORT PAGE
This is necessary because I cannot reference the_field directly in page headers.
HAS ANYONE ELSE ENCOUNTERED THE SAME PROBLEM? OR HAS ANYONE EVER SUCCEEDED TO CREATE MANY MEGABYTES OF OUTPUT WITHOUT MEMORY PROBLEMS? IS THIS A KNOWN BUG? I have no idea why the memory image increases in size - maybe SRW must hold entire report in core in order to be able to process REPORT-wide summaries?
-- Juhani Jaakola, jaakola_at_cc.helsinki.fiReceived on Sat May 09 1992 - 19:17:47 CEST