locked
what are the challenges in generation custom ssrs report against custom db inside mscrm application? RRS feed

  • Question

  •  Hi Team,

    We have MSCRM and AX applications . we want to show some custom ssrs report consist of some AX table data in MSCRM application. 

    •  What are the challenges in getting the AX application Db access for the MSCRM application Support account?
    • Is it possible to upload this custom ssrs report ( fetching data from AX DB) into MSCRM application on a particular entity?
    • Is there any way to expose this AX report url so that from MSCRM, they can view the report from the url shared?

    Regards,

    Hari


    hari ________________________________________________________ If this post answers your question, please click "Mark As Answer" on the post and "Vote as Helpful"

    Wednesday, August 30, 2017 11:10 AM

All replies

  • Hi,

    1) This first answer relates to simply giving the CRM Account rights on the AX database.

    2) Yes, CRM allows you to upload a seperately created SSRS report. 

    3) Yes, CRM can show web pages and by extension SSRS reports via a "iframe"

    regards,

    Don

    Friday, September 1, 2017 4:04 AM