Announcements
No record found.
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
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"
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.
Or you can use FilteredAppointment view :)
SELECT COUNT(*) AS Count_ForEachUser, createdbyname
FROM dbo.FilteredAppointment
GROUP BY createdbyname
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.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.