Skip to Content
0
Former Member
Mar 24, 2009 at 05:54 PM

Report o/p needed in particular format----please help

20 Views

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.