Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Database used is different in Visual Studio 2010 vs AX 2012 R2 for SSRS

Posted on by 40

Problem:

I want to edit the Journal Voucher report in TESTVisual studio 2010 is can pull the SSRS report from TEST; but pulls data from LIVE; even though using only one TEST configuration file.

 

Assumptions:

(1) I have two environments: LIVE (production; 1@APPS) and TEST (development; 2@APPS).

(2) I also have two configurations: LIVE.axc (production) and TEST.axc (development)

 

[LIVE AXC file]

LIVE-AXC-file.JPG

[TEST AXC file]

TEST-AXC-file.JPG

[LIVE server configuration]

LIVE-server-configuration.JPG

 

[TEST server configuration]

TEST-server-configuration.JPG

 

[AX2012 TEST Report Server]

AX2012-TEST-Report-Server.JPG

[VS2010 TEST shortcut target]

VS2010-TEST-shortcut-path.JPG

 

[AX2012 Journal Voucher report in TEST]

AX2012-Journal-Voucher-report-in-TEST.JPG

 

Here, JB-00001808 is a JV for 2014.

 

 

[VS2010 with the TEST]

 

VS2010-with-the-TEST.JPG

 

Using (a) the TEST configuration file and (b) TEST report server configuration in AX client, JB-00001808 is an APV.

 

 

This JB-00001808 is the APV for 2015 which is from LIVE!

APV-for-2015.JPG

 

 

I haven't done anything yet; the SSRS report is from TEST (which is correct with the PNAME column) but the data is from LIVE (which it shouldn't be). LIVE doesn't have the PNAME column.

I already tried (1) refreshing the AX Configuration Utility to TEST and (2) sync'ed the TEST; but still no luck.

 

What am I missing?

Problem: Visual studio 2010 is using the SSRS report from TEST; but it pulls data from LIVE; even though using only one TEST configuration file.

 

Assumptions:

(1) I have two environments: LIVE (production; 1@APPS) and TEST (development; 2@APPS).

(2) I also have two configurations: LIVE.axc (production) and TEST.axc (development)

*This post is locked for comments

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at
    RE: Database used is different in Visual Studio 2010 vs AX 2012 R2 for SSRS

    Hi Kashiro,

    You will have to review the configuration. How to install multiple instances of SSRS is described on the next page: docs.microsoft.com/.../install-multiple-instances-of-reporting-services-on-the-same-computer-for-use-with-microsoft-dynamics-ax

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans