topic update report in Application Development and Automation Discussions

update report

Former Member — Mon, 04 Jun 2007 08:55:53 GMT

I have a report that is new to me. Report shows output using smart form. I need to change the output of total that showa like 5000. i ned to show it with decimals ( 5000.00 ) How do I find the field that show this output and how can I change it.

thanks.

khan.

Re: update report

alex_m — Mon, 04 Jun 2007 09:04:39 GMT

You need to change the particular smartform, get the smartfrom name and find out the particular feild by searching.

Re: update report

Former Member — Mon, 04 Jun 2007 09:04:54 GMT

Hi,

Change the declaration of the field to

Data : p_field type p decimals 2.

in which the 5000 is stored.,

Reward points if it is helpful.

Regards,

Sangeetha.a

Re: update report

Former Member — Mon, 04 Jun 2007 09:11:12 GMT

If the oupput is printed in ALV and passed to Smartform you can easily find this from the Grid Display. Otherwise Start Debugging and check for all the total fields that is going to smartform.That you can find from the area of call function. Identify this variable and change the declaration from integer to

Data: dec type p decimals 2.

You can get your desired output...

Hope this will helps you........

Re: update report

Former Member — Mon, 04 Jun 2007 09:19:42 GMT

HI Khan,

first you have to identify the variable in theprogram which is giving 5000.

let us take p_integer is the variable which is giving 5000.

declare a temparary variable p_packed as

data: p_packed type p decimals 2.

assign p_integer to p_packed

p_packed = p_integer.

I think this will work.

regards,

jeevi.

Re: update report

Former Member — Mon, 04 Jun 2007 10:18:33 GMT

i appritiate ur reply.

But i think i am unable to find the variable. is there any possiblity that the variable declared somewhere else in smart form or function module.

plz revert bck soon. Thanks

Re: update report

Former Member — Mon, 04 Jun 2007 10:36:42 GMT

Hi,

Do the concatenation,

data : lv_variable(15) type c.

concatenation p_field '.00' to lv_variable.

pass the lv_variable.