web
You’re offline. This is a read only version of the page.
close
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,559

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!

I have the same question (0)
  • Verified answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,423 on at

    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.

  • Ganriver1 Profile Picture
    Ganriver1 1,559 on at

    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.

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,423 on at

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 611 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans