RE: Subtotals in REPORT...

Posted in 1996

marcog@ctonline.it — 31 Oct 1996 08:33:33 -0500 — source: Informix-list mailing list archive (1991-1998)

try SELECT caseNo, caseNo[6,8] .... FROM table ORDER BY 2 HTH, Marco ____________________________________________________________________________ rem radioterapia, which I immeritately manage, seldom agrees with what I say marco greco (Catania, Italy) Work: marcog@ctonline.it rem radioterapia 39 95 447828 fax 446558 (was mar.greco@agora.stm.it) Achea 39 95 503117 --- On 30 Oct 1996 21:14:49 GMT Hannah Sobie Fiabema <hfiabema@osf1.gmu.edu> wrote: Gurus, I am trying to generate this report. The SELECT is: SELECT caseNo, .... FROM table ORDER BY caseNo[6,8] In the report I want subtotals group by those three bytes in caseNo. My statement is : AFTER GROUP OF xRec.caseNo[6,8] ... this proves to be a problem, it generates a syntax error. Is there an elegant solution or will I have to use brute force to achieve the desired result? Thanks in adv. Please respond to kgl@eagle.dol-esa.gov -----------------End of Original Message-----------------