Re: SQL*ReportWriter 1.1 Master/Master summary?
Date: 20 May 94 12:42:33 EST
Message-ID: <little_jeffrey_s-200594124425_at_jarhead.d52.lilly.com>
In article <OJP.94May19170530_at_aliisa.tik.vtt.fi>, ojp_at_tik.vtt.fi (Olli Pihlajamaa) wrote:
> I have report that has two master queries in both of which I count and
> sum fields. Now the problem is: How to sum the results from either
> query?
>
> Greatly simplified example:
>
> QUERY 1 QUERY 2
>
> select count(*) cnt1 select count(*) cnt2
> from foo from bar
>
> How to make sum from cnt1 and cnt2 (cnt1 + cnt2) printable?
>
> Olli
I realize this is not an answer to your question, really, but have you ever considered using SQR instead SQL*ReporWriter? The operation you describe is child's play in SQR; I'm not sure that it is even possible in ReportWriter. In general, I find SQR to be much more powerful and userful.
My $0.02
Jeff Little
-- Jeffrey S. Little Eli Lilly & Co. little_jeffrey_s_at_lilly.com I work in Systems, not in Corporate Communications. Therefore, the opinions I present are mine, not Eli Lilly's. "...This is how the world ends. Not with a bang, but a whimper."Received on Fri May 20 1994 - 19:42:33 CEST