Skip to main content

Notifications

Small and medium business | Business Central, N...
Answered

How to schedule reports on behalf of users?

Posted on by 130

Hi Community,

I understand each user can schedule reports, but what if I want to send a report to a group of users at a scheduled interval?

I am sure this can be done with codeunits in AL, but is there a standard means to do this in BC?

The example is - I would like to schedule  5 different reports to go to 3 different groups of people. So it is more efficient for me to schedule/send, vs each person having to do so.

Thank you in advance

  • Suggested answer
    Shawnsauve Profile Picture
    Shawnsauve 1,089 on at
    RE: How to schedule reports on behalf of users?

    While Business Central does allow individual users to schedule and receive reports, sending a report to a group of users at a scheduled interval can require a more customized solution.

    Luckily, there are a few different options available to accomplish this. One way is to create a codeunit in AL that retrieves the report and sends it out to a designated group of users via email or another communication method. This would require some development work, but it can be a great solution if you have specific requirements for the report delivery.

    Another option is to use a third-party extension that provides group reporting functionality. Some extensions allow you to create and manage report distribution groups within Business Central, making it easy to schedule and send reports to specific groups of users.

    It's also worth noting that some cloud-based email services, such as Microsoft Exchange Online, have built-in functionality to distribute reports to groups of users on a scheduled basis. This can be a great option if you already have a cloud-based email service in place.

    Ultimately, the best approach will depend on your specific needs and technical capabilities. If you need more guidance on this, I'd recommend consulting with a Business Central expert or Microsoft partner. They can help you evaluate the available options and choose the best one for your organization.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,411 Super User 2024 Season 2 on at
    RE: How to schedule reports on behalf of users?

    Hi, using Power Automate might also be a good choice, but maybe need to add some customization as well.

    Hope this helps.

    Thanks

    ZHU

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: How to schedule reports on behalf of users?

    You can not do this is Business Central with out coding as far as I know.

    But as you already mention yourself - using AL you have lots of options to achieve this.

    Maybe you also can look into using Power BI for the reports so you do not have to distribute them.

  • Verified answer
    DAnny3211 Profile Picture
    DAnny3211 9,272 Super User 2024 Season 1 on at
    RE: How to schedule reports on behalf of users?

    hi

    it is possible to send reports to a group of users at a scheduled interval in Business Central. One way to achieve this is by creating a custom codeunit that includes a function to generate and send reports to the specified group of users.

    Here are the basic steps to achieve this:

    Create a custom codeunit that includes a function to generate and send the report. The function should include parameters for the report ID, the recipients (e.g. a group of users), and the scheduling interval.

    Within the function, you can use the REPORT.RUNMODAL function to generate the report, and the CODEUNIT.RUN function to send the report to the specified recipients.

    In order to schedule the report to run at a specific interval, you can create a job queue entry and set the job queue event to trigger the custom codeunit.

    Finally, you can configure the job queue to run at the desired interval, and specify the report ID and recipient group for each scheduled run.

    This approach will allow you to automate the generation and distribution of reports to a group of users on a regular schedule, without requiring each individual user to schedule the reports themselves.

    Daniele

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 45 on at
    RE: How to schedule reports on behalf of users?

    Hi,

    You can try the relationship management module of Business Central. Its a bit of setup you need to do but its a no code solution.

    See the link below, its in NAV but almost same is in BC as well.

    (+) Using mailing groups to send contact mails - Microsoft Dynamics NAV Community

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,104 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans