By using this website, you agree to our Terms of Use (click here)
I'm working on creating a report that contains all of the contact information for the other trades we typically coordinate with onsite. Information would be found in the Construction module under Projects and the Contacts tab.
I'm having trouble getting the coding to pull the correct information. Right now, it's pulling in a random contact that isn't associated with the project I am using for testing. I'm sure there is a table or relation that I am missing, but every time I make a change it gives me a new error.
The other thing is each project could have several contacts associated with it that I would need to break out per role on the report. I would think that I could add some type of parameter for each role to pull to a different designated location on the report but want to make sure this is even feasible before I invest too much time into trial and error.
Element Properties for Contacts:
Current Relationships:
Current String: =[ProjectContact.ContactId_Contact_displayName]
Thanks for your help!
Try this:
As you can see, these top two records...
Appear on the CONTACTS tab of the Projects (PM301000) screen:
@timrodman Hey Tim, thanks for your response. We ended up using a subreport with filters set based on the role value. So far this has been working like we need and has been easy to make changes.