I want to get Account related post, Activities and Contacts using SSRS. How can I link these 3 tables with account table
*This post is locked for comments
There are several relationships, the most likely are:
Contacts are related to the account via the contact.accountid or contact.parentcustomerid field, linked to the account.accountid
Posts are linked via the post.regardingobjectid, linked to the account.accountid
For activities, there are 2 options:
Hi,
you can simply apply inner joins with all the three entities, select only the columns that you require.
select * from Account a inner join
Contact c
ON a.AccountId = c.AccountId
inner join ActivityPointer ap
ON a.AccountId = ap.RegardingObjectId
Hello
there is regarding field is available in activities and customer field in contact.
Now you can get records related to a particular account.
Hope you can understand what I mean!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
HR-09070029-0 2
ED-30091530-0 1
