Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Reports: Fomula Columns ?

Re: Oracle Reports: Fomula Columns ?

From: Gunter Herrmann <notformail0303_at_comcast.net>
Date: Tue, 08 Jul 2003 20:11:34 -0400
Message-ID: <befm3p$4me3e$1@ID-110857.news.dfncis.de>


Jan Gelbrich wrote:
> "news.verizon.net" <richard.martes_at_verizon.net> schrieb im Newsbeitrag
> news:0inOa.16235$Ha.2189_at_nwrdny02.gnilink.net...
>

>>Hello Everyone,
>>
>>I need to know how to get the sum of two column formulas (cf_win,

>
> cf_loses)

[SNIP]
> Hi,
>
> add a CS in your basic group in the data model,
> then (in the property palette, use F4 to invoke)
> set its source to the CF to be summed.
> Then add the CS to your layout where you want.
>
> hth, Jan
>

My personal experience is:
Whenever possible do these calculations in the query (or in a view). It is much faster. YMMV.

Regards

-- 
Gunter Herrmann
Naples, Florida, USA
Received on Tue Jul 08 2003 - 19:11:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US