Home » Developer & Programmer » Reports & Discoverer » Sum and outer join (Discoverer Desktop)
Sum and outer join [message #338633] Tue, 05 August 2008 09:02
Messages: 14
Registered: April 2008
Junior Member

I'm using Discoverer for a while now, and I still meet some problems when I want to add sum cells (by the "Totalisation fonctionnality") in a outer-joined query.

Here the case :
I've got a table, with a data element in it. If I don't include any other table, the totalisation works and my result is displayed. Things go wrong when I want to add another information, from another table. Ths join between the two tables is defined as an outer join.

When I had this element, the sum disappear (and reappear if I take the element back). Is this behaviour normal ? If it is, how could I deal with it in order to have my sum ?

Thanks for your help.

NB : I'm french, so please excuse my poor english Wink
Previous Topic: hyperlink in reports 10g
Next Topic: REP - 1401 error, in after parameter trigger
Goto Forum:

Current Time: Sun Oct 23 03:23:33 CDT 2016

Total time taken to generate the page: 0.08767 seconds