Dynamics Community Forum Thread Details

SSRS Report External data source Excel File

Hi,

How do you create a custom SSRS report that retrieves data from an Excel file?

Reproducable steps:

It is possible to create a custom report in Dynamics AX 2012 R3 CU10. (https://technet.microsoft.com/en-us/library/ee873263.aspx)
In the report server it is possible to create a new ODBC data source name that connects to an Excel file. (msdn.microsoft.com/.../ff519546.aspx Topics)
In Visual Studio, within your Dynamics AX report model solution, the project that contains the new report, you can define on the dataset of the new report that it uses the newly created Report Data Source. (https://technet.microsoft.com/en-us/library/cc585332.aspx

Problem

The connection string property must be set for the newly created Report Datasource (in your Visual Studio Project). Wat are the recommended values to connect to the new SSRS Datasource?

Test

- Create a new SSRS Report in your Visual Studio Project which is part of a Dynamics AX Report Model Solution.

- Add a dataset to the report

- Select the newly created Report Datasource name in the proprty "Data source".

The errors I get are because the Report Datasource Provider is only supports SQL and OLAP... Does this mean that I always have to move/copy external data to a SQL Server Database in order to be able to access the data?

So the question is: How do you define a dataset in your custom report, so that the dataset connects to a (shared) Report Server External Datasource?

Quick Links