Join PMSiteAddress to PMProject in the report writer
We are trying to join project addresses to each project in a report. We have done it GI without a problem using the PMProject.projectid and PmSiteAddress.contractid fields in each table.
But when we go to report writer we are not able to see the same fields.
We tried PMProject.Locationid = PmsiteAddress.addressid without success. Has anyone done this in report writer successfully?
Thanks
Page 1 / 1
Hi @mcoman Would you please share the report to take look and suggest the joins.
Thanks
Hi @mcoman Have you checked below condition and verified?
PMSiteAddress.addressID = PMProject.siteAddressID
I guess that is what I am having a problem doing. I cannot see the pmproject.siteaddressid in the report writer.
Hi @mcoman I see that those fields are available. Please find the screenshot for reference.
Can you please let me know, which version you working on?
Interestingly enough I dont see that
@mcoman Can you please let me know which version you are working on ?
20.210.0044 is the version.
Hi @mcoman Sure, let me check on the 20 R2 version and let you know.
Still having no luck finding out how to get this link in the report designer. Any suggestions would be helpful. Version is 2020r2
Hi @mcoman I have checked this in the 2020 R2 version and I can able to see the PMSiteAddress.addressID = PMProject.siteAddressID.
Please find the screenshot for your reference.
In your report, can you please click on the Load Schema button and Refresh ALL and verify once from your end.
Yes, I see it there myself. Its on the schema page but its not on the relationship page. Why would that be?
Naveen,
Thank you!! I appreciate your patience. I kept having to load schema and refresh. But eventually it worked.