Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Upgrading GP2013 R2 to GP2016 R2 and SSRS with custom reports

Posted on by 18,265

Hello Friends,

I am upgrading GP2013 R2 to GP2016 R2; client has tons of custom reports in SSRS which is in company folder and few are in outside.

What if I redeploy reports is going to delete all custom reports?  what is best way to redeploy SSRS reports.

Your earliest reply is highly appreciable.

Thanks much

Sandip

*This post is locked for comments

  • RE: Upgrading GP2013 R2 to GP2016 R2 and SSRS with custom reports

    Hello Sandip,

    While you'll definitely want to have backups (.rdl files) of your custom SSRS reports, when you re-deploy the SSRS reports from within Dynamics GP, it normally will not overwrite your custom reports unless they are named the same thing as one of our default SSRS reports, which obviously we don't recommend doing.

    You'll most likely need the backups of the custom SSRS reports if you upgrade to a newer version of SQL Reporting Services and/or move to a new server for SQL.

    If you haven't already done so, this may also be a good question to put on the Microsoft SQL Server - Reporting Services forums, as your questions isn't actually something we would support on the Dynamics GP side, though we luckily have experts such as Mariano and others on these forums that may have additional information to contribute.

    Thank you,

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    RE: Upgrading GP2013 R2 to GP2016 R2 and SSRS with custom reports

    Hello Mariano,

    Customer has 75+ reports with subscription - schedule to send email other colleagues. It will be difficult to export all those reports and import it back. 

    Do you have any other solution?

    Thanks much

    Sandip

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Upgrading GP2013 R2 to GP2016 R2 and SSRS with custom reports

    Glad I was able to help! If my replied answer your question, please mark it accordingly.

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    RE: Upgrading GP2013 R2 to GP2016 R2 and SSRS with custom reports

    Hello Mariano ,

    Much appreciate for your reply.

    Thanks

    Sandip

  • Suggested answer
    Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Upgrading GP2013 R2 to GP2016 R2 and SSRS with custom reports

    You will need to download all custom reports as rdl files. Once you are done doing the upgrade, you can reimport the RDL files by using Report Builder and saving them back to SSRS. 

    rdl.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans