670
Hi
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"
*This post is locked for comments
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.
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.
Dear Syed Ibrahim ,
Am deploying the same like online but still showing error ,other exist report also showing error please find below screenshot file
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=6.0.0.0, 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">
<ErrorCode>-2147188072</ErrorCode>
<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>
<Timestamp>2017-12-21T14:41:55.7799189Z</Timestamp>
<InnerFault i:nil="true" />
<TraceText i:nil="true" />
</OrganizationServiceFault>
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?
Thanks.
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.
thank you for the link but this based on crm online but i need On-Premise
Pls follow the below link.
www.codeproject.com/.../Creating-a-SSRS-Report-With-Microsoft-Dynamics-CRM
Hope this helps
#1
Mohamed Amine Mahmoudi
83
Super User 2025 Season 1
#2
Community Member
52
#3
dkrishna
6
Share
Report
All responses (
Answers (
