Re: Subtotals in REPORT...
> Gurus,
Sorry, they're all asleep - you'll have to make do with me! :-)
> 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?
You might try:
SELECT caseNo, ....., caseNO[6,8] sortcol
.....
ORDER BY sortcol [or use the column number if it gives you a compileerror]
In your report, use AFTER GROUP OF sortcol
HTH.
--
Ciao,
Billy
+------------------------------------------------------------------------------+
| I used to be indecisive, but now I'm not so sure... |
+------------------------------------------------------------------------------+