var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Reporting services -- Export to Excel
I would like to know whether i can export a report to excel from reporting services, with all the column width set to the max width of the text in it(AutoFit Column width), so that the excel report doesn't look cramped.
Thanks in Advance.
You can play with the widths of the report until it looks right. It may take a minute, but it can be done. Generally I don't like how the autofit looks.
Does that mean i have to set the column width in the report designer to what is required and then export to Excel?
Correct, in the repot designer change it to the required length, then export to excel to check out how it looks. It may take you a few tries, but it can be done.
how we know what can be the max size of the data
how we know what can be the max size of the data in a column because the size of the data can change in every export