When printing a sales report the items will be repeated for many pages but the total on the final page is correct. In this case the line item was repeated for 65 pages. How can I fix this?
Best answer by BenjaminCrisman
View originalLine Items Repeated on Sales Order Report
Userlevel 7
+17
Hi
if possible, can you please share the report file here?
I think that our integrators customized the report and I downloaded it to test something and then this problem started. I didn’t think I changed anything - I’m new to the report designer.
Userlevel 7
+4
Hi
What we will need is a .rpx report file, which can be created by clicking File > Save As in Report Designer with the report open.
This will generate a .rpx file which is the actual report.
Ok, I think this should be the rpx
Userlevel 7
+4
I would recommend to add links to this relation or remove it if it is not needed, but because the table is joining to itself there could be duplicates coming in and an alias could be needed for the Child Table.
Hope this helps clean it up!
Looks like that fixed it, thank you.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.