Report not running on more than 25 records

By | October 25, 2012

We created  a SSRS on-premise report using CRMFiltered parameter and the report was working fine except for the case when we ran this report on more than 25 records. In that case the report was crashing. When we used Diagnostic Tool then we found the below error.

The error was that it was concatenating the GUID’s instead of separating each other.

 

We found that the CRM FilteredAccount parameter only returns 25 records, not more than that. Hence, to fix this we used CRMAF_filteredAccount parameter and then the report was working fine.

 

Hope this trick helps!!!