Duplicate SSRS Reports in Dynamics AX 2012

Able to duplicate the report by following the blog entry on the following

http://tech.alirazazaidi.com/dynamics-ax-2012-how-to-duplicate-the-existing-report-for-modification/

Steps to follow to duplicate the Report

 1- Duplicate the classes first via AOT
2- Create a new Visual Studio Project - Reports and add it to AOT as well
3- Duplicate the Report from Visual Studio - Application Tree
4- Modify the report and make any changes to the code after copying.


 Encountered the following issues

- When tried to point the database to the new DP Class, then Visual Studio giving an error.
- This error was resolved by creating a new dataset and then deleting the old one. (Deleting the Dataset is important point ! as without that it will not allow you to proceed)
- However you also need to adjust the output parameters as adding a new dataset will introduce new output parameters which need to be removed. Do remember to refer to the old parameters. This is a tedious task, but need to be done in order to complete the copy.

Screen Shots as follows


Resolution of the error as follows by going on the Report and Modifying the Dataset manually.




Original Post by the User
http://tech.alirazazaidi.com/dynamics-ax-2012-how-to-duplicate-the-existing-report-for-modification/

Dynamics Ax 2012: How to duplicate the existing report for modification

NOVEMBER 14, 2013
in DYNAMICS AX 2012, DYNAMICS AX 2012 REPORTING SSRS REPORTS.
I got task to extend the existing dynamics ax SSRS report. Client also wants to sustain the existing report. They want a new report that will be replicate the original one with extended features. Data provider classes are easily duplicated by right clicking on it and select duplicate, I renamed the duplicate classes in AOT. Initially I did not change anything in renamed classes so duplicate report will work with old data set.
But I did not find any duplicate option on AOT. After R&D I found that report can duplicate in visual studio. I create a new visual studio project Report project. Open Application Explore, Expand SSRS report node and drag it into visual studio project. Visual studio automatically duplicated the existing report
You can open Application explorer in Visual Studio è Viewè Application Explorer.

Application Explorer
Duplicate report by drag and drop
. Now the duplicated report will pointed to old Data provider class. Next step I copied the names of data set fields and parameters and properties into Notepad.  When I point the data set to duplicated classes, a new data set created, and parameters became duplicate. I removed the old parameters and set the new parameters with new names and their properties to as they were in deleted parameter. After this I checked that report layout is working with new data Set, Now I started modification in report and classes with requirements.


Comments

Post a Comment

Popular posts from this blog

Export Data from AX 2012 - using DIXF (Data Migration Framework)

Importing is a well known task using DIXF, but at times we do need to export as well and then import it back in AX 2012. The export task can be done with the help of this information. https://technet.microsoft.com/en-us/library/dn144987.aspx Define the format of your source data Open  Data Import/Export Framework  >  Setup  >  Source data formats . Click  New , enter a name and a description, and then select  AX  from the  Type  list. Define a processing group to export data from Microsoft Dynamics AX Change the company to  CEU . In  Data Import/Export Framework , click  Common  >  Processing group , and then click  New  to create a new processing group. Set the group name to  Export-Cust  and add a description. Click  Entities  to select the entities to include in the processing group. In the  Select entities for processing group  form, click  New , and then, for an entity name, select  Customer . In the  Source data format  fiel
Read more

The virtual path maps to another application, which is not allowed

Image
During the development we came across this issue, which wasted a lot of our precious time. So I decided to share its solution with everyone. We have Project and Sub-Project Structure i.e. we have a root project and several sub-projects. The ROOT Project is entitled as TEMS8 and all other subprojects have been configured as per the image below. (Click on the image for large size) Now after setting up everything on a new Machine, we came across the Error as The virtual path maps to another application, which is not allowed Finally after investigation, we figured out that we have created multiple virtual directories which mainly causes the issue. For instance, we have another virtual directory created for DATADEF which is inside the virtual directory of TEMS8. So this was the main issue. The resolution was to remove the DATADEF Virtual Directory. Everything worked out perfectly, once we removed the inner virtual directory. We should not have something like this image below  W
Read more