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
Best answer by mcoman
Yes, I see it there myself. Its on the schema page but its not on the relationship page. Why would that be?
+19Hi
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.
+19Hi
Can you please let me know, which version you working on?
+19+19Hi
Still having no luck finding out how to get this link in the report designer. Any suggestions would be helpful. Version is 2020r2
+19Hi
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
