SSRS: Error when opening design of duplicated report

When you duplicate an SSRS Dynamics AX 2012 report in Visual Studio, and you try to open the design node you may get an error message like “object instance not set to an object”. The reason is that the data set parameters contain the name of the report e.g. SalesQuotation. Now that you have duplicated the report its name is CopyOfSalesQuotation and the report is broken.

Broken parameter in duplicated SSRS report

Compiling the report project brings up a list of errors.

Errors when compiling a duplicated report

Navigate to each data set parameter and change the name of the report to match the new name e.g. CopyOfSalesQuotation instead fo SalesQuotation

Broken parameter in duplicated report

The fixed parameter should look like this

Dynamics AX 2012 duplicated report data set parameter

Finally the report designer is working

Dynamics AX 2012 duplicated report in report designer

About erpcoder
Azure Cloud Architect and Dynamics 365 enthusiast working in Research & Development for InsideAx

One Response to SSRS: Error when opening design of duplicated report

  1. DAX Developer says:

    There is a workaround:

    1. Create a new report in aot, export the new report AND the existing report you need to copy, then open both XPOs in notepad,

    2. Copy the NAME from your new report xpo and REPLACE ALL the name in existing report xpo with your new name,

    3. Copy the ORIGIN (a long key in curly braces)from your new xpo and replace all it in existing report xpo.

    4. Copy the report business logic reference from your new file to existing(if any), then import the new modified existing xpo in aot,

    This will create a working duplicate of existing report

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: