By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,322 Members | 1,182 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,322 IT Pros & Developers. It's quick & easy.

Hi Problems in SQLplus Report - For Distinct Count

P: n/a
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 ***
Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.