Re: theory and practice: ying and yang
Date: Tue, 07 Jun 2005 10:49:03 +0100
Message-ID: <42a56d90$0$8716$ed2619ec_at_ptn-nntp-reader02.plus.net>
mountain man wrote:
>>But when the external code writes a report, how does it know what the
>>column titles should be? How wide the columns are?
>
> There is no external code. The report is written by a DBA
> (or nominated party) in SQL (from report specifications
> that have been prepared in consultation with the client
> organisation) and saved as a stored procedure, column titles,
> column widths and default sort being specified in the sproc.
What if a report with subtotals at various levels is required? Or other fancy stuff like running totals, subreports etc? Or crosstab reports? This kind of thing, which is basically presentation rather than data extraction is better done by a client tool, is it not?
Paul. Received on Tue Jun 07 2005 - 11:49:03 CEST