Controlling Table Width, and Width of a Single Column Within
In my SQL Server 2008 R2 report, I have a table where the number of columns is dynamic. The columns are driven by date (a new column for each new day of data). Once the table returns 30 or 31 days of data, the table can become quite wide. The first column in the table contains labels (for each row). The labels can become so wide, that they wrap. What I would like to do is have the first column of labels not wrap as long has the table itself has not excceded a certain width. Once the table gets to that width, it is okay for the labels to wrap, but the table cannot become any wider. Does that make sense? Is this kind of control possible? Thank you for your help. cdun2
September 8th, 2012 5:15pm

Hi there Thanks for your posting. As far as my knowledge is this is not possible, the dynamic width of the column is not supported in Reporting Services. Currently, we can only set fixed value for column width/height. This is a common request and I can see the value in it. However, until SSRS 2008 R2 it is not possible. I hope One day, Reporting Services will probably include an object model which developers like me can manipulate. Please see this thread for more info http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/9e6043f1-c458-4540-be59-d37b02feab8a/ I hope this will help. Please let me know if you have any questions Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
Free Windows Admin Tool Kit Click here and download it now
September 8th, 2012 5:27pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics