Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2008
    Posts
    12

    Unanswered: Reporting services -- Export to Excel

    Hi All,

    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.

    Cheers
    payal

  2. #2
    Join Date
    Mar 2008
    Posts
    4
    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.

  3. #3
    Join Date
    Mar 2008
    Posts
    12
    Does that mean i have to set the column width in the report designer to what is required and then export to Excel?

  4. #4
    Join Date
    Mar 2008
    Posts
    4
    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.

  5. #5
    Join Date
    Mar 2008
    Posts
    12
    Thank You.

  6. #6
    Join Date
    Jul 2009
    Posts
    1

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •