locked
Pass the CRM User as a parameter to a Linked SSRS Report from within CRM RRS feed

  • Question

  • Hi,

    Is there a way to retrieve the user that is connected to CRM?

    I have a SSRS Report that is imported in a CRM Solution as a Linked Report (not embedded).

    The report is linked is because the report’s data source is a SSAS cube, not the CRM DB itself.

    In the cube, I need to filter by the user that is connected to CRM which is not necessarily the same user connected to SSRS. The windows user connected to SSRS can be obtained by using User!UserId from SSRS

    Any help is greatly appreciated

    Thank you,

    Waldemar



    Wednesday, December 7, 2016 1:40 PM

Answers

  • As it's a linked report, you could try loading the report in an IFrame or new window (from a ribbon button), using Reporting Services Url access. You could write a bit of client script in CRM to get the current userId, and pass that as a parameter of the report Url


    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Thursday, December 8, 2016 5:49 PM
    Moderator

All replies

  • As it's a linked report, you could try loading the report in an IFrame or new window (from a ribbon button), using Reporting Services Url access. You could write a bit of client script in CRM to get the current userId, and pass that as a parameter of the report Url


    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Thursday, December 8, 2016 5:49 PM
    Moderator
  • Hi David,

    Yes. That makes sense. I don't think there is anything other than that. I will pass this suggestion to the CRM guys since I am more on the BI side. 

    Thank you very much,

    Waldemar

    Thursday, December 8, 2016 10:35 PM