logic like Pivote Table for Report

[Former Member]

hi,

I have followin fields in my internal table

Location Tranfer Structure Date Size

INDIA /BIC/TS3 03.07.2005 130

NW /BIC/TS3 03.07.2005 30

NW /BIC/TS2 02.07.2005 20

NW /BIC/TS1 01.07.2005 110

UK /BIC/TS3 03.07.2005 20

UK /BIC/TS2 02.07.2005 20

UK /BIC/TS1 01.07.2005 10

And i want to print like

Location T.S 01.07.2005 02.07.2005 03.07.2005

INDIA /BIC/TS3 130

NW /BIC/TS1 110

/BIC/TS2 20

/BIC/TS3 30

UK /BIC/TS1 10

/BIC/TS2 20

/BIC/TS3 20

Can any 1 help me out for this ?

Also How to how to export data into Excel??

Thanks

cool

[athavanraja · Accepted solution]

you need to use control break statements

at new <location>

write location

endif .

write transfer, structute date size

for excel download use gui_download function.

search the forum for sample coding.

Regards

Raja

[Former Member · Accepted solution]

Thanks for the reply,

But have a closer look on the fields ie columns of the two tables .

In first date is as column but in second all date values are columns

Hope I would able to make u understand my requirement.

Cheers

[andreas_mann3]

Hi Prafull,

here's a similiar problem:

regards Andreas

[Former Member]

Hi ,

I got the logic .

Its very simple , to be frank no need to write big program.

If any1 needs pgs pls m\let me know

Cool