Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Automation of report

Posted on by Microsoft Employee

Hello All,

What I need is to have an automation of the report that once the bill date is reached the report is generated as pdf, saved to notes of the entity (Custom entity) and also get exported to a file share with the file name as "InvoiceDate-CustomerNumber-InvoiceNumber" ? 

How can I do that? Do I need to create a plugin for that or there's another way to do this?

Thanks!!!!

*This post is locked for comments

  • Verified answer
    jlattimer Profile Picture
    jlattimer 24,558 on at
    RE: Automation of report

    Generating a SSRS report in CRM Online automatically isn't possible. There are some hacks do to it from the client side but they're unsupported. It's possible to leverage the Document Template functionality and call the associated Action from a workflow to generate a document. Some code could be written to retrieve it from the Note it gets attached to for conversion to PDF. That would require a third party library being ILMerged with a plug-in or an external service. 

    There are ISVs that handle document generation but they usually rely on an external service for conversion. 

    Exporting data to your own reporting server could be an option.

    Then getting it to a file share from Online - again would probably need a service application running on the server when the file is going to end up which could be called from a plug-in.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Automation of report

    Online

  • jlattimer Profile Picture
    jlattimer 24,558 on at
    RE: Automation of report

    Online or On-Premise?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans