Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
How to redirect to contact form from a SSRS report RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I have a requirement where first

    I have to build a report with contact information and in this report there must be a column with Contact Names

    when i click on those particular contact name then i have to open Contact form of that record.

    Please guide me with screenshots or sample code.

    jo

    Tuesday, February 24, 2015 8:54 AM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    Create a parameter in your report with name CRM_URL.

    Give a default value to it as: https://<yourorganization name>/main.aspax?

    Right click on the tablix for which you want to make it link and go to "Action" section -> Select "Go to URL"

    And give expression as Parameters!CRM_URL.Value &"?ID={" & <contact id>.ToString()&"}&OTC=<contact entity type code>" // for contact it is 2.

    Alternatively follow this URL.

    http://fetchxml.blogspot.in/2012/03/how-to-create-drill-through-link-from.html

    This helped me a lot. Hope you too

    Jugal Kishore Dandamudi.

    Tuesday, February 24, 2015 9:25 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    The method that Jugal has suggested is correct - I've done this in the past in reports I've written with SSRS Report Builder and it works great.

    You just need to make sure that you've got the contact record's guid as part of the report. Once you've got this extracted, you can build a hyperlink to take this into account. As it's a Contact record, it should be along the lines of:

    https://orgnisation.domain.com/main.aspx?etn=contact&pagetype=entityrecord&id=%7B" & Fields!theGuid.Value & "%7D"

    where 'Fields!theGuid.Value' is the contactId field from the database.

    Wednesday, February 25, 2015 11:45 AM