Customer experience | Sales, Customer Insights,...

RDL report

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello.
I'm a Dynamics 365 application manager. I have several reports that were created by a consultant with visual studio an due to budget reduction I need to change some columns and insert new data . I installed visual studio 2015 and I can now export my .rdl file to visual studio. I could easily change some easy parameters (like for example some percentages) but regarding for example the addition of new columns I would like to know if there are easier applications to use . Is it possible to convert my .rdl file to fetch(xml) and then use XRM toolbox?

Thanks for help

Patricia

All responses (4)

Answers (0)

Suggested answer

JayBuddhdevtest 275 on at

Like (0)

Report
RE: RDL report

Hi Patricia,

In Visual Studio 2015, if you press Ctrl + Alt + D, then you will see a Report Data tab on the right side of the window. There you will see five options, which includes:

Built-in Fields: To see number of Built-in Fields that are already supported in the report.

Parameters: If you have any custom parameters it will be shown here. If you want to add one, you can do right click and add new.

Images: if you have added any custom image in the report, you can see it here. You can add more as well.

Data Sources: This will show you the Data sources present in the report. Data source holds information such as Connection details.

Data Sets: This will show you the information about entity and fields that are present in the report. So basically this shows the FetchXML code. You can create additional dataset or can edit the existing data set depending upon your need.

I hope this helps. Please let me know if you have any questions/concerns. I am always happy to help.

Thanks

Jay
cloflyMao 25,202 on at

Like (0)

Report

RE: RDL report

Hi Patricia,

You can extract fetch(xml) from RDL file by following way.

This is part code of my sample .rdl file, the fetchxml is encoded in CommandText node.

You can use html decode online tools to decode the query, like this:

Regards,

Clofly
Community Member Microsoft Employee on at

Like (0)

Report

RE: RDL report

Thanks Ana for your reply. Yes too complicated. Is ms report builder an option?
Suggested answer

Ana Almeida on at

Like (0)

Report

RE: RDL report

Hello Patricia,

It is possible to convert a report to XML in the Visual studio, but the report code is super complex to be worked in XML.

The XML will have:

- Code for the design of the report (Tables, fields, labels)
- Code for operations within the report (sums, concatenation, etc.)
- Code to retrieve data
- Code of parameters and filters

I tested with a simple report and got 17105 lines.

For that reason, I don't believe this is a good option.