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
Comments
Post a Comment