web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / How to connect account...
Customer experience | Sales, Customer Insights,...
Suggested answer

How to connect account and contact through LookUp function in SSRS report

(0) ShareShare
ReportReport
Posted on by sachinbisht 10

I want to connect two datasets in the SSRS report through the lookup function but I am unable to find the solution. Can anyone help

I have the same question (0)
  • Suggested answer
    Bipin D365 Profile Picture
    Bipin D365 28,983 Moderator on at
    RE: How to connect account and contact through LookUp function in SSRS report

    Hi,

    Are you using Fetchxml or SQL for SSRS report?

    If you are using Fetchxml then you can easily connect two entity record with the help of Advanced find.

    If you are using SQL then use Join statement to connect two data set.

    Select * from account a inner join contact c on a.primarycontactid =c.contactid

    Please mark my answer verified if this is helpful!

    Regards,

    Bipin Kumar

    Follow my Blog: xrmdynamicscrm.wordpress.com/

  • Suggested answer
    Pradeep Rai Profile Picture
    Pradeep Rai 5,489 Moderator on at
    RE: How to connect account and contact through LookUp function in SSRS report

    HI,

    Please check below link:

    https://www.crmsoftwareblog.com/2021/04/create-an-ssrs-report-for-dynamics-365-part-2/

    Thanks,
    Pradeep

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.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 258

#2
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 178

#3
Tom_Gioielli Profile Picture

Tom_Gioielli 142 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans