What's the best way to build a SSRS report if the query is very complex

(0) Share

Report

Posted on by Community Member

I'm building a Procure to Pay Status report. The query will be very complex. more than 5 table joins. I have written the SQL statement and run it in SQL management studio which works fine. Now I need to put it in AX. I'm not quite sure I can build this query in AOT. I also don't want to build this SSRS report outside of DynamicsAX folder.

So what is the best way to implement it? Can anybody give me some ideas. Does create a table is the only option?

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Amir Nazim 5,994 on at

Like (0)

Report

You can choose to pick RDP approach of developing the ssrs

technet.microsoft.com/.../gg731917.aspx

Was this reply helpful? Yes No