One of our reports, the print invoice report, is now showing multiple of the same item. I assume its from a bad join, but I’m not sure where it is or how to fix it.

One of our reports, the print invoice report, is now showing multiple of the same item. I assume its from a bad join, but I’m not sure where it is or how to fix it.
Best answer by BenjaminCrisman
The second issue is that joining in SOPackageDetailEx is going to cause duplicates and should instead be included by adding a subreport and using this table in the subreport. Anytime there is a one-to-many type relation which is unavoidable due to needing to bring the data into the report, it is necessary to use a subreport for this. Are you familiar with this process?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.