Values repeated in report

[Former Member]

Dear experts,

I am facing this problem in some of my reports.

If the value in a column for particular record is null, it copies or repeats the value of the record above that cell (which has a value in it). i do not want this. If there is no value in that column for that record either it should print 0 or kept blank. Because of this problem i am not able to know whether the data is correct in the report. I am clearing the work area after ENDLOOP.

Please anyone help me with this.

Regards,

Jitesh M Nair

[Former Member]

Hi,

u have to clear workarea before endloop.

regards,

vijetha.

[Former Member]

Hi,

Try this.

Loop at itab into wa_itab.

...............

................

<after assigning all the values>

clear: wa_itab.

endloop.

Clear the workarea before the endloop stmt else if any of the value is null in the next record, it will have the previous value in the workarea for that particular column.

Sharin.

[former_member598013]

Hi

Always rememeber while doing Loop endloop. always Clear the header of the internal table

Last statement inside the Loop EndLoop should be Clear the header.

[Former Member]

Hi,

as you mentioned "I am clearing the work area after ENDLOOP" in your query, There lies the problem, put that clear statement before ENDLOOP statement, and then try executing the report, still if you are facing the same problem pls send the piece of code.

Thanks,

Sreeram.

[Former Member]

That was a really easy one for you... but difficult one for me..... Clumsy of me not to notice it....

Thanks all of you.....

I will be back with more problems and solutions....