Skip to main content

Notifications

Announcements

Forum Structure Changes Coming on 11/8
Give Back to the Community this Month
News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / How to deliver data dr...
Finance forum
Suggested answer

How to deliver data driven SSRS reports to Emails automatically in D365 Finance and Operations?

(0) ShareShare
ReportReport
Posted on by Momochi 857
Hi dear community !
 
I was looking into sending a daily SSRS report through Email to each department head. And each department head should have a report with data related to his department only.
And I've found about SSRS Data Driven Subscription in SQL Server Reporting Server.
But since the environment I'm working on is D365 FO Cloud version. So I don't have access to the AxDB, which is required for Data Driven Subscription to assign a data source to get for example the department heads emails to assign as a recipients values in Email.
I'm wondering if SSRS Data Driven is valid for D365 FO cloud? or there are better options or tools to implement a case like this e.g. Power Automate maybe but I'm not sure how.
 
Can you please advise how to approach this case where we need to send a daily report through email for different recipients, each recipient having a filtered report related to him/her?
 
Any advice is appreciated !
Thanks in advance ! 
Categories:
Finance
  • Martin Dráb Profile Picture
    Martin Dráb 229,173 Most Valuable Professional on at
    How to deliver data driven SSRS reports to Emails automatically in D365 Finance and Operations?
    You can select a print destination before printing a report. Look at Print or email a report, for instance.
  • Momochi Profile Picture
    Momochi 857 on at
    How to deliver data driven SSRS reports to Emails automatically in D365 Finance and Operations?
    Hi Martin Dráb, I hope you are having a good day.

    That's great to know having this feature natively available in D365 FO.
    But where can I read about this or where to look into it in D365 FO?
  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 229,173 Most Valuable Professional on at
    How to deliver data driven SSRS reports to Emails automatically in D365 Finance and Operations?
    SSRS Data Driven Subscription isn't an option, but the standard reporting framework inside F&O is already able to send printed documents to email.
     
    In your particular requirement, you'll likely have a table defining which filters should be used for which worker. Then you'll have a batch iterating records in this table, printing a report with the given filters for each entry and using the worker's email address at the print destination.

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

Forum Structure Changes Coming on 11/8
Give Back to the Community this Month

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,867 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,173 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans