topic Sub Total in classical report.......... in Application Development and Automation Discussions

Sub Total in classical report..........

Former Member — Fri, 30 May 2008 06:54:02 GMT

Hi Experts,

I am using calassical report in which i want a subtotal.

Example :

a 3

b 2

Subtotal : 5.

a 4

b 5

Subtotal : 9

Report is OK but subtotal is not comming. Pl. see my loop and guide me. I want subtotal of itab_out-typedesc feild.

LOOP AT itab_out.

ON CHANGE OF itab_out-typedesc.

FORMAT COLOR COL_TOTAL.

WRITE:/1 sy-vline, 5 itab_out-typedesc, 130 sy-vline.

WRITE:/1 sy-vline, 5 '===============', 130 sy-vline.

FORMAT COLOR OFF.

ENDON.

ON CHANGE OF itab_out-srno.

ULINE.

FORMAT INTENSIFIED ON.

FORMAT COLOR COL_NORMAL.

WRITE :/1 sy-vline, 5 itab_out-matkl, 15 itab_out-desc.

WRITE : 63 itab_out-dailyqty LEFT-JUSTIFIED DECIMALS 0.

WRITE : 100 itab_out-erfmg LEFT-JUSTIFIED DECIMALS 0.

WRITE : 130 sy-vline.

FORMAT COLOR OFF.

AT END OF typedesc.
WRITE :/1 'Sub-Total :'.
ENDAT.

AT LAST.

ULINE.

SUM.

FORMAT INTENSIFIED ON.

FORMAT COLOR COL_POSITIVE ON.

WRITE:/1 sy-vline, 20 'Total : ' , itab_out-dailyqty UNDER 'Mfg. Qty.' LEFT-JUSTIFIED DECIMALS 0.

WRITE: itab_out-erfmg UNDER 'Cumm. Qty.' LEFT-JUSTIFIED DECIMALS 0.

WRITE: 130 sy-vline.

FORMAT INTENSIFIED OFF.

FORMAT COLOR OFF.

ULINE.

ENDAT.

ENDON.

Yusuf

Re: Sub Total in classical report..........

Former Member — Fri, 30 May 2008 07:03:31 GMT

Before this loop Apply sort on that Internal table.

awrd points if useful

Bhupal

Re: Sub Total in classical report..........

Former Member — Fri, 30 May 2008 07:05:43 GMT

Hi ,

Try this in your code.

AT END OF typedesc.

SUM

WRITE :/1 'Sub-Total :',itab_out-srno .

ENDAT.

Regards,

Vishvesh

if helpful, rewards it.

Re: Sub Total in classical report..........

prasanth_kasturi — Fri, 30 May 2008 07:07:21 GMT

hi,

you used sun keyword in AT LAST but it will be execute only at the last pass of the loop

so use it in the at end of

and also its better to use sort statemnt

Re: Sub Total in classical report..........

Former Member — Fri, 30 May 2008 07:07:23 GMT

Hi,

this is a suggestion:

try to avoid ON CHANGE OF . as sometimes it will produce unexpected results.

try to use AT NEW, AT END, based on ur requirement.

make sure u SORT the internal table with correct fields( ie fields used in control break statements) .

regards,

madhu

Re: Sub Total in classical report..........

Former Member — Fri, 30 May 2008 07:24:37 GMT

remove ON CHANGE OF. Instead use AT NEW.

it is not required when using AT NEW and AT END OF .

try this...

AT END OF typedesc.

SUM.

WRITE :/1 'Sub-Total :',itab_out-typedesc .

ENDAT.

reward if useful

Edited by: Srikanth Kadiyala on May 30, 2008 9:27 AM