Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / SSRS report how to ope...
Finance | Project Operations, Human Resources, ...
Answered

SSRS report how to open the original report in Visual studio

(0) ShareShare
ReportReport
Posted on by Ganriver1 1,547

Hi Friends,

We have customized tax 1099 report, if you edit it, it opens our report in VS. Now we need to make change due to IRS new 1099 form. Microsoft sent out hotfix. 

The question is how can I see the updated original report? and find the difference in VS. 

I can see SSRS report difference in AOT by comparing CUS/SYP layer, but that's not helping to modifying report. Someone suggest to compare XPO, I looked it, there are tremendous changes, worst part is you can't tell which is supposed to move to customized one. 

First time doing this. any help is greatly appreciated!

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: SSRS report how to open the original report in Visual studio

    Hi River,

    Yes. That might be a good approach, especially if there are a lot of copy designs left behind. You can evaluate the latest report (from MS update) based on user input and can make the changes as needed.

  • Ganriver1 Profile Picture
    Ganriver1 1,547 on at
    RE: SSRS report how to open the original report in Visual studio

    Hi Gunjan,

    Thanks a lot for your help, and that's what I did.  In the beginning, I was wondering why people before me modify the 1099 report, now I realized that it's just some space adjustment, plus, when they made change, left a few copy of design forms in report, bad practice by the way, when I comparing XPO, it has tremendous change, and it confused me.

    I guess my best option is just remove the old report in CUS by using one in SYP, let user test, then adjust space if needed.

  • Verified answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: SSRS report how to open the original report in Visual studio

    Hi River,

    You can take a backup of the customized report (into an xpo) and delete the SSRS report logging into CUS layer in your Dev system. This way you can delete all the customizations and will have only the updated report design (from the MS hotfix). You can open the VS project from AOT and view the report design.

    If you want to compare both the reports, it might be  easier to open up the report in two different Dev environments (using VS) and compare the changes done. On one of the Dev environments, you can remove the customizations, as I mentioned before. The other Dev environment should have the customized report.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,329 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans