| Discovere Total [message #233573] |
Thu, 26 April 2007 12:03  |
sandyg
Messages: 1
Registered: April 2007
|
Junior Member |
|
|
hi gurus,
I am new to the forum and i have an issue ,
iam working on Discoverer 10g 10.1.2..
i want to have a group total for my report -- i have 2 transaction table and two master table in the report...
Now when i do take the option Total - sum- inv amt- total - when change in buyer code . It does not give me any total.
Now - the data of buyer no, checks and invoices details are coming from transaction table. and buyer name and company name coming from master table .... please suggest .....
sandy
|
|
|
|
| Re: Discovere Total [message #234065 is a reply to message #233573] |
Sun, 29 April 2007 05:15  |
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
|
Senior Member |
|
|
Discoverer is pretty strict on what columns can be aggregated and which can not. And there is a reason for it...
You mention that you have 2 masters and 2 details in your report. Let's say you have the following data:
dept emp salary
10 A 1000
10 B 1500
20 C 1200
20 D 1300
30 E 1500
And another master-detail like:
dept region sales
10 X 120
20 Y 200
30 Y 150
Now, if we want to sum all numbers, it would be something like:
region sales salary
X 120 2500
Y 250 3000
This works.
But now, we want to add a "sublevel" dept:
region dept sales salary
X 10 120 2500
Y 20 ?? 1500
Y 30 ?? 1500
Discoverer notices this and refuses to give a total in this case.
By the way, please check of your joins are in "the correct direction" (master-detail defition in properties of the join), otherwise this behavior can occur more often than you want...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
