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) / AX 2009 - Report Libra...
Microsoft Dynamics AX (Archived)

AX 2009 - Report Libraries

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

I am developing a report using report library. I am not very familiar with this and have some concerns:
* From what I understand, if the report just uses the Axapta database as datasource, data is fetched via going through the AOS. My concern is the processing. In the case of an environment where there are multiple AOS but connecting to the same DB, is it possible to force it to use a specific AOS (say, to use an AOS intended for heavy processing)
* There is a static method in a class that builds up the records i need to display in the report. Is there a way to just call that static method and then use the records it returns as my dataset in the report?

*This post is locked for comments

I have the same question (0)
  • Anton Venter Profile Picture
    Anton Venter 20,346 Super User 2025 Season 2 on at

    Hi, yes it possible to process any process or job on a specific AOS. Usually this is achieved by adding the process (job) in the batch queue. It is possible to run specific batch jobs on specific AOS'es using batch groups.

    Can you give us more information about how you are developing the report?

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Query 1:

    As per my understanding In AX 2009 and report developed is using native X++ report then its not possible to execute report using dedicated AOS, environment with multiple AOS, load balancing is maintained internally

    Query 2:

    for this scenario you can created a report using a temporary table

    temporary table will get populated using static method in a class

    Please verify if this helps you

    Let me know if you need more information

  • Community Member Profile Picture
    Community Member on at

    Thanks, Anton.

    Just a report using report library  -- developing via visual studio 2008 and calling an AX query for the dataset.

    So as I understand.. the report can be accessed via :

    (1) Having a menu with AX that calls the report library, which opens a form to call the report deployed in the SSRS server and render it.

    (2) Open a browser, go to the report manager and access the report from there.

     

    On (1), I understand the batch jobs and assigning batch groups to target a specific AOS.. but in the case of running report libraries, I am not sure. I assume that it is processed on the AOS that one is logged on.  

    On (2), as I understand, it connects to AX via the business connector  -- the business connector client config can be set to use a specific AOS.

    Can you confirm my understanding?

    Thanks

  • Community Member Profile Picture
    Community Member on at

    Thanks, Nitesh.

    On (1), please see my reply to Anton as how I understand it.

    On (2), yes, I thought of that. So the direction I was considering was to :

    a. Create a data method that calls the AX static method

    b. The AX method returns a temporary table or table buffer

    c. Process the records and insert it into a data table

    d. Use the data method for the data set.

    I was trying this out, but did not get it to work.

    Do you happen to have a sample code on how this is done?

  • Suggested answer
    Anton Venter Profile Picture
    Anton Venter 20,346 Super User 2025 Season 2 on at

    (1) correct but you can log on to a specific AOS by specifying it in your config. In the case of a load balancer you will need to remove the AOS from the cluster if you really want it only on a specific AOS.

    (2) correct same as in (1) for the Business Connector.

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