SSRS:  Fixed column length

Posted on 2014-03-12
Medium Priority
Last Modified: 2014-03-15

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?

Question by:TBSupport

Accepted Solution

alqasem2 earned 2000 total points
ID: 39923668
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.

Author Comment

ID: 39924829

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

Or, no?


Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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.

Join & Write a Comment

It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question