Skip to main content



No record found.

Microsoft Dynamics AX forum

How do I update SSRS Datasource Dynamics AX?

Posted on by 2,695

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?

  • PKCrockett Profile Picture
    PKCrockett 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?


  • Suggested answer
    lispyj Profile Picture
    lispyj 2,695 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
    lispyj 2,695 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?

Helpful resources

Quick Links

Can you answer this forum question?

You could make someone's day!

Community Newsletter - May 2024

Kudos to our community stars!

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!


André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,663 Super User

Martin Dráb Profile Picture

Martin Dráb 224,750 Super User

nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans