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

All replies

• 

  

  0

  Sign in to vote

  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)
  Мой блог (русскоязычный)

  • Proposed as answer by Andrii ButenkoMVP, Moderator Friday, October 8, 2010 11:27 AM
  • Marked as answer by Leonard_Str Sunday, October 10, 2010 12:46 PM

  Friday, October 8, 2010 11:26 AM

  Moderator
• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  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
• 

  

  0

  Sign in to vote

  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