From: jafri_yasin@yahoo.com (Yasin)
Newsgroups: comp.databases.oracle
Subject: Hi Problems in SQLplus Report - For Distinct Count
Date: 7 Jul 2003 04:16:55 -0700
Organization: http://groups.google.com/
Lines: 73
Message-ID: <5a3671aa.0307070316.27f1e3dd@posting.google.com>
NNTP-Posting-Host: 213.42.2.7
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1057576616 18849 127.0.0.1 (7 Jul 2003 11:16:56 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 7 Jul 2003 11:16:56 GMT


Hi 

 I have one reports which shows the Account wise daily
 transaction during the day.(pl's find below report 
 layout format with column description)

 May or may not be each account have multiple
 transaction during the day.

 My report break and compute as shown below.
 break on report on Product_Description on Account_No
 on Name on CCY nodup
 compute count label 'Total Accounts' of Account_No on
 report

 My problems is.
 Compute counting the total number of not null
 transaction into report but I want distinct account
 count at 
 the end of report.
 i.e. during a day one account reporting 100
 transaction, compute will show 100 transaction but i
 want count 
 should show only 1.


 Bye
 Yasin

Product Description   Account No CCY Account Title
-------------------- ----------- ---
------------------------------------------------------------
                         Opening Balance        Debit Amount      
Credit Amount     Closing Balance
-------------------- ------------------- -------------------
------------------- -------------------
xxxxxxxxxxxxxxxxxxxx   999999999 xxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
                             999,999.00          999,999.99         
999,999.99          999,999.99

xxxxxxxxxxxxxxxxxxx    999999999 AED XXXX
                             999,999.99-         999,999.99         
900,000.00          999,999.99-
                             999,999.99-         999,999.99           
    0.00        9,094,999.99-
                           9,999,999.99-         999,999.99         
999,400.00          999,098.65-
                             999,999.99-         600,000.00           
    0.00          878,310.35-

                       999999999 AED XXXX
                             999,999.99-         999,999.99         
900,000.00          999,999.99-
                             999,999.99-         999,999.99           
    0.00        9,094,999.99-
                           9,999,999.99-         999,999.99         
999,400.00          999,098.65-
                             999,999.99-         600,000.00           
    0.00          878,310.35-

******************** *********** ***
************************************************************
                     -------------------
Total Accounts
                                       9  (this figure show no of rows
reporting into Report)
"but I want like this                  3  ( No of distinct Accounts of
report)"


                                                       *** End of
Report ***