CODEWITHSUNDEEP
sqlreporting-services
Aziz Altamimi
Aziz Altamimi

Reputation: 17

Export to Excel Limitation

How to export SSRS report data with greater than 32767 characters in excel. I tried to use this solution but I don't know exactly where I want to put it. anybody has some insight: 

Globals!RenderFormat.Name = "EXCEL",LEFT(Fields!Message.Value,32767),Fields!Message.Value

Upvotes: 0

Views: 252

Answers (1)

Sahil Dhoked
Sahil Dhoked

Reputation: 372

Try this piece of code I found somewhere on the net.

=IIf(Globals!RenderFormat.Name= "EXCELOPENXML" OR Globals!RenderFormat.Name = "EXCEL",Left(Fields!Parameters.Value,32767),Fields!Parameters.Value)

It worked for me.

Apparently Reporting Services use Office OPEN XML format.

https://msdn.microsoft.com/en-us/library/dd255234.aspx

Upvotes: 2

Related Questions