web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Cannot figure out how to identify and edit SSRS reports

(0) ShareShare
ReportReport
Posted on by 135

So I was asked to edit a report in AX, but I'm having trouble identifying which report it even is.  To open the report, I do the following steps:

Procurement and Sourcing > Common > Purchase Orders > All Purchase Orders > Approval status field == confirmed > Select a PO > Purchase tab > Purchase order confirmations > Preview/Print > Original Preview

This opens up the report.  However, I cannot personalize or do anything to figure out what the name of this report is.  I also tried personalizing the form where you click Preview/Print to see if that had any references to the report.  Nope!

I then decided another approach to identifying the report.  I opened up the developer workspace and went to Visual Studio Projects > Dynamics AX Model Projects and decided to try and open all of our customized reports in Visual Studio to see which one looked the same.  However, I cannot preview the designs of any of the reports!  The "preview" button next to the "Add Element" button is always greyed out.

Edit:

Tried to follow this tutorial: https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/walkthrough-customizing-existing-microsoft-dynamics-ax-reports

but when I tried to preview the "LedgerBalanceControlDSTable" I get this error: Unable to preview the report, install the Microsoft SQL Server Data Tools - Business Intelligence for VS2013.

Screw that.  Rather than preview the report in VS, I'll just reopen it in AX to see if my changes were correct.  Anyways, I just need to a way to identify what the report is.  Thank you.

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi, This should be the PurchPurchaseOrder report. Why is it that you need to modify this report? Isn't it an internal report only? Best regards, Ludwig

  • AXGreenHorn Profile Picture
    135 on at

    This may be the one, but how did you find out the name?  How are you supposed to know other than someone more experienced just telling you?  There must be some way to figure it out yourself?

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi AXGreenHorn,

    I am just a functional consultant :-) for that reason, I had a look at the form that you used. The PO form. Then opened the AOT and tried to identify the form. If you are there then there is a menu where you can see the different 'buttons' that you have available and after searching a bit I found the one that prints this confirmation. Then check out all what is available there and you will finally find the menu item and the name of the report that will be run when you press the button. Just check the properties section on the right hand side of the dev environment and you should be able to find this report menu item / name.

    Best regards,

    Ludwig

  • AXGreenHorn Profile Picture
    135 on at

    Thank you.  I see what you mean, I didn't check the properties.  As for why we need to modify this report, that's just what I was asked to do.  They never tell me why, they just tell me to do it...

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…

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

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 669 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

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

#3
Martin Dráb Profile Picture

Martin Dráb 384 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans