Your joins look correct the field can you show me the fields on the report.

Hello @dcomerford , this is what I am using:
 

Weird sent me the report and I will put test it on my local dataset

Have attached the report.

The issue is the filter on the report. If you dont have a Purchase Order of type RS linked to the project you are running it for you wont get any results i changed it to an Or as i dont have that order type

The issue is the filter on the report. If you dont have a Purchase Order of type RS linked to the project you are running it for you wont get any results i changed it to an Or as i dont have that order type

 

Hey @dcomerford ,
Thank you for your guidance, but the Order Type = RS is the mandatory filter that I am looking to apply, since I want to only display the subcontract records. Also, I followed your guidance, but the system is displaying incorrect, as shown below:
 

@Mondeddula Madhu Venkat Reddy I would remove all the tables you dont need from the report and get the basics working and then add the joins and check then as you go.by adding a field from each table to check the results are right. There is nothing wrong with the fields the joins are causing the issue you are getting either too many or no records because of the user of Left and inner joins