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.