0

empty column appended at the end of the data columns

Mee_NewUser

October 08, 2019 07:35

None

Follow

Hi

i am trying to extract sales report using jet reports. When i am using sales invoice header and exporting data, everything works fine. When i am linking 2 sources like sales invoice header and salesperson name, then there is a empty column getting appended at the end. I dont know if it has to do something with its settings. I am absolutely new to this hence not sure if its a basic issue.

 

One more concern was, i was inserting an column at the end to calculate the amount , when i refresh the period or range, the column disappears, is there a way to lock that column along with the formulas in it.

 

 

Thanks in advance. 

• Facebook
• Twitter
• LinkedIn

5 comments

• 0
  
  Bryan Robinson October 08, 2019 19:31

  Hi Mee

  I don't fully understand your first issue where there is an empty column and probably wouldn't be able to really understand without seeing the report.  You might want to reach out to a consultant to look over the report.

  As for your second issue, if you are adding a column at the end while in Report mode and then refreshing, that is expected Jet behavior.  Any changes made to reports in Report mode are not saved when refreshed.  https://support.jetglobal.com/hc/en-us/articles/219402737-Difference-between-Design-Mode-and-Report-Mode-

• 0
  
  Mee_NewUser October 09, 2019 08:39

  thank you for the response.

  okay i get it now. If u see below, in that you can observe a column hidden and its empty. This is appended everytime i refresh the report. 

• 0
  
  Mee_NewUser October 09, 2019 14:36

  can you also help me how to extract all the items list from invoice for a particular period.

  When i am trying to extract, it only gives me the first product name and the rest is ignore.

  I am trying to find all the products sold in particular period

   

  thanks in advance!!

  Edited by Mee_NewUser October 09, 2019 14:37
• 0
  
  Bryan Robinson October 09, 2019 14:56

  I see you are using the Table Builder.  Again, this is expected behavior.  There is content there that is being hidden during run-time.  It is necessary for the report but unnecessary for the end user to see.  There is nothing you can do about this.  You will probably notice that there are some hidden rows, as well.

  As for help extracting data, without having the report itself, I can't really help.  I can say that if you are trying to get a list of all transactions for your items, you should be starting with a transaction table, such as Item Ledger Entry.  It sounds like you selected the Item table but no real way for me to know.  Again, this is where a true consultant might be helpful since they can work with you in your environment.

• 0
  
  Mee_NewUser October 10, 2019 06:41

  Thanks for the information. I am not sure if i can get a consultant to help at this moment.

   

  I am trying to working with sales invoice header and sales invoice line. There is a list of items that customer has purchased but when i try to access them, i only get the output with the first item name and number (expected behavior) but i want to know if there is a way to extract all the items purchased by that customer.

   

  Thanks in advance!!