I am facing an issue with the SSRS report we created for MS Dynamics CRM on premise

(0) Share

Report

Posted on by account payable

670

Hi,

I am facing an issue with the SSRS report we created for MS Dynamics CRM. The SSRS report runs fine on BIDS(2008) but when it is deployed on CRM and run from there we get the following download option .if anyone know this please help me

1832.reportssrs.JPG

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (1)

Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

Why is the report set to be other report and not SSRS report (under report type)?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

I think you have imported some other file extension other than rdl. Make sure the file you are importing in Report is .rdl

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

Like (0)

Report

yes this is rdl file .this crm is on premise so that i created report using sql based ,report runs fine on BIDS(2008) but when i deploying crm showing download option

created in visual studio 2008.please find below screen shot file

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

Like (0)

Report

under report type is existing file not report wizard actually, this is on premise crm 2013 (fetch xml not support this version )

so that created report using ssrrs

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

When we create a report in SSRS it creates two files. One is .rdl and one is rdl.data . I think you have imported rdl.data in your CRM Report

Was this reply helpful? Yes No
Suggested answer

Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

When you import an SSRS report into Dynamics 365, it should show up as SQL Server Reporting Services report, and not Other Report.

In Reports View, click new, select existing and select the RDL file. When you Save the record it should be SSRS.

If it's not I think you are either uploading the wrong file, or something in the report is corrupt.

Please confirm.

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

Like (0)

Report

Hi Mohd Saad Akhtar

yes imported rdl data ..how to get rdl file .please find below screenshot file

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

Please use second file in your screenshot. Type for that file is Report Definition

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

Like (0)

Report

Hi Aric Levin,

when report is run in bids showing encrypted data in a respective column ...please find below screenshot file

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

Like (0)

Report

yes report has been successfully run in crm but showing encrypted data.i want show as name .please help me this

Was this reply helpful? Yes No