Home » Developer & Programmer » Reports & Discoverer » Discoverer 3.1 - total display - Urgent.
Discoverer 3.1 - total display - Urgent. [message #88578] Sun, 24 November 2002 20:14 Go to next message
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 Go to previous message
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
Previous Topic: Heading on first page of Report
Next Topic: Problem with discoverer
Goto Forum:
  


Current Time: Fri May 27 16:03:51 CDT 2022