Home » Developer & Programmer » Reports & Discoverer » Discovere Total
Discovere Total [message #233573] Thu, 26 April 2007 12:03 Go to next message
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 .....

Re: Discovere Total [message #234065 is a reply to message #233573] Sun, 29 April 2007 05:15 Go to previous message
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...

Previous Topic: Changing Field's Value at RUNTIME
Goto Forum:

Current Time: Wed Aug 23 10:54:24 CDT 2017

Total time taken to generate the page: 0.01848 seconds