‎2006 Jul 12 5:44 PM
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
‎2006 Jul 12 5:58 PM
Hi,
Try to use format options for amount :
Ex:
&X_ITAB-AMOUNT(5.2)&
or
check your user settings :
system->user profile->own data->defaults->decimal notation
Regards
Appana
‎2006 Jul 12 7:55 PM
‎2006 Jul 12 5:58 PM
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.
‎2006 Jul 12 7:56 PM
if we use the char type, then how can I get the comma seperater.
‎2006 Jul 12 7:59 PM
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&
‎2006 Jul 12 7:59 PM
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.
‎2006 Jul 12 8:06 PM
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
‎2006 Jul 12 9:09 PM
I solved the page no issue, still I am not able to diplay the amount properly
‎2006 Jul 12 9:14 PM
TT,
I had this problem with my smartforms. I moved the CURR type variables to type P and the comma seperator is displayed.