Notifications
Announcements
No record found.
I have created an AX Query, but at some moment I realize that one of the fields of my report required some business logic conditions.
Now I want to utilize my query in RDP Class so that I would get data from the query as well as get my conditional field in my RDP Class.
My required logic is as under:
Thanks
Hi HammadAhmed12,
Are you asking how to use query in the report DP class?
If yes, you can mention the query in the Dp class using query attribute.
For example, refer to "HcmWorkerResumeDp" class for accessing AOT query.
Thanks,
Girish S.
I want to utilize my logic after that query
How would i use it.
Are you asking how to design a query with the screenshot you pasted?
Can you elaborate more?
As i have send the Logic in the start. the problem is now i want to utilize that logic in my Report, so how would i use that condition in this report
I am not able to understand the query in the screenshot - If possible, can you explain us the functionality that is required?
Based on that we can give you a suggestion.
basically, I have got a requirement of building an SSRS report. Firstly I designed the SQL Query and test my logic in that query to confirm how would i build my report. Then I start building that query in AX and designed it too but in my SQL query one field is computed based on an if-else condition so what should I do now?
I am asking what is the functionality of the computed column.
If you understand the functionality of the computed column, you will be able to convert that into X++ code in your report dp class.
So first try to understand what the computed column will return and how the query is built.
Girish S
I have defined the functionality in my above query the query is already built in my asked question. Now i just want to know how would convert my logic to X++
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 664 Most Valuable Professional
André Arnaud de Cal... 522 Super User 2025 Season 2
Sohaib Cheema 303 User Group Leader
