Discoverer 3.1 - total display - Urgent. [message #88578] |
Sun, 24 November 2002 20:14 |
Balan Anil Kumar
Messages: 5 Registered: November 2002
|
Junior Member |
|
|
Hi,
I want to display distinct Total for supplier in report.
because we have only 2 suppliers
Month Supplier Amount
------ -------- ------
Jan'02 1 100
Feb'02 2 100
Mar'02 1 100
Apr'02 1 100
May'02 2 100
------- -----
Total 7 500
How can I show 2 instead of 7 in supplier's total?
Thanks in advance
Anil.
|
|
|
Re: Discoverer 3.1 - total display - Urgent. [message #88593 is a reply to message #88578] |
Wed, 27 November 2002 15:45 |
Uma Somasundaram
Messages: 3 Registered: October 2002
|
Junior Member |
|
|
Hi Balan
May be you could try this........
Load the data in to a temp table. After the data is loaded, you could write a procedure which will identify the countof times a supplier is listed in that supplier column.
Then if the count is =1 then insert number 1 in a new column, say A_number. If the count is > 1 then insert 1 for the least rowid id and 0 for the rest.
Then you could bring this table in the Discoverer EUL and use that to display the dat and sum the column A_Number. It will give you 2.
This is a round about way.But does the work.
Hope it helps.
Thanks
-Uma
|
|
|