I am using the graphical query tool to create a Work Orders report. All is good, except due to our customer changing some procedures internally, we can no longer rely on our old filters.
Therefore, we now have double/triple values in the Work Order Number Column [MFG]MFGNUM.
Everything would be easily solved if I could just setup the report to only export 1 line / each WO Number. There is no concern regarding the lines that won't show up, as this would be our main focus, getting each WO once in our report.
Is there any way of doing this from the Graphical Query Tool, without SQL knowledge?
Also, I've seen an older post on this topic, however I haven't really understood how to do it. I'd appreciate it if someone could guide me.