469,082 Members | 1,091 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,082 developers. It's quick & easy.

Hi Problems in SQLplus Report - For Distinct Count

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
0 5405

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by DAnne | last post: by
3 posts views Thread by tyrynn28 | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.