Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 2 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
SQL 2016 v18.4,
We have recently installed new instance of CRM 2016 with SQL 2016 v 18.4 but SSRS reports are not working, i have also installed the extension kb3154952.
Same is working in SQL 2012 R2 with CRM 2016 is this related to version, can anyone help how this can be fixed? CRM version is 22.214.171.1241
Hello my friend,
First of all you should open the reports in your visual studio solution and point the data sources on the CRM 2016 data base.
Test them on your visual studio and make sure thay are working fine. after that regenerate the rdl and deploy them one more time in CRM.
If still have problem please post the error messag ethat is deplayed.
Hope this works.
Actually there is no error on the screen or in the event viewer,i saw in the report builder the report is working fine and parameters are shown in a normal way.
The above image i showed is the issue, where the view report button and even parameters are not rendered and clickable.
The only error i see is below in event viewer but its not frequent.
Report Server (MSSQLSERVER) cannot load the TERADATA extension.
Report Server (MSSQLSERVER) cannot load the SQLPDW extension.
Report Server (MSSQLSERVER) cannot load the ORACLE extension.
Any suggestions please ?
i would suggest :
1- Log in to the report server where ur reports are deployed, and go to servername/.../ and go to one of your reports details and verify each one of the connection managers , you will find a 'TEST CONNECTION' button linked to each one of them. i think this may be the main problem.
2- enabling Tracer and try opening the report to see more details on the error.
Hope this helps my friend.
I tried first point but all same
then i tried your second suggestion and it showed me an error of the organization you are trying to connect is disabled.
I have two organizations here one is disabled the default one the other one was imported into the system which is production.
How can i solve this problem? I dont want to enable the other organization but shouldnt the report server be working with multiple instance in the CRM ?
getting closer to the issue
Found out the issue but its strange.
We have two environments in our setup.
One is default installation vanila version, the other is the imported organization which we are using as primary.
The default organization was disabled hence the reports were not working in the other imported organization.
When i enabled that one the reports are working fine and with proper data of new imported organization data.
Any solution to this strange behavior?
Thanks in advance !
Business Applications communities