how to export report data with greater than 32767 characters in excel RSS

• • Reply
  rockonrocks

  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.

• • Reply
  Michelle Ge...

  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

  rockonrocks

  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:

  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

   

  We are trying to better understand customer views on social support experience. Click HERE to participate the survey. Thanks!