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

Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04
Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / How do I update SSRS D...
Microsoft Dynamics AX (Archived)

How do I update SSRS Datasource Dynamics AX?

(0) ShareShare
ReportReport
Posted on by lispyj 201

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

I have the same question (0)
  • lispyj Profile Picture
    lispyj 201 on at

    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?

  • Suggested answer
    lispyj Profile Picture
    lispyj 201 on at

    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.

  • PKCrockett Profile Picture
    PKCrockett 60 on at

    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!

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

News and Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04
Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans