web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

report

(0) ShareShare
ReportReport
Posted on by 1,670

Hi,

i need to create report contains the number (count) for each appointment of CRM user, how i can create it ? 

*This post is locked for comments

  • Suggested answer
    Rajkumar Rajaraman Profile Picture
    on at

    Hi Ammar,

    Follow all the steps mentioned in the below Blog:

    crmdm.blogspot.in/.../sql-based-report-in-crm-2011-using-ssrs_29.html

    Hope this helps.

    Regards,

    R.Rajkumar

    "Please mark my answer as verified if you found it helpful"

  • Suggested answer
    Abed Haniyah Profile Picture
    4,287 on at

    Hello Ammar,

    You can achieve this by using SSRS. The view name is Appointment, below is the SQL script :

    SELECT        COUNT(*), CreatedByName

    FROM            dbo.Appointment

    GROUP BY CreatedByName

    Hope this helps,

    Abed.

  • Verified answer
    Abed Haniyah Profile Picture
    4,287 on at

    Or you can use FilteredAppointment view :)

    SELECT        COUNT(*) AS Count_ForEachUser, createdbyname

    FROM            dbo.FilteredAppointment

    GROUP BY createdbyname

  • Suggested answer
    Aileen Gusni Profile Picture
    44,524 on at

    Amma,

    You can use SQL Query if using onpremise, then group by owner Id of the appointment record

    While if you use crm online you need to group aggregate using fetch xml

    Thanks.

  • Abed Haniyah Profile Picture
    4,287 on at

    Hello Ammar.

    How did you get on with this?

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans