| Report Format length [message #339323] |
Thu, 07 August 2008 05:07  |
amit_kiran
Messages: 50
Registered: July 2006
Location: UK
|
Member |
|
|
Hi,
Can you please help me in this matter?
I am currently generating report from Oracle data.
COLUMN "Voucher Amount" heading "Voucher|Amount" FORMAT 9999.99
Output of this report gives me a length of 8 characters. If there is an amount of 250 the output is displayed ' 250.00'. Total length is 8 characters.
Can you please let me know if there is any way to format this numeric field to 7 digits?
Thank You very much.
Amit.
|
|
|
|
| Re: Report Format length [message #339342 is a reply to message #339323] |
Thu, 07 August 2008 05:36  |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Not without "Column" command without removing one "9".
You have to use TO_CHAR in your queries.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
