Microsoft Dynamics CRM (Archived)

How to Deploy SSRS Report CRM 2013 On-Premise ?

(0) Share

Report

Posted on by account payable

670

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"

0412.error-in-live-while-upload-report.JPG

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (2)

Suggested answer

Syed Ibrahim 6,257 on at

Like (1)

Report

Pls follow the below link.

www.codeproject.com/.../Creating-a-SSRS-Report-With-Microsoft-Dynamics-CRM

Hope this helps

Was this reply helpful? Yes No
account payable 670 on at

Like (0)

Report

thank you for the link but this based on crm online but i need On-Premise

Was this reply helpful? Yes No
Verified answer

Syed Ibrahim 6,257 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
account payable 670 on at

Like (0)

Report

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>

Was this reply helpful? Yes No
account payable 670 on at

Like (0)

Report

Dear Syed Ibrahim ,

Am deploying the same like online but still showing error ,other exist report also showing error please find below screenshot file

Was this reply helpful? Yes No
Verified answer

Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Pejobi 5 on at

Like (0)

Report

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.

Was this reply helpful? Yes No