SSRS: Fixed column length

Hello:

I will be creating a SQL Reporting Services report and exporting the data to Excel.

I would like for columns in the report to have a fixed field length.  In other words, if column B should be only 10 characters in length, I'd like to be able to make it so.

Is that possible in SSRS?

TBSupport
LVL 1
TBSupportAsked:
Who is Participating?
 
alqasem2Connect With a Mentor Commented:
Make sure your Text box CanGrow property is set to true, the cell height will increase automatically to accommodate a long text.

The possible cause is merged cells exist on a row where a text box is rendered with the AutoSize property. If cells are merged, word-wrap and auto-height will not work correctly in exporting Excel. Since this is a limitation in Excel rendering, currently, I’m afraid we can only use non-merged cell in the row.
0
 
TBSupportAuthor Commented:
Thanks!

So, am I understanding then that it is possible to do through the Text Box "CanGrow" property?

Or, no?

TBSupport
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.