Search code examples
stored-proceduresreporting-servicesssrs-2008axaptadynamics-ax-2012

Create AX SSRS Report with stored procedure in Dataset


I want to create a SSRS Report for Microsoft Dynamics AX 2012.

I created a DataSource to a SQL Server and now I want to create a dataset with DataSourceType = "Stored Procedure".

The problem is in Visual Studio (2010) I do not have the option to set the DataSourceType to "Stored Procedure" in the properties window and I don't know why.

enter image description here

Click here to see a Screenshot from the Properties Window

Does anybody have any idea?


Solution

  • Make sure the Provider property of the ReportDatasource is set to SQL.