Creating 2 report from a PS file
Posted: Thu May 14, 2009 8:12 pm
Hi,
I have a PS file of LRECL 80 which looks like:
003,0007567,000001074620.09,03022009
003,0007252,000001403673.91,03032009
003,0005997,000000954221.77,03042009
003,0005290,000000846802.86,03052009
003,0005849,000000839802.27,03062009
004,0023819,000006339496.60,03022009
004,0017969,000005548016.89,03032009
004,0019176,000005684130.41,03042009
004,0017012,000004729511.17,03052009
004,0019796,000006463564.86,03062009
008,0076990,000014350619.12,03022009
008,0058747,000011312074.57,03032009
008,0053474,000009838281.04,03042009
008,0050253,000009910061.53,03052009
Where it indicates Division,Invoice Lines,Invoice amount,Invoice date
Now from the above file, 2 reports needs to be created which looks like:
Report1 : Sales Invoice Records by Day(Invoice lines/Day/Division)
Divisions InvDay1 InvDay2 InvDay3 InvDay4 InvDay5 InvDay6 Total
003 100 100 100 100 100 100 600
004 200 200 200 200 200 200 1200
008 300 300 300 300 300 300 1800
Total 600 600 600 600 600 600 3600
Report1 : Sales $ by Day(Invoice amount/Day/Division)
Divisions InvDay1 InvDay2 InvDay3 InvDay4 InvDay5 InvDay6 Total
003 $1000 $1000 $1000 $1000 $1000 $1000 $6000
004 $2000 $2000 $2000 $2000 $2000 $2000 $12000
008 $3000 $3000 $3000 $3000 $3000 $3000 $18000
Total $6000 $6000 $6000 $6000 $6000 $6000 $36000
Can I do it by using SORT/ICETOOL??
Please help.
I have a PS file of LRECL 80 which looks like:
003,0007567,000001074620.09,03022009
003,0007252,000001403673.91,03032009
003,0005997,000000954221.77,03042009
003,0005290,000000846802.86,03052009
003,0005849,000000839802.27,03062009
004,0023819,000006339496.60,03022009
004,0017969,000005548016.89,03032009
004,0019176,000005684130.41,03042009
004,0017012,000004729511.17,03052009
004,0019796,000006463564.86,03062009
008,0076990,000014350619.12,03022009
008,0058747,000011312074.57,03032009
008,0053474,000009838281.04,03042009
008,0050253,000009910061.53,03052009
Where it indicates Division,Invoice Lines,Invoice amount,Invoice date
Now from the above file, 2 reports needs to be created which looks like:
Report1 : Sales Invoice Records by Day(Invoice lines/Day/Division)
Divisions InvDay1 InvDay2 InvDay3 InvDay4 InvDay5 InvDay6 Total
003 100 100 100 100 100 100 600
004 200 200 200 200 200 200 1200
008 300 300 300 300 300 300 1800
Total 600 600 600 600 600 600 3600
Report1 : Sales $ by Day(Invoice amount/Day/Division)
Divisions InvDay1 InvDay2 InvDay3 InvDay4 InvDay5 InvDay6 Total
003 $1000 $1000 $1000 $1000 $1000 $1000 $6000
004 $2000 $2000 $2000 $2000 $2000 $2000 $12000
008 $3000 $3000 $3000 $3000 $3000 $3000 $18000
Total $6000 $6000 $6000 $6000 $6000 $6000 $36000
Can I do it by using SORT/ICETOOL??
Please help.