Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

How do I update SSRS Datasource Dynamics AX?

(0) ShareShare
ReportReport
Posted on by 110

I am using Dynamics AX 2009 SP1 with SSRS 2008 and Visual Studio 2008.  I have added a query to the Dynamics AOT, and am now trying to add a dataset referencing the query to an SSRS Report Library using Visual Studio.  I can't see my new query, and I can't see changes to existing queries either.  How do I update the predefined Dynamics AX Datasource in SSRS?

*This post is locked for comments

  • PKCrockett Profile Picture
    60 on at
    RE: How do I update SSRS Datasource Dynamics AX?

    I have the same problem.  They removed my Dynamics AX project with the report query from the Test environment.  When I go to edit the AX SSRS report from the Dynamics AX Development environment, Visual Studio says it cannot find the query for the dataset.  The Dynamics AX active configuration is pointing to Test, but is grayed out.  How do I change it to point to Dev?

    Thanks!

  • Suggested answer
    lispyj Profile Picture
    110 on at
    Re: How do I update SSRS Datasource Dynamics AX?

    The active configuration for the AX Client must point to the AOS you want Visual Studio to reference.  I was using a client configuration file to open my client session, so had disregarded the active client configuration.  Even though the Business Connector configuration pointed to the correct server, it was necessary to change the active configuration as well.

  • lispyj Profile Picture
    110 on at
    Re: How do I update SSRS Datasource Dynamics AX?

    I now have a better idea what is going on, but I still don't have an answer.  The datasource Dynamics AX that is used by the New Dynamics Project template in Visual Studio is pointing to the wrong instance of Reporting Services. I am testing a new instance of both SQL Reporting Services and SQL Databse engine.  

    How can I edit the template so that the correct server and datasource are used?

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics AX (Archived)

#1
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 100 Super User 2025 Season 1

#2
Community Member Profile Picture

Community Member 46

#3
shanawaz davood basha Profile Picture

shanawaz davood basha 6

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans