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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / SSRS subscription error
Microsoft Dynamics AX (Archived)

SSRS subscription error

(0) ShareShare
ReportReport
Posted on by Anton Tjiptadi 2,013

Hi all,

Ever set AX report for Subscription. I tried to subscribe on of AX report (let say CustListReport), but when it run, there is status error :

An error occurred while executing OnInit: The Microsoft Dynamics AX Reporting Data Extension does not support SQL Server Reporting Services Subscriptions.

Anybody know what is that all about ? I'm googling but cannot found any useful resources.

Thanks in advance,

Axl

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Sohaib Cheema Profile Picture
    Sohaib Cheema 49,438 User Group Leader on at

    Dynamics AX-SSRS is different than SSRS

    in dynamics ax , reports are dependents upon X++ Classes, which are used as DataProvider and UI Builder at runtime. These fact make Subscriptions and many other functionalities unviable AX flavored SSRS

    As an alternative you can setup report as batch job inside dynamics AX and that can possibly fulfill your need either by saving it as pdf or for sending it as email or a direct print,  

  • Anton Tjiptadi Profile Picture
    Anton Tjiptadi 2,013 on at

    Hi Sohaib,

    Thanks for reply. So this means, if I have SSRS report but purely only get data from AX but not using its X++ classes. It can be done, right?

    Thanks again,

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,438 User Group Leader on at

    I don't think so,  Reporting Services for AX would not allow you to do so, unless you are really on a non-ax ssrs

    why you cannot consider to subscribe ax reports as batch jobs within ax?

  • Suggested answer
    venkatesh vadlamani Profile Picture
    venkatesh vadlamani 3,180 on at

    There are few extensions added to pull data to SSRS report from AX. "AXQUERY"

    "AXDATAMETHOD"

    "AXREPORTDATAPROVIDER"

    "AXADOMD"

    "AXENUMDATAPROVIDER" . If any of these are used then SSRS subscriptions are not supported. The End result you look for in subscription is periodic execution and mailing requirements. This can be achieved with ax report itself using batch tab as all reports are by default batch enabled as they are designed on SysOperationFramework.

  • Anton Tjiptadi Profile Picture
    Anton Tjiptadi 2,013 on at

    Hi Sohaib,

    Because really it is only use AX data. What I intend is to create SSAS report which even the cube itself created outside AX.

    Theoretically, it will connect to different DB (SSAS DB) which the data source it self simply pull the raw data of AX. We can say my SSRS report don't even know AX existed (but the truth is the error keep saying " Microsoft Dynamics AX Reporting Data Extension not supported" though......)

    Thanks,

  • Anton Tjiptadi Profile Picture
    Anton Tjiptadi 2,013 on at

    Hi Venkatesh,

    For those you are listed, I think I didn't use it. The report connect to SSAS DB in which the Cube is not the built-in Cube from AX.

    Thanks,

  • venkatesh vadlamani Profile Picture
    venkatesh vadlamani 3,180 on at

    Did you make any Data sources based on Ax  or none at all.

    If so ideally it should work. Can you retry the scenario using BIDS project template rather than using Dynamics Ax template?

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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