issue Amount display format in PDF output form

[Former Member]

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

[Sandra_Rossi · Accepted solution]

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.

[Former Member · Accepted solution]

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

[Sandra_Rossi · Accepted solution]

>

> 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'.

[Former Member · Accepted solution]

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

[Sandra_Rossi · Accepted solution]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Got Resolved.

I was using a table below which collects the main Internal table.

When i change it to Char..It did not sum it. that was overflowing.Also I reduced font size..

Sandra,

I am awarding you full points..Thank you.

Prasad