How to convert T-SQL query to AOT query?

Hi I have a problem. I am creating a report for AX and I have a great query in T-Sql running fine. How can I convert it in to AOT format?



I think you have to re create it manually for AOT.

Another option is, if you can convert it to an SSRS report and add this report to Ax.

hi ,

you can achieve this by copy the data of the sql to ax table then you can develop the report in ax .