topic Re: smartform numeric value display in Application Development and Automation Discussions

smartform numeric value display

Former Member — Wed, 12 Jul 2006 16:44:27 GMT

I have a table with some sales amount on one field (Data type is CURR)

after I import that into the smart form and when I was trying to print, it is coming in different way. for exaple if the amount is in the table is 980,65.00 it is display in the smart form as 980,65<,000.00. Any body can help me please. Is there anything I am missing?

Thanks in Advance

Re: smartform numeric value display

Laxmana_Appana_ — Wed, 12 Jul 2006 16:58:41 GMT

Hi,

Try to use format options for amount :

Ex:

&X_ITAB-AMOUNT(5.2)&

check your user settings :

system->user profile->own data->defaults->decimal notation

Regards

Appana

Re: smartform numeric value display

Former Member — Wed, 12 Jul 2006 16:58:58 GMT

Hi ,

You can't directly display the currency fields in smartforms. You create a Field of char type and assign the currency field to it before dispalying.

Regards,

Vinod.

Don't forget to assign points if it was usful.

Re: smartform numeric value display

Former Member — Wed, 12 Jul 2006 18:55:29 GMT

I tried this one did not give any change

Re: smartform numeric value display

Former Member — Wed, 12 Jul 2006 18:56:37 GMT

if we use the char type, then how can I get the comma seperater.

Re: smartform numeric value display

Former Member — Wed, 12 Jul 2006 18:59:03 GMT

I have another problem too. I was trying to print page no and total number of pages. if total number of pages is less than 10, then it is fine. if it is more than 10, it is printing *

&SFSY-PAGE& of &SFSY-FORMPAGES&

Re: smartform numeric value display

Former Member — Wed, 12 Jul 2006 18:59:23 GMT

Use a variable type P decimals 2.

For the number of pages the * usually means that there isn't enough space to print out the value. Try widening your window.

Re: smartform numeric value display

Laxmana_Appana_ — Wed, 12 Jul 2006 19:06:36 GMT

Hi,

define character variables with length 3(if it is not sufficient for maximum pages,then increase the length) ,then pass

SFSY-PAGE,SFSY-FORMPAGES values to the defined variables and use the variables to print the data.

regards,

Appana

Re: smartform numeric value display

Former Member — Wed, 12 Jul 2006 20:09:11 GMT

I solved the page no issue, still I am not able to diplay the amount properly

Re: smartform numeric value display

Former Member — Wed, 12 Jul 2006 20:14:31 GMT

TT,

I had this problem with my smartforms. I moved the CURR type variables to type P and the comma seperator is displayed.