Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 1Discover the latest updates and new features to Dynamics 365 planned April 2021 through September 2021.
Release overview guides and videos Release Plan | Preview 2021 Release Wave 1 Timeline
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
First post to this community but I have searched for anything similar and don't see it asked/answered anywhere.
I have at least 50 system views across 5 entities in CRM 2011. These views let me check for invalid data in records, missing data, data requiring follow-up and various other data issues. Most of the time most views return 0 records (which is the desired-for result) and require no input from me however actually confirming that this is the case requires tediously checking each view and I am expected to check these views every week or so to prevent the data issues building up.
It would be a LOT less manual checking these often non-existent records if I could design one "super record count report" that returns the total records concerned from each of these system views and therefore know which of the many views really require my attention.
I have only a basic login and no access to the SQL server (CRM server is off-site). I have already made use successfully of Power Query/Get and Transform via an OData connection for other analyses (but views can't be seen AFAIK in that query designer). I have report permission, publish report permission and reporting services permission on my account. I have downloaded XRM toolbox with FXB and SQL Server Tools VS 2012 with Fetch Xml capability installed and felt one of these should offer the solution to my problem but is SSRS what I should be even thinking of using or is there something else that would achieve this?
Any help with the flow of what I have to do to make a report like this would be really useful. One entity at a time is fine (i.e. 5 separate reports) but if it is possible to do all in one report that would be the most effective.
SSRS should be able to do this - you can show everything in one view.
Or you might check conditions on each of the views in CRM (per entity) and create a new view which would use a combination of those conditions (using "OR"). Then you might be able to end up with just 1 view per entity.
If/when you have that, you can create a dashboard and put those views on the dashboard (although, I think you can have up to 6 per dashboard, so, maybe, a few dashboards)
You should be able to do all of that as your "personal" views/dashboards - it should not require admin rights.
Business Applications communities