i need to display records on EXCEL SHEET from sales header table and sales line table in which formate of report is that first I need to select all the customer on specified date(like on specified posting date) from sales header table then and all the retrieved records from sales header table must be displayed on sigle row but different columns.then only corresponding itme and quantity for particular customer must be displayed on different rows but items must only be displayed once in single column but multiple rows only quantity need to be displayed on appropriate position coresponding to customer and item ordered by that customer. format must be like cust1 cust2 … … item1 Qty1,1 Qty2,1 item2 Qty1,2 Qty2,2 . . . . . . . . . . . .
Try to search this forum for more information and have a look at the table 370 Excel Buffer.