ssrs导出到excel换文本问题
问题描述：
大家好
在ssrs报告（sql server）中，当我尝试在excel中导出报告时，列的包装文本选项已启用。我想禁用它。请建议..
Hi All
In ssrs reports (sql server) when I try to export the report in excel, the columns have wrap text option as enabled. I want to disable it. Please suggest..
答
默认情况下，如果文本不适合，文本框将在换行模型中显示文本。但是，当将CanGrow属性设置为False时，文本框将仅显示第一行文本
By default, if text does not fit, the textbox will display text in wrap model. However, when set the CanGrow property to False, the textbox will only display the first line of text
set CanGrow = false
合并两个或多个列以显示结果集时发生IT，删除所有合并列并拆分然后设置CanGrow属性： - True。它会起作用。
IT happens when you merge Two or more column to show resultset , Remove all your merge Column and split it , then set CanGrow properties:- True. it will work .