Re: Do you need a "on every row" or "on last row"?
Posted in 1993
Walt Hultgren says: > Sounds like some people are talking about Ace and others about I4GL. Perhaps. Cathy mentioned both. I assumed Bob was referring to Ace, because that matched the "symptoms" I have seen. > [paragraph deleted] > > We also have Ace here, but I don't do enough work with it to be able > to say for sure. I too worked with good ol' 3.3, and I seem to remember > that on NCR Towers with SysV.2, no data resulted in no report with Ace. > The print spooler on that system used banner pages, so it wasn't too > confusing. At least the user knew when the report was finished. > Most of the serious reports in that system used C with ALL II calls, so > I basically was able to ignore the issue. We still have some customers running with "good ol' 3.3" and preparing (finally) to make the jump to SQL -- straight into 5.01 (4.11 I-SQL). This change in behavior of ace reports (to no longer print headers if there is no data) has been confusing to some of them as well as to our people who still support 3.3 but are learning about SQL and its impact on our applications/reports/etc. > I second Cathy's call for an option to force at least a page header [and > footer] even if no data is sent to a report. An alternate syntax might > be some enhancement to the START REPORT statement, such as > > START REPORT report_name [...] IMMEDIATELY > > or something like that. The modifications required to the report control > routines shouldn't be that bad. I say that of course with having seen > the code, though. I would love something like this for ace reports, I guess it would need to be a flag at runtime... -- Bryan Klopfenstein bryan@carsinfo.com CARS Information Systems Corp. Cincinnati, OH Standard Disclaimers Apply