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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer Service forum / Tickets Dashboard - Da...
Customer Service forum

Tickets Dashboard - Daily report to summarizes all activities

(0) ShareShare
ReportReport
Posted on by RenatoPereira 230

Hi,

There is a way to automate a daily report with all tickets created, what is the most request product, what is the most engaged( defined) technician; how many tickets closed and oppened (and still open at the end of the day) and SLAs also?

Our tech manager would like to receive each day a summary.

Categories:
Other
I have the same question (0)
  • RenatoPereira Profile Picture
    RenatoPereira 230 on at
    RE: Tickets Dashboard - Daily report to summarizes all activities

    Hi,

    tks for reply, the ZAPObject-RS is so expensive since it is user and year based; it would be the last/last/last/last/last option.

    Reading the Bob Guidinger post, its incredible (to not say stupid) that MS offer an option when running on-premisses but not when online! Hello Microsoft, are you there????

  • Suggested answer
    Zap Objects Profile Picture
    Zap Objects 919 on at
    RE: Tickets Dashboard - Daily report to summarizes all activities

    Hi Renato,

    To schedule reports in Dynamics 365 CRM, you could try using Zap SSRS Report Scheduler App! This works with CRM Online as well as On-Premise and can email reports inline or as an attachment (pdf/excel) based on the recurring schedule you define!

    https://zapobjects.com/apps/zap-ssrs-report-scheduler/

  • Jeevan Kumar Balija Profile Picture
    Jeevan Kumar Balija 425 on at
    RE: Tickets Dashboard - Daily report to summarizes all activities

    Take a look at this.

    bguidinger.com/.../scheduling-reports-dynamics-365-part-1

    Same thing, you may achieve with the combination of MS flow and custom workflow/plug-in. So basically the flow will create/update some config record to trigger the workflow/plug-in, write custom code in workflow which executes the SSRS report and sends as an email in pdf or other formats.

  • LeoAlt Profile Picture
    LeoAlt 16,331 Moderator on at
    RE: Tickets Dashboard - Daily report to summarizes all activities

    Good day partner,

    If you are using On-premise instance, you could use SSRS Reports to create and send reports.

    https://www.powerobjects.com/blog/2011/06/29/report-scheduling-and-email-subscription-in-crm-2011/

    If you are using Online instance, you could refer to Mahender's answer in the following post.

    https://community.dynamics.com/crm/f/117/t/157425

    Hope it helps.

    Best Regards,

    Leo

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

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

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 > Customer Service

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans