'######' in number field. [message #21181] |
Wed, 17 July 2002 07:01 |
Parag dave
Messages: 8 Registered: February 2002
|
Junior Member |
|
|
Hi,
In my report, I have a field formated as 'B99,999.99'
and the report geenrates total at report break. At another break
it prints the total for that field but at report level when it prints
grand total, it prints ##########. I tried to increase the field by adding '9' in the format still getting
###'s. Again I tried with '99'
but no change.The actual total should be 105,002.98.
Any Idea or suggestion to resolve this?
Thanks.
|
|
|
Re: '######' in number field. [message #21182 is a reply to message #21181] |
Wed, 17 July 2002 07:30 |
Jarrod McReynolds
Messages: 3 Registered: February 2002
|
Junior Member |
|
|
Try increasing the Size of the displayed field. This is ussualy an indicator that there is not enough room on the report to show all of the data in the field.
AZt least I think that is what it would be.
|
|
|
Re: '######' in number field. [message #21199 is a reply to message #21181] |
Wed, 17 July 2002 16:30 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
anything like this?
if the format is B99,99 or less you will get ### in output.
SQL> get report
line 5 truncated.
1 column sal format B99,999
2 BREAK ON DEPTNO SKIP 1 ON REPORT
3 compute sum label total of sal on deptno
4 compute sum label grandTotal of sal on report
5* select deptno,empno,sal from emp order by deptno
SQL> @report
DEPTNO EMPNO SAL
---------- ---------- -------
10 7782 2,450
7839 5,000
7934 1,300
********** -------
total 8,750
20 7369 800
7876 1,100
7902 3,000
7788 3,000
7566 2,975
********** -------
total 10,875
30 7499 1,600
7698 2,850
7654 1,250
7900 950
7844 1,500
7521 1,250
********** -------
total 9,400
-------
grandTotal 29,025
|
|
|