Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Reports: Fomula Columns ?
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,
[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, USAReceived on Tue Jul 08 2003 - 19:11:34 CDT