04-23-2009 10:55 AM
Hi Gurus,
In my report, output is coming in XL sheet. But in XL sheet group currency and carry forward column values are not in correct allignment. I used "EXCEL_OLE_STANDARD_DAT' function module to get output in XL SHEET
Group Currency Carry Forward Balanc
0 2552.91
87150.12- 87150.12-
27157.97 27157.97
0 2300
7496.69 7496.69
4789.34- 4789.34-
197533.71- 202395.71-
0 9.09
33465.58- 33465.58-
i want the negative values should be correct allignment like " -87150.12".
I tried Gui_download, but its not working .Please suggetst me solution .
Thanks & Regards,
Chiru.
04-23-2009 11:05 AM
Use the function module CLOI_PUT_SIGN_IN_FRONT for the group currency field and then pass it to the function module that downloads the data to excel.
Regards,
Ravi kanth Talagana
04-23-2009 11:05 AM
Use the function module CLOI_PUT_SIGN_IN_FRONT for the group currency field and then pass it to the function module that downloads the data to excel.
Regards,
Ravi kanth Talagana
04-23-2009 11:21 AM
Hi Gurus,
I used this fm "CLOI_PUT_SIGN_IN_FRONT" but it is not working,
In the group currency and carry forward some values are coming "3456- ", "12456.23-".
. It should come -3456 and -12456.23 in correct format.
Regards,
Chiru.
04-23-2009 11:22 AM
04-23-2009 1:21 PM
you can do it this way.
data: p_amt type char.
p_amt = t_pa-amt.
if t_pa-amt < 0.
len = strlen( p_amt ) - 1.
concatenate '-' p_amt+0(len) into p_amt.
endif.
Regards,
Lalit Mohan Gupta.
04-24-2009 10:02 AM
Hi,
Thanks for your reply, but it is not working. Please suggest me if any other solution.
Regards,
Chiranjeevi.