sql server - CRM Auto Pre-filter doesn't pass a query -

sql server - CRM Auto Pre-filter doesn't pass a query -

i've created simple ssrs study using visual studio 2012,

i'm using crmaf_ prefix utilize crm's auto filtering, , accomplish context-based report.

i'm using 2 datasets accomplish this; dsfiltered filtered data, , dsapprovalsummary report.

this query dsfiltered uses :

declare @sql nvarchar(max) set @sql = 'select vrp_investdocumentid (' + @crm_filteredvrp_investdocument + ') crmaf_vrp_investdocument' exec(@sql)

this query dsapprovalsummary uses :

select doc.vrp_name 'yatırım dosyası', act.vrp_actioncode 'aksiyon kodu', cfg.vrp_description 'aksiyon açıklaması', act.owneridname 'aksiyon sorumlusu', act.modifiedon 'son değiştirme tarihi' vrp_action deed inner bring together vrp_investdocument doc on act.regardingobjectid=doc.vrp_investdocumentid inner bring together vrp_actionconfig cfg on act.vrp_actioncode = cfg.vrp_actioncode cfg.vrp_reporttask=1 , act.regardingobjectid = @documentid order act.modifiedon

the parameters :

@crm_filteredvrp_investdocument - parameter crm should have been populated query, defaults null

@crm_vrp_investdocumentid - comes dsfiltered (crmaf_vrp_investdocument.vrp_investdocumentid); allows null.

the study works on development server. however, when deploy study production server, it not inquire me select filter, or not have default filter; tries run directly , gives rsprocessingaborted. i've checked logs, , saw said syntax error near )-.

this study server logs :

processing!reportserver_0-20!13ec!11/11/2014-13:45:04:: w warn: info source 'srcapprovalsummary': study processing has been aborted. processing!reportserver_0-20!13ec!11/11/2014-13:45:04:: e error: throwing microsoft.reportingservices.reportprocessing.processingabortedexception: , microsoft.reportingservices.reportprocessing.processingabortedexception: error has occurred during study processing. ---> microsoft.reportingservices.reportprocessing.reportprocessingexception: query execution failed dataset 'dsfiltered'. ---> system.data.sqlclient.sqlexception: wrong syntax near ')'

update : on development server, have installed on same machine; crm frontend, services, sql server, study server etc. on production environment, each 1 of these servers different machines. source of error?

update 2 : running profiler gave me @crm_filteredvrp_investdocument comes in null. see query below profiler :

exec sp_executesql n'declare @sql nvarchar(max) set @sql = ''select vrp_investdocumentid ('' + @crm_filteredvrp_investdocument + '') crmaf_vrp_investdocument'' exec(@sql)',n'@crm_filteredvrp_investdocument nvarchar(4000)',@crm_filteredvrp_investdocument=null

it turns out collation problem, i've been trying utilize custom info source connection string :

data source=myprodsqlserver; initial catalog=myorganization_mscrm;

i've rewritten lowercase, , replaced info source localhost problem magically gone.

data source=localhost; initial catalog=myorganization_mscrm;

sql-server reporting-services dynamics-crm-2013