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?
Solved
Line Items Repeated on Sales Order Report
Best answer by BenjaminCrisman
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!
+20Hi
if possible, can you please share the report file here?
Translate
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.
Translate
+4Hi
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.
Translate
Ok, I think this should be the rpx
Translate
+4I 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!
Translate
Looks like that fixed it, thank you.
Translate
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.