SSRS

Posted on Dynamics AX

AX/D365 SSRS Report: “: Error 1 : Format is invalid. “

Problem: When modifying a SSRS report I received the following error at compile time. “Error 1 : Format is invalid. InvalidIdentifier \SSRS Reports\Reports\[ReportName]”

Solution: It turns out if you copy and paste expressions with functions in them, Visual studio will create an expanded version of them with the full function namespace e.g.
=Format(Fields!MyDateTimeField.Value, “dd/MM/yyyy hh:mm:ss tt”)
becomes
=Microsoft.VisualBasic.Strings.Format(Fields!MyDateTimeField.Value, “dd/MM/yyyy hh:mm:ss tt”)

Simply removing this additional namespace seems to resolve the issue.

Hope my pain helps someone!

Posted on Dynamics AX

Report not working “This report doesn’t exist just yet”

When testing a new report I encountered the following error: “We’re working on it. This report doesn’t exist just yet”

I could not locate any google help for this stupid error, so here’s the issue:

My menu item was linked to the correct controller class in its “Object” properties but the Object type I had forgotten to change to “Class” from the default SSRSReport.