| Sum and outer join [message #338633] |
Tue, 05 August 2008 09:02 |
jb084
Messages: 14
Registered: April 2008
|
Junior Member |
|
|
Hello,
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 
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
