Hi Problems in SQLplus Report - For Distinct Count
Date: 7 Jul 2003 04:16:55 -0700
Message-ID: <5a3671aa.0307070316.27f1e3dd_at_posting.google.com>
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 ***