HOWTO duplicate SSRS reports and/or Visual Studio Projects for Customizations Ax 2012

(0) Share

Report

Posted on by CBNestor

Hello All,

I want to customize the SSRS Cost estimates and costings (SSRSRepots\ProdCalcTrans , Visual Studio Projects\ProdCalcTransReport)

Since I dont want to mess the original ( probably will happen :D) I just want to duplicate the whole thing so i can modify even the Query without messing anything on the original.

you guys probably made it many times but I havent find the way.

thanks a lot for your time

I have the same question (0)

All responses (14)

Answers (2)

Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

You need to duplicate two items: The ProdCalcTrans report and ProdCalcTrans query. You can duplicate them by right clicking in AOT and selecting Duplicate.

Was this reply helpful? Yes No
CBNestor 46 on at

Like (0)

Report

Hi Nikolaos , thanks for fast reply,

I am not able to find that option by right clicking on the report at the AOT

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

Ah, you are right. The report has to be duplicated in Visual Studio.

Was this reply helpful? Yes No
Verified answer

Blue Wang on at

Like (0)

Report

HI Nestor C.,

The XPO tool was mentioned in this blog, but 2012 year is a bit old. . Maybe some expert owns it.

https://dynamicsaxgyan.wordpress.com/2012/05/23/duplicate-existing-ssrs-report-dynamics-ax-2012/
In addition, there is an experience blog here, but not Query.

http://axvuongbao.blogspot.com/2013/08/how-to-duplicate-ssrs-report-in-ax2012.html

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.

Was this reply helpful? Yes No
Suggested answer

CBNestor 46 on at

Like (0)

Report

I have followed the steps from thig blog http://www.en.seequality.net/microsoft-dynamics-ax-2012-duplicate-report/

It work well for what I needed. Just that when assigning the query and parameter has to be done all manually (selecting the fields and data methods).

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

As link mentioned, you need to set dataset report parameters to new parameters in properties by manually .

Was this reply helpful? Yes No
CBNestor 46 on at

Like (0)

Report

Update: Fixed, clcik on Tablix -> properties -> datasource and Select desired

Hi Blue,

Thanks for replay. I have also made a copy of the report design for customization and I have added a new datasource ( which slightly different query from the original datasource) and I dont find where to link the new datasource to this new copy of the report design, it is still stuck to the original datasource (ProdCalcTransDS)

Was this reply helpful? Yes No
Verified answer

Blue Wang on at

Like (0)

Report

HI Nestor C,

I see that your new data set parameters have been displayed in the list, so do you specify the data set for your table or tablix?

Right click on it and open the properties dialog, modify your data set to point to DS_sales, and then use the expression again.

Was this reply helpful? Yes No
Suggested answer

Jay Barot 1,502 on at

Like (0)

Report

Hi Nestor,

Please open your report design and check tablix properties. You will find property called "DataSetName". You can select any dataset which you have added/created in your SSRS report.

Was this reply helpful? Yes No
CBNestor 46 on at

Like (0)

Report

Yes got it , thank you :).

just one thing - last I promise (: - , Is it possible to attach the datasource outside of the tablix. I want to have the Customer Name from the sales Table (field already in the datasource) of course this is related to the specific production. I know is outside from the group. what would be the logic for that?, I know this is a little away form the scoup of this thread just let me know if I should create a new thread.

Was this reply helpful? Yes No