Share
ReportHi,
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
You’re offline. This is a read only version of the page.
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
Hello Ammar.
How did you get on with this?
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.
Or you can use FilteredAppointment view :)
SELECT COUNT(*) AS Count_ForEachUser, createdbyname
FROM dbo.FilteredAppointment
GROUP BY createdbyname
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.
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"
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
