locked
Drill through in reports: Object Type Name insted of OTC (Object Type Code)??? RRS feed

  • Question

  • Hi,

    I have a report with Dynamic Drill Through, see http://technet.microsoft.com/en-us/library/aa681484.aspx.

    I use a jump URL, similar as this one:

    =IIF(IsNothing(Parameters!CRM_URL.Value),Nothing,
    Parameters!CRM_URL.Value & "?ID={"&Fields!Opportunityid.Value.ToString()&"}&OTC=3")

     

    Now the problem, I want to use my reports on another CRM organization, but this organisation has different Object Type Codes! They do have the same entity-names, is it possible to say something like .......&OCTname=entityname?

     

    Friday, October 8, 2010 10:50 AM

Answers

  • Hi, Leonard.

    Try to use following:

    =IIF(IsNothing(Parameters!CRM_URL.Value),Nothing,
    Parameters!CRM_URL.Value & "?ID={"&Fields!Opportunityid.Value.ToString()&"}&LogicalName=opportunity")


    Microsoft CRM Freelancer

    My blog (english)
    Мой блог (русскоязычный)
    Friday, October 8, 2010 11:26 AM
    Moderator
  • Ensure your entity logical name. Is it new_cabins or  new_cabin?

    =Parameters!CRM_URL.Value & "?ID="& Fields!new_truckid.Value.ToString & "&LogicalName=new_truck"

    Refer here

    • Marked as answer by Leonard_Str Sunday, October 10, 2010 12:46 PM
    Friday, October 8, 2010 3:44 PM

All replies

  • Hi, Leonard.

    Try to use following:

    =IIF(IsNothing(Parameters!CRM_URL.Value),Nothing,
    Parameters!CRM_URL.Value & "?ID={"&Fields!Opportunityid.Value.ToString()&"}&LogicalName=opportunity")


    Microsoft CRM Freelancer

    My blog (english)
    Мой блог (русскоязычный)
    Friday, October 8, 2010 11:26 AM
    Moderator
  • You can try this:

    For example if the entity is Opportunity:

    =IIf(IsNothing(Fields!opportunityid.Value), Nothing, String.Format(System.Globalization.CultureInfo.InvariantCulture, "{0}?ID={1}&LogicalName={2}", Parameters!CRM_URL.Value, Fields!opportunityid.Value, "opportunity"))

    Friday, October 8, 2010 11:27 AM
  • Hmm, I get an "No entity" error with this one:

    =IIF(IsNothing(Parameters!CRM_URL.Value),

    Nothing, Parameters!CRM_URL.Value & "?ID={"&Fields!Cabinid.Value.ToString()&"}&LogicalName=new_cabins")

     

    Friday, October 8, 2010 3:33 PM
  • Ensure your entity logical name. Is it new_cabins or  new_cabin?

    =Parameters!CRM_URL.Value & "?ID="& Fields!new_truckid.Value.ToString & "&LogicalName=new_truck"

    Refer here

    • Marked as answer by Leonard_Str Sunday, October 10, 2010 12:46 PM
    Friday, October 8, 2010 3:44 PM