create report format
I want to create a report, but I am a fast report new comer, please give me suggestion to me as soon as possible.
there are a set of data,
companycode jobcode jobnumber customercode description itemqty perunit from_place to_place remark
WIL ZC 2003100049 ZC NULL NULL NULL NULL NULL remark1
WIL ZCE 2003100001 ZCE INV#3090179 5 PLT TWIC testing1 remark2
WIL ZCE 2003100001 ZCE INV#3090181 2 PLT remark2
WIL ZCE 2003100081 ZCE INV#Z3100083 2 CTN TWIC KINTETSU remark3
WIL ZCE 2003100082 ZCE INV#31000517 3 PLT TWIC MORRISON EXPRESS remark4
WIL ZCE 2003100082 ZCE INV#Z3100074 10 PLT remark4
I want to produce the report format
ZC 2003100049 ZC
remark1
ZCE 2003100001 ZCE
INV#3090179 5 PLT TWIC testing1
INV#3090181 2 PLT
remark2
ZCE 2003100081 ZCE
INV#Z3100083 2 CTN TWIC KINTETSU
remark3
ZCE 2003100082 ZCE
INV#31000517 3 PLT TWIC MORRISON EXPRESS
INV#Z3100074 10 PLT
remark4
there are a set of data,
companycode jobcode jobnumber customercode description itemqty perunit from_place to_place remark
WIL ZC 2003100049 ZC NULL NULL NULL NULL NULL remark1
WIL ZCE 2003100001 ZCE INV#3090179 5 PLT TWIC testing1 remark2
WIL ZCE 2003100001 ZCE INV#3090181 2 PLT remark2
WIL ZCE 2003100081 ZCE INV#Z3100083 2 CTN TWIC KINTETSU remark3
WIL ZCE 2003100082 ZCE INV#31000517 3 PLT TWIC MORRISON EXPRESS remark4
WIL ZCE 2003100082 ZCE INV#Z3100074 10 PLT remark4
I want to produce the report format
ZC 2003100049 ZC
remark1
ZCE 2003100001 ZCE
INV#3090179 5 PLT TWIC testing1
INV#3090181 2 PLT
remark2
ZCE 2003100081 ZCE
INV#Z3100083 2 CTN TWIC KINTETSU
remark3
ZCE 2003100082 ZCE
INV#31000517 3 PLT TWIC MORRISON EXPRESS
INV#Z3100074 10 PLT
remark4
Comments