Hi all,
I am developing a report o/p of which is a file in excel format.Now in the file for the data which is being exported to the file,I need to make the following changes:
Follwing are the columns in the file:
g/l acc amount vendor description company code.
At each change in the company code value,I need to insert a new line in the file (file data) which should have the sum of the amounts in the column "amount" in the new line and the company code .All other fields in the new line should be blank.See below for the exact o/p needed:
g/l acc amount vendor description company code.
5550601 10 ABC VISA FEB 2009 US02
5550601 20 ABC VISA FEB 2009 US02
5550601 30 ABC VISA FEB 2009 US02
5550601 40 ABC VISA FEB 2009 US02
-->new line -
100 US02
5550609 15 ABC VISA FEB 2009 US03
5550609 15 ABC VISA FEB 2009 US03
5550609 17 ABC VISA FEB 2009 US03
5550609 18 ABC VISA FEB 2009 US03
-->new line 65 US03
5550607 15 ABC VISA FEB 2009 US04
Can anyone explain how to modify the data(before creating the file) to get the o/p in the file as mentioned above?
Thanks.