SSRS experts:How to turn off wrap text when exporting to Excel from SSRS 2008 R2

• Chinna

  SSCertifiable

  Points: 5408

  More actions

  December 17, 2012 at 10:45 pm

  #267626

  I have a matrix report where i have hidden the columns based on below condition:

  =IIF(Globals!RenderFormat.Name="EXCEL",False,True)

  and i have made the width of the column to zero so that the empty space doesnt show up..

  The issue now is when i am exporting to excel as the column value has large text so now the excel has tall columns how should i turn off the wrap text ..? Or how to remove the empty space in report when hidden so that i need not turn off the wrap text .

  Note:I have tried setting the above exxpression for static column but didnt work out.

  Thanks,
  Chinna

  Its the Journey which gives you Happiness not the Destination-- Dan Millman

• -Syd-

  Mr or Mrs. 500

  Points: 543

  More actions

  January 25, 2013 at 12:58 pm

  #1581199

  I have a similar problem.

  I have simple report and all the cells after exporting the report to excel appear wrapped in excel.

  I want to know how can I turn off the wrap property from the report so in excel appear not wrapped.

  I already try with CanGrow true/false.

  Regards.