Export to Excel Column width
-
Hi there, I`m a n00b with reporting services. I am trying to export to Excel a report based on a table. This works fine, except that I would like Excel to autofit the column widths. At the moment, it is wordwrapping so that the row height is expanding to fit the data and it looks terrible.
How do I set this property for the cells within the table in report designer? This is could be the issue that kills my pilot project??
I`m running SQL 2k SP4 with RSeval + SP2
Thanks for your help
James
-
Unfortunately you can't set it to auto-fit. Best you can do is to layout the columns in the report to accomodate the data as best you can.
Also, if you haven't discovered it yet, be careful when adding/merging columns and headings. If they don't line up exactly you'll end up with a mix of merged and hidden columns in Excel.
--------------------
Colt 45 - the original point and click interface
-
Hi Phill
7 minutes! That`s one awesome response time.
That`s a shame. Is there no way of using an expression to define the cloumn width? then I could use max(len(string)) to determine the width..
Thanks for the hint about the lineup of columns / heading. I`ve been playing with RS for all of 3 days now and any hints gratefully received.
Cheers
James
-
James,
I ran into this several times and never was happy with the possibilities DTS offers by default. The only way I could work around this was to use Excel (or Office Web Components if you do not install Office applications on your servers) automation - which is not too complicated and allows you full control, e.g. special formatting, use of templates, etc.
If you fill the Excel sheet in advance by using a data pump and reformat the file afterwards with a script or if you do both tasks within the script may depend on performance and coding style.
Bye,
Rainer
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply