Today I tried to migrate a custom CRM 4.0 SQL report to the a CRM 2013 SQL report. In the report designer I hit the preview button and received the following error: TITLE: Microsoft SQL Server Report Designer ------------------------------ An error occurred while executing the query. An insufficient number of arguments were supplied for the procedure or function dbo.fn_GetLocalizedLabel. OK, this means the SQL function "fn_GetLocalizedLabel" in CRM 4.0 used to have one parameter less than in CRM 2011 or CRM 2013. After comparing the paramter signatures with the SQL database version I found this definition: function [ dbo ].[ fn_GetLocalizedLabel ] ( @ ObjectId uniqueidentifier , @ ColumnName nvarchar ( 255 ), @ LabelTypeCode int , @ LanguageCode int ) returns nvarchar ( 255 ) as begin declare @ LocalizedLabel nvarchar ( 255 ) begin select @ LocalizedLabel = l . Label from LocalizedLabelView l
Bringing code to life is a developer's daily task to fulfill.