on 02-03-2009 8:08 PM
Hi,
My amounts are displayed in this format 364728.89.
I really want to display them in comma format 364,728.89
My field is DEC 12 with 2 decimals.
Rgds
Vara
What did you put in the "display format"? When you use a comma in the display format, If I remember well, it will take the thousands separator from the LOCALE of the computer (windows).
If it's a non-interactive form, you may define a string instead of a number and format it yourself.
If it's an interactive form, I think you'd better keep the default adobe processing.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This is non-interactive form.
My display format is empty.
When you use a comma in the display format???? Do you mean I just type 000,00.00 in display format.
I tried this it did not work.
I also have problems with displaying zero amounts..
I want them to display as '0.00' but they are displaying with only single zero '0.0'.
How can I overcome this?
Could you please explain me liitle bit more on string declartion? How do we do this?
rgds
vara
Edited by: Vara K on Feb 4, 2009 9:03 PM
>
> When you use a comma in the display format???? Do you mean I just type 000,00.00 in display format.
Thousands separator is taken from your Locale defined in windows (control panel, regional). It seems that your customizing displays space for thousands.
>
> Could you please explain me liitle bit more on string declartion? How do we do this?
Just define the binded parameter as characters, and format it yourself, for example in abap : DATA myparam TYPE c LENGTH 20. myparam = '123,456.78'.
Sandra,
I have checked my regional settings in controol panel and it is with Commas (Number: 123,456,789.00,
Currency :$123,456,789.00)
I also tried Changing my amounts to chars( Char 18 ). When I do this..My output is overflowing and this is creating another main table down with same entries in output.
I tried DEC 12 with 2 decimals and CURR 15 with 2 decimals.
I still have following issues.
1- amounts without commas
2- I want every time to display amount with 2 decimals eg: 123123.70 right now it only displays 12123.7 .
It displays 2 decimals when it is like this 23.78
Let me know if you need more info.
Rgds
vara
I don't understand why you have a problem with displaying a CHAR field !
Did you check that the field properties in Adobe are correctly defined too?
My form displays correctly numbers : if I have a zero number with 4 decimals, it is displayed "0.0000"
Could you check again by creating a brand new very simple form
Could you check Adobe sample forms
Sandra,
I believe it is due to the number of columns I am putting in.I checked it by changing single column and it is displaying the amount with decimals .
I am using landscape format & I have around totally 13 Columns ( 10 amount fields( CHAR18) + 1 text field (CHAR15) + 2 char fields( CHAR4).
If I use this format my main table is genarting again down.
if I change my amount columns to CURR or DEC 12 with 2 decimals.. everyting if fine.Do I need to do something in subform settings?
rgds
vara
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.