SQL*ReportWriter 1.1 Master/Master summary?

From: Olli Pihlajamaa <ojp_at_tik.vtt.fi>
Date: 19 May 1994 14:05:30 GMT
Message-ID: <OJP.94May19170530_at_aliisa.tik.vtt.fi>


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  

--
 +-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+

! Olli Pihlajamaa, Palovartijantie 13 A 12, 00750 HELSINKI, FINLAND !
! EMAIL: Olli.Pihlajamaa_at_vtt.fi TEL: (+358-0) 364375 (Home) 4566070 (Work) !
+-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+
Received on Thu May 19 1994 - 16:05:30 CEST

Original text of this message