Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Expand width automatically?

Author  Topic 

chriskhan2000
Aged Yak Warrior

544 Posts

Posted - 2005-05-09 : 11:55:33
Is it possible to expand the width to fit the text automatically? I know there's one for the height, but what about width? I have some fields that i want to hide and unhide base on criteria. The problem is that I have to define the page width, and if when I try to print, if the page is to wide I'm getting blank pages.

Any ideas?

jhermiz

3564 Posts

Posted - 2005-05-09 : 20:42:39
Have you tried landscape reports ? Switch the width and height of the report from 8.5in x 11in to 11in x 8.5

works a treat for me...uses less paper too!




Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
Imperfection living for perfection --
[url]http://jhermiz.blogspot.com/[/url]
Go to Top of Page

chriskhan2000
Aged Yak Warrior

544 Posts

Posted - 2005-05-10 : 10:43:00
Jon,

Thanks for the suggestion. However, the column has gone past 14inchx8.5inch. But there are some columns that at time might be empty. I want it to automatically adjust the width to accomandate that, but I guess using the hide functionality also works.

=IIF(Fields!Description.Value Is Nothing, True, False)

That seems to do the trick.
Go to Top of Page
   

- Advertisement -