Forum Discussion
Removing duplicate rows, data from different (joined) data sources
I have a report that's a combination SalesOrderHeaders and SalesOrderLines: Customer, Service Purchased, Invoice Date, Amount Due Boston College, Subscription for HE, 4/5/2020, $400 York Cit...
...or I have to build a named TABLE out of at least three database joins, filter it down and then jump over to the report view to finish the summary. Parking it for tonight - shouldn't be doing work today anyway 🙂
All fixed. I ended up doing a mass clean of data ahead of putting it into report form, including sorting and de-duping the rows. But then going into the advanced editor to wrap a text.buffer function around the sort descending, just ahead of the de-duplication. With that, rebuilt the report and it's now live with all our users.
Thank you! I'm now coming up the learning curve at a pretty decent pace 🙂