Solved Report giving repeat body display (1 Viewer)

jgcns

New member
Local time
Today, 04:49
Joined
Dec 31, 2020
Messages
12
Dear all,

Finally I got to the Report Part, but i am facing an issue... My report is showing repeated bodies. for each record ( Purchase Order) it shows repletely the same info as many as the number of records of Sub Report..

Please FInd some pictures for a better understanding.


Screenshot 2021-01-09 171809.png
Screenshot 2021-01-09 171752.png

The Control source is a query created by me that mixture Purchase Order table with Requisition and Spare part List

1610213383501.png


Do you know what are the possible causes?

Thank you in advance!
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 21:49
Joined
Oct 29, 2018
Messages
21,358
Hi. It's not clear to me which records are repeated in your report by just looking at those images. I see multiple plugs, but they all have different quantities.
 

jgcns

New member
Local time
Today, 04:49
Joined
Dec 31, 2020
Messages
12
they are screenchots on after another
they make a single report
 

Rene vK

Member
Local time
Today, 05:49
Joined
Mar 3, 2013
Messages
123
There must be something wrong with the JOIN in your query.
 

jgcns

New member
Local time
Today, 04:49
Joined
Dec 31, 2020
Messages
12
well deleting all other tables it works fine... i'll get the info by other way. Thanks!
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 21:49
Joined
Oct 29, 2018
Messages
21,358
well deleting all other tables it works fine... i'll get the info by other way. Thanks!
Hi. Glad to hear you got it sorted out. Good luck with your project.
 

Users who are viewing this thread

Top Bottom