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

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