Recently I performed an upgrade from AX 2012 FP to AX 2012 R3. After that, beside normal X++ code merging, I had to resolve conflicts in SSRS reports as well which is very complicated just because there is no official tool available from Microsoft to merge different layer changes for SSRS reports.

The steps I have tried to merge var layer changes in one of the SSRS reports is described below. The report is Vendor accrued purchases report.

  • Below is the SSRS report precision design before resolving any conflicts. The highlighted area below are the var layer changes. As I modified this report, so I know where the exact changes are. If you are not the original developer of the report, it would be very hard to figure out where the var layer changes are on the report design from the compare tool.

Image1

Also note down any additional data source, added on the report and its query. In my case, I have added one data source, so I noted down the name of the datasource and its query.

  • Now, copy the highlighted area shown above in a new report project so that we can copy this part from there later on. Create a new Dynamics AX report model project in Visual Studio and add a precision design to it as shown below:

Image2.jpg

Right click the Designs node under report model project, click Add -> Precision Design to add precision design to the report. Double click the precision design node to open the designer. Now copy the var layer changes shown in the first step on this precision design. Below is the screen shot of the var layer changes copied on the new report design:

Image3

  • After copying the var layer design changes to the new report project, we will now delete the var layer changes from the SSRS report in AX client. Once we delete the var layer changes, only sys layer changes will left which is part of AX 2012 R3 code. Close the reporting project in Visual Studio which contain the design changes for both var and sys layer. Right click on VendAccruedPurchases_NA report under SSRS reports node in AX and select Delete to delete var layer changes.

Note: Before deleting var layer changes, make sure that you export the changes in XPO file in case if you want to refer to it later on.

  • After the changes have been deleted, open the report in Visual Studio. Open the precision design by double clicking on the precision design name under Designs node. You will see that the var layer design changes are no longer there as shown below:

Image4

Now copy the var layer changes from the new report model project that you created earlier and paste it inside the body section at the same location where it was before. Extend the body section and drag the Tablix control to the bottom to make room for var layer design changes. Copy the var layer design changes from the new report project as shown below:Image5

Paste the var layer design changes into the empty body area inside the existing report design as shown below:

Image6

After the design is pasted

Image7

The highlighted portion above is the var layer design changes which I copied from the new report model project.

  • Now add the Dataset which was part of the var layer changes under report Datasets node. Give it the same name and specify the query for the dataset which you noted down in Step 1.

Above steps works for simple var layer design changes, but if var layer changes are quite complex and not easy to identify, then it would be better to run the compare tool on the report design and note down some of the major differences between var and sys layer changes. Then copy those design changes to the new report project and paste it to the existing report design afterwards on top of sys layer changes.

I hope this tip will help in merging SSRS reports with simple design changes.