tirsdag den 13. september 2011

Dynamics AX 2012 SSRS report - "Report has no design."

I just helped a colleague fix a little problem in Dynamics AX 2012.

He was going through a tutorial to make a (SSRS) report in Dynamics AX 2012.
He had designed the report complete with a dataset getting SalesTable data from AX, and had deployed it to the Report Server.
He had also made a menu item for the report and put that in the menu in AX.

However when he clicked the menu item AX failed to run the report giving the error
"Report has no design."

We poked around using a breakpoint in the Info class, to find that the AX class failing was ReportRun.
The method in ReportRun we ended up in expected to receive a designname.
However as nearly all AX reports are gone and replaced with SSRS reports in Dynamics AX 2012, this lead me to believe that something was up with the menuitem.

We examined the output menu item to find that the ObjectType property was set to "Report" which is a remnant of the old AX reporting system.
We corrected this property to SSRSReport, and voila.
Ax now ran the report with no problems.