Notifications
Announcements
No record found.
I need to help create a report outside of AX for AX data. I'm wondering where are the base enum value stored at in AX.
*This post is locked for comments
Hi,
in additon to what "glOOmie" said....
If you are using AX 2009 and you will build your reports with SSRS you are in luck.
With Ax 2009 and the Ax reporting extensions you are able to access the most parts of the "AX metadata" directly in your report.
Look at the following table:
SRSAnalysisEnums
They can be filled with the information you're looking for. To fill the table run the methode "populateSRSAnalysisEnums" of the class "BIGenerator".
I have a similar issue. Using Visual Studio 2005 I have created a report from Dynamics Ax 3.0. This report uses the smmQuotationTable which contains a field called "JobYear". This is a an integer field that relates to the Base Enum values. There are currently 15 integers identified in this list- I can open and edit the values and the labels. I would like to my report to show the labels - not the values from here so that my report will automatically reflect any changes made in the system.
I am not a code writer - I build my reports based on the wizards and the generic query designers. In the past I have simply created expressions in the text boxes with variable iif - then statements, but in this case, it will be extremely restrictive and need to be manually updated every time there is a change to the Job Year enum definition.
I sincerely appreciate any help you can give me. Thank you! - Jamie
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 4 Most Valuable Professional
Priya_K 4
MyDynamicsNAV 2
