{"id":48,"date":"2012-10-25T11:51:00","date_gmt":"2012-10-25T06:21:00","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=48"},"modified":"2026-10-12T15:08:31","modified_gmt":"2026-10-12T09:38:31","slug":"report-not-running-on-more-than-25-records","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2012\/10\/report-not-running-on-more-than-25-records\/","title":{"rendered":"Report not running on more than 25 records"},"content":{"rendered":"
\n

 <\/p>\n

\n

We created\u00a0 a SSRS on-premise report using CRMFiltered<\/b> 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.<\/p>\n

 <\/p>\n<\/div>\n

 <\/p>\n

<\/a><\/div>\n

 <\/p>\n

\n

The error was that it was concatenating the GUID\u2019s instead of separating each other.<\/p>\n

 <\/p>\n<\/div>\n

 <\/p>\n

\n

 <\/p>\n

 <\/p>\n

 <\/p>\n<\/div>\n

 <\/p>\n

\n

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

 <\/p>\n<\/div>\n

 <\/p>\n

\n

 <\/p>\n

 <\/p>\n

 <\/p>\n<\/div>\n

 <\/p>\n

\n

Hope this trick helps!!!<\/p>\n

 <\/p>\n<\/div>\n

 <\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

  We created\u00a0 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\u2026 Read More: Report not running on more than 25 records »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,58],"tags":[72,422,1238,1750],"class_list":["post-48","post","type-post","status-publish","format-standard","hentry","category-dynamics-crm","category-ssrs-reports","tag-25-records","tag-crmaf_filteredaccount","tag-multiple-records","tag-unclosed-quotation-mark"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t