Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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