locked
No hyperlink in field name after using CRM_URL in SSRS parameter RRS feed

  • Question

  • trying to configure "Drill Down" on my Custom CRM Report.

    I used the CRM_URL in my Parameter, set the visibility to hidden and had data type to text.  The allow blank value  and allow null value are checked.

    The report connection string and dataset work fine.  The first version of the report is already working fine in my online Sandbox org.   CRM 2015 7.1 is the version.   In my place holder properties I have the general tab Markup type to HTML. The value is the first field in the data set [name].

    In my action area , I have GO to URL selected and my string is: 

    =Parameters!CRM_URL.Value &

    "?ID={"&Fields!name.Value.ToString() & "} &LogicalName=name"

    The report runs but I can't drill to the record by clicking the field.   Don't know what I'm missing. 

    Tuesday, October 20, 2015 8:55 PM

Answers

  • Hi Andrii, that worked perfectly. I seen my mistakes now. thank you.

    • Marked as answer by PeteUsta Wednesday, November 11, 2015 8:22 PM
    Wednesday, November 11, 2015 8:22 PM

All replies

  • Hello,

    The first obvious things are:

    1. After LogicalName parameter you have to use schema name of entity like account, contact or opportunity.

    2. After ID you should use dataset field that points to identifier of a record. Something like Fields!contactid.Value.ToString()


    Dynamics CRM MVP
    My blog

    Wednesday, October 21, 2015 6:49 AM
    Moderator
  • Thanks for Responding Andrii.

    There were very different methods using the OTC in 2011.

    So you mean something like this:

     

    Parameters!CRM_URL.Value &

    "?ID={"&Fields!accountid.Value.ToString() & "} &LogicalName=accountid,Account"

    Friday, October 23, 2015 2:33 AM
  • I meant what I meant.

    Your formula is not correct. Correct is following:

    Parameters!CRM_URL.Value & "?ID={"&Fields!accountid.Value.ToString() & "}&LogicalName=account"
    Recheck this article - https://technet.microsoft.com/en-us/library/dn531150.aspx

    Dynamics CRM MVP
    My blog

    • Proposed as answer by Kalim Khan Monday, October 26, 2015 3:33 PM
    Friday, October 23, 2015 11:19 AM
    Moderator
  • Hi Andrii, that worked perfectly. I seen my mistakes now. thank you.

    • Marked as answer by PeteUsta Wednesday, November 11, 2015 8:22 PM
    Wednesday, November 11, 2015 8:22 PM
  • Hi Andrii, that worked perfectly. I seen my mistakes now. thank you.


    So may be it is correct to mark my reply as an answer instead of own? :)

    Dynamics CRM MVP
    My blog

    Thursday, November 12, 2015 5:38 AM
    Moderator