{"id":44,"date":"2012-12-17T05:16:00","date_gmt":"2012-12-16T23:46:00","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=44"},"modified":"2012-12-17T05:16:00","modified_gmt":"2012-12-16T23:46:00","slug":"display-more-than-2000-characters-in-ssrs-report","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2012\/12\/display-more-than-2000-characters-in-ssrs-report\/","title":{"rendered":"Display more than 2000 characters in SSRS report"},"content":{"rendered":"
<\/span><\/p>\n
We would like to share one of our experiences with SSRS reports. One of the reports we were building required displaying of notes that could hold more than 2000 characters. <\/span>
\u00a0<\/span><\/div>\n
<\/p>\n

\u00a0<\/p>\n

Including a text box worked fine for most of the records but we observed that the ones that had more than 2000 characters reported error. To show the entire content of the notes in SSRS reports you can try the following workaround:<\/span><\/span>
\u00a0<\/span><\/div>\n

Add a textbox with the following expression<\/p>\n

<\/span><\/span>
<\/span><\/p>\n

<\/p>\n

\u00a0<\/p>\n

=IIF(Len(Fields!description.Value) >= 2000,Left(Fields!description.Value,2000) ,Left(Fields!description.Value,2000))<\/p>\n

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

\u00a0<\/span>
This will show the first 2000 characters.<\/p>\n

<\/span><\/span><\/p>\n

\u00a0<\/span><\/p>\n

For the next 2000 add a blank row and include a textbox with the following expression<\/p>\n

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

\u00a0<\/span><\/p>\n

=IIF(Len(Fields!description.Value) >= 2000, cstr(Fields!description.Value).Substring(2000), “”)<\/p>\n

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

\u00a0<\/span><\/p>\n

If the content included is less than 2000 characters in the first place itself, then to hide the blank row add the following expression to the visible property<\/p>\n

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

\u00a0<\/span><\/p>\n

=IIF(Len(ReportItems!txtDescription.Value) >= 2000,false,true)<\/p>\n

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

\u00a0<\/span><\/p>\n

Note<\/u><\/b> ReportItems!txtDescription refers to the same textbox that we are hiding<\/p>\n

<\/span><\/span><\/div>\n

\u00a0<\/span><\/p>\n

This way we were able to increase the display limit to 4000 characters to increase it further add another text by using the same logic as above.<\/p>\n

<\/span><\/span><\/div>\n

<\/span><\/p>\n

\n

\u00a0<\/span><\/p>\n<\/div>\n

Hope this helps!<\/p>\n

<\/span><\/span><\/div>\n

<\/span><\/p>\n

\n

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

We would like to share one of our experiences with SSRS reports. One of the reports we were building required displaying of notes that could hold more than 2000 characters. \u00a0 \u00a0 Including a text box worked fine for most of the records but we observed that the ones that had more than 2000 characters\u2026 Read More: Display more than 2000 characters in SSRS report »<\/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":[20,21,22,24,58],"tags":[270,1709],"class_list":["post-44","post","type-post","status-publish","format-standard","hentry","category-dynamics-crm-2011","category-dynamics-crm-2013","category-dynamics-crm-2015","category-dynamics-crm-2016","category-ssrs-reports","tag-characters-more-than-2000","tag-textbox-in-report"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\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