I am working on a RDLC report and i am facing a problem, when i am viewing the report data in reportviewer, i am able to see all the data but when i am exporting the report in EXCEL format the columns giving error having data grater than 32767 characters.
Can somebody tell me the solution for that?
Also there is a way of the above problem in SSRS (RDL report) where i can check for the export format like:
giving error having data grater than 32767 characters
Hi,
According to the error message, the maximum number of characters in a cell is limited to 32,767. If this is exceeded, the renderer displays an error message.
For more information, please refer to the link below:
None
0 Points
23 Posts
how to export report data with greater than 32767 characters in excel
Jan 22, 2014 01:08 AM|rockonrocks|LINK
Hi All,
I am working on a RDLC report and i am facing a problem, when i am viewing the report data in reportviewer, i am able to see all the data but when i am exporting the report in EXCEL format the columns giving error having data grater than 32767 characters. Can somebody tell me the solution for that?
Also there is a way of the above problem in SSRS (RDL report) where i can check for the export format like:
Globals!RenderFormat.Name = "EXCEL",LEFT(Fields!Message.Value,32767),Fields!Message.Value
But this is not working in the RDLC report.
All-Star
18232 Points
2199 Posts
Re: how to export report data with greater than 32767 characters in excel
Jan 23, 2014 12:37 AM|Michelle Ge - MSFT|LINK
Hi,
According to the error message, the maximum number of characters in a cell is limited to 32,767. If this is exceeded, the renderer displays an error message.
For more information, please refer to the link below:
http://msdn.microsoft.com/en-us/library/dd255234.aspx
As you using RenderFormat, it did not work, I think we should check the parameters, please see the link below:
http://blogs.msdn.com/b/robertbruckner/archive/2010/05/02/globals-renderformat-aka-renderer-dependent-report-layout.aspx
Hope it's useful for you.
Best Regards,
Michelle Ge