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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / SSRS reports vs Advanc...
Microsoft Dynamics CRM (Archived)

SSRS reports vs Advanced Find

(0) ShareShare
ReportReport
Posted on by yify 1,023

Hi,

Can anyone help me understand with some scenarios of reports where you will be going for SSRS reports than using the Advanced find Excel reports?

Couple scenarios of SSRS reports with examples is highly appreciated

Thanks!

*This post is locked for comments

I have the same question (0)
  • Verified answer
    a33ik Profile Picture
    a33ik 84,331 Most Valuable Professional on at

    Hello,

    The best example I believe is print forms with stylings, logos e.t.c. - you can't get it using Advanced Find.

    Also you can't use aggregates/groupings using Advanced Find.

    Another advantage of reports over advanced find is that on the same report you can get data from different recordssets like contacts, accounts and opportunities.

    Plus you can build diagrams and charts using SSRS.

  • Verified answer
    gdas Profile Picture
    gdas 50,091 Moderator on at

    Hi James,

    In addition to Andrew answers ,using Advanced find  we can not retrieve multiple related records for example if we want to retrieve Accounts list with multiple contacts you can not get using advanced find reports. Another example let say you want to add footer in a report where you want to display the total amount , you can not do it using advanced find report.

    Due to that we are moving to SSRS reports.

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

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans