David


Just getting at the data is no problem, a standard query is fast enough. The problem is 4 levels of totalling, getting it correctly ordered and well presented.

Whilst I can no longer remember the syntax (its been over 16 years) I do remember that PICK/TCL was brilliant for this sort of reportage.

Roy Lambert

Right.  The reason I suggest a separate table and a stored procedure is to
break the problem up into smaller chunks and to keep it all in SQL instead
of some of it in SQL and some in Delphi.  It's the complexity and the
multiple levels of totaling that are making it difficult.

In this "report" table, you could have a field called "level" and at each
step in the stored procedure, you could set the level to a different number.
Then the grouping and sub-totaling could easily be just by that level
number.

Anyway, just an idea.

--
David Cornelius
Cornelius Concepts

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:BFD4B8EF-80F1-4F40-AF3E-1FF48C5202B4@news.elevatesoft.com...
> David
>
>
> Just getting at the data is no problem, a standard query is fast enough.
> The problem is 4 levels of totalling, getting it correctly ordered and
> well presented.
>
> Whilst I can no longer remember the syntax (its been over 16 years) I do
> remember that PICK/TCL was brilliant for this sort of reportage.
>
> Roy Lambert
>