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.
2022 Release Wave 2Check out the latest updates and new features of Dynamics 365 released from October 2022 through March 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
Any one give me solution how to deploy SSRS Report CRM On-Premise
because when i upload report (ssrs report) to crm showing error "Erro uploading Report"
Pls follow the below link.
Hope this helps
thank you for the link but this based on crm online but i need On-Premise
For online also you can use the same. Only difference is the way of constructing the the query. For online you need to use fetch xml and for on premise you can use sql queries. Deployment method is same for both.
What tool are you using to Create the report?
What version of SQL Server do you use?
Some of the report designers have Xml as part of the report that has to be modified to work with different versions of SSRS.
Can you download the log file and show the error message?
1. What tool are you using to Create the report? : am using SSRS
2. What version of SQL Server do you use? : SQL SERVER VERSION 2008
downloaded the error from log file please find below error details
Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=220.127.116.11, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: An error occurred while trying to add the report to Microsoft Dynamics CRM. Try adding the report again. If this problem persists, contact your system administrator.Detail:
<OrganizationServiceFault xmlns:i="www.w3.org/.../XMLSchema-instance" xmlns="schemas.microsoft.com/.../Contracts">
<ErrorDetails xmlns:d2p1="schemas.datacontract.org/.../System.Collections.Generic" />
<Message>An error occurred while trying to add the report to Microsoft Dynamics CRM. Try adding the report again. If this problem persists, contact your system administrator.</Message>
<InnerFault i:nil="true" />
<TraceText i:nil="true" />
Dear Syed Ibrahim ,
Am deploying the same like online but still showing error ,other exist report also showing error please find below screenshot file
Unfortunately, the error does not give much additional information.
Can you try and upload your rdl file directly into SSRS?
This might give you the error that you are looking for in order to figure out what the exact problem is.
You might find something also in the event viewer on SSRS or CRM servers that might help find out the reasoning.
Let us know.
I see this is an old post, but I have seen this error when one of the following conditions are true.
1. You are uploading the wrong version of the RDL file. From Visual Studio be sure you are taking the RDL file from the /bin directory and not from the actual project folder.
2. Your driver for SQL server is not a compatible version. In Visual Studio be sure you are changing your SQL Server driver to something less than 2016.
Business Applications communities