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 and SLA KPI
Microsoft Dynamics CRM (Archived)

SSRS Reports and SLA KPI

(0) ShareShare
ReportReport
Posted on by Talsim

Hi,

Quick question, is it a bug that KPI SLA does not have Filtered View?

any ideas how to retrieve the data for SSRS report? (FetchXml does not supply the functionality i want from the report).

ON Premise - CRM 2016 SP1

*This post is locked for comments

I have the same question (0)
  • Alagunellaikumar Profile Picture
    Alagunellaikumar 6,212 on at

    HI

    Please refer below site

    stackoverflow.com/.../how-to-get-the-data-source-information-from-a-ssrs-report-using-net

    www.codeproject.com/.../Call-SSRS-Reports-by-using-Csharp

  • Talsim Profile Picture
    Talsim on at

    Hi Alagu, I am not trying to call SSRS report but to get the sla kpi data INTO a SSRS report

  • Suggested answer
    Bojan.borisovski@hotmail.com Profile Picture
    Bojan.borisovski@ho... 480 on at

    Hi Tal,

    There doesn't seem to exist a filtered view towards the SLAKPIInstance entity.

    But I would suggest two other options which you can do, to achieve your goal:

    1. Use fetch xml to fetch data from that table. (recommended)

    Sample:

    <fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">

     <entity name="slakpiinstance">

       <attribute name="name" />

       <attribute name="status" />

       <attribute name="regarding" />

       <attribute name="failuretime" />

       <attribute name="warningtime" />

       <attribute name="succeededon" />

       <attribute name="slakpiinstanceid" />

       <order attribute="name" descending="false" />

     </entity>

    </fetch>

    What exactly is not working out for you using the fetch xml? 

    2. Use directly the SLA BASE db table by logging in through an embedded user credentials in the report, to access the BASE table. (not recommended.)

    Thanks,

    Bojan

  • Talsim Profile Picture
    Talsim on at

    I want the report to show a calculated column of the business days between now and the failure date

    using fetchxml does not help in this issue. I know about direct use, but I wanted to avoid it.

    too bad Microsoft is not consistent with their product.

  • Suggested answer
    Bojan.borisovski@hotmail.com Profile Picture
    Bojan.borisovski@ho... 480 on at

    When making reports, sometimes all you need it to bring the data in it, and after this, you can use any kind of VB scripts, or SSRS functionality to achieve your requirement. Practically you are not limited in what you want to do.

    And determining amount of time/duration between two dates, is fairly simple.

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