Pivot Report

Finance and Operations/AX Developer Forum
1

Dear All,
Greetings ,Kindly I am working on SSRS Extension tool with AX since two years ago,it is a very good tool with some restrictions like How I can implement deep or complicated report ? the query it is not flexible enough such I build the query statement using wizard in SQL reporting tools , How I can build a pivot report using SSRS Extension ,please send me an example which answer my questions or send me any demonstration document, waiting your feedback with highly appreciated ,many thanks.
Hisham.

2

For more ‘flexible’ reports, you can create ssrs reports using store procedures created within SQL, this removes the limitation of AX queries.

3

Dear Wiliam,

How come call stored procedures from SQL Server to AX? ,I will be grateful if you give me illasterated example ,thank you.

KR,

Hisham.

4

Have a look here;

http://msdn.microsoft.com/en-us/library/ms345415.aspx

5

well, How i can use that in SSRS Extension and AX 2012 ? more details please it is not enough,thanks.

Hisham.