AnsweredAssumed Answered

How to Export Records in spreadsheet without any blank cells?

Question asked by starstuff on Jul 2, 2015
Latest reply on Nov 10, 2015 by johnz

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!

Outcomes