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 :
Microsoft Dynamics AX (Archived)

SSRS integration with AX 2012 R2 - fraught with problems?

(0) ShareShare
ReportReport
Posted on by

Hi all

We're finding the integration between SSRS (2012) and AX2120R2 CU7) to be fraught with problems. Some examples of problems we are finding are:

- When using RDP classes and Contract classes, parameters appear in the AX client in the wrong order

- When using RDP classes and Contract classes, parameters showing with missing labels or the wrong labels

- UI Builder classes not being invoked and simply getting ignored

- Parameters that are built from datasets (not contract/UIBuilder) and which are interdependent (e.g.the list of values in parm2 is dependent on your selection in parm1), these work fine...until you reopen the form to rerun the report, and they are all corrupted. Seems like the SysLastValue logic doesn't work.

- Report changes not being honoured, despite refresh/restore/redeploy/restart SSRS/restart AOS/restart server etc.

The SSRS reports using RDP providers run perfectly when run from SSRS, that part of it is great. But AX reprts run from the client seem riddled with issues.

There are five of us developing, running on separate environments all at RU7, and we are all hitting these problems at different times, so we're sure it's not a configuration or installation issue on our systems.

Is anyone else experiencing any of these problems?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Dick Wenning Profile Picture
    8,705 Moderator on at

    I have seen similar things,

    changed labels not recognized, missing field etc.

    most of the time full CIL and restarting the AOS did the job

    also check

    technet.microsoft.com/.../gg731894.aspx

  • Community Member Profile Picture
    on at

    Thanks Dick, yes we've been through all the troubleshooting stages :-( CIL compile and restart take soooooo long, but they have helped occasionally. It does all seem a bit "fragile" though.......

  • Community Member Profile Picture
    on at

    Yes I have experienced similar issues and it makes environment very fragile..

    but only solution for this is to keep Dynamics AX and Visual Studio  Synch properly

    You need to follow procedures to keep the systems in synch with each other.. like

    you need to keep on Running Incremental CIL generation time to time after each modification

    Modify and refresh the RDP class in Report design properly

    This issue may be because number of developed working together...

    may be some time two developers are generating CIL compilation together

    Please consider more team cooperation and communication.

  • Community Member Profile Picture
    on at

    Thanks Nitesh, but we're already keeping the environments in sync and compiling incrementally (or sometimes full). And we're working in separate environments - separate AOS, separate databases, separate servers - totally separate environments.

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 > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans