I created a report using a 'Union' as I am wanting to pull data from multiple tables. I also have an 'IF' formula to pull data from one table if an order has shipped, and pull data from a different table if it has not shipped. However when I run the report it duplicates the lines several times. My data is listed out as follows:
I also have the additional NL functions to pull data from the corresponding tables:
'=@NL("Rows","Sales Line Archive",,"Document No.",H8,"No.","FG*")
'=@NL("Rows","Sales Invoice Line",,"Document No.",Q8,"No.","FG*")
Example of how the report looks once it's run below:
