3 Replies Latest reply on Nov 10, 2015 1:18 AM by johnz

    How to Export Records in spreadsheet without any blank cells?

    starstuff

      Title

      How to Export Records in spreadsheet without any blank cells?

      Post

      Hi All!

       

      I'm trying to export records INVOICES and LINE TABLES to spreadsheet (excel format), i was able to successfully export all the records, the problem i encounter is that each Invoice with Supplier name is listed only once. I would like the Invoices and Supplier Names be on each LINE ITEM.

       

      current export

      Date , Invoice No 1 , Supplier Name , Product 1 LINE ITEM

                                                            Product 2 LINE ITEM

                                                            Product 3 LINE ITEM

                                                            Product N LINE ITEM

      Date , Invoice No 2 , Supplier Name , Product 1 LINE ITEM

                                                            Product 2 LINE ITEM

                                                            Product 3 LINE ITEM

                                                            Product N LINE ITEM

       

      i would like it be like below

      Date , Invoice No 1 , Supplier Name, Product 1 LINE ITEM

      Date , Invoice No 1 , Supplier Name, Product 2 LINE ITEM

      Date , Invoice No 1, Supplier Name, Product 3 LINE ITEM

      Date , Invoice No 1 , Supplier Name, Product N LINE ITEM

      Date , Invoice No 2 , Supplier Name, Product 1 LINE ITEM

      Date , Invoice No 2 , Supplier Name, Product 2 LINE ITEM

      Date , Invoice No 2, Supplier Name, Product 3 LINE ITEM

      Date , Invoice No 2 , Supplier Name, Product N LINE ITEM

       

      Is this possible?

       

      Thank You!