Post reply

Dynamics AX 2009 SSRS

  • July 21, 2009 at 2:51 am

    #202696

    I was wondering if anyone has any expereince of using the Dynamics AX 2009 variant of SSRS in either 2005 or 2008?

    Due to the AX database design it is a real struggle to write any raw SQL against the database to get data out effectivly.

    I am trying to write reports and it seems so far removed from the reporting services that I am familiar with that I would appreciate any pointers to hints and tips.

    Many thanks

    John

  • July 21, 2009 at 7:53 am

    #1027617

    Hi Martin

    Currently i'm developing reports for Dynamics AX4.0.

    Sorry but i'm not getting what your coming to say

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

  • July 23, 2009 at 4:04 am

    #1028826

    Correct me if I am wrong but does AX 4.0 use filtered views to pull data back when used with SSRS.

    In AX 2009 you retreive data from the AOT Query objects. As such there is a dramatically reduced ability to write any meaningful SQL against them.

  • July 24, 2009 at 5:05 am

    #1029558

    Hi, you can create reports with the report designer of Ax 2009 or you can use visual studio 2005/2008 to connect with Ax data directly and create your own reports.

    Here you have an example:

    http://axstart.spaces.live.com/Blog/cns!E82F2C8CB173C0A0!380.entry

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply