Skip to main content
Answer

Missing data on excel download

  • February 29, 2024
  • 2 replies
  • 137 views

Forum|alt.badge.img

When running “Transaction for Period” report all data appears on the screen.  When downloading to excel it does not bring “Customer/Vendor” Field.  I have cleared out both sides of the column in Report Designer to make sure there is no overlap.  Moved the “Description” field off the page for now - though it does not download that information either.  

Confirmed that the properties fields for “Customer/Vendor” is the same as the “Code” column - which does print.


Displayed Report below:
Results from Excel Download below:
What am I missing?

 

Best answer by Laura03

Hello @jddonnell55 ,

Show Excel Columns and make sure no two fields have the same Excel coordinates:

I expect you will find two fields in a row with the same Column. Renumber the columns from left to right in each section, so they are unique and do not overlap. Excel coordinates appear in Green:

Laura

2 replies

Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • Answer
  • March 1, 2024

Hello @jddonnell55 ,

Show Excel Columns and make sure no two fields have the same Excel coordinates:

I expect you will find two fields in a row with the same Column. Renumber the columns from left to right in each section, so they are unique and do not overlap. Excel coordinates appear in Green:

Laura


Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • March 1, 2024

Hi,

One more thing… sometimes there is an Excel Columns Collection on the main report “report 1 Report” section:

May need to add a column in the Collection.

Laura