Post reply

How to automatically increase the cell size while exporting report in excel from SSRS?

  • September 6, 2018 at 2:13 pm

    #415554

    Below is the screen shot of the report in excel after exporting my SSRS report. The cell in 18 has more text than appearing.

    https://social.msdn.microsoft.com/Forums/getfile/1323522

    I would like it to appear as follows.

    https://social.msdn.microsoft.com/Forums/getfile/1323523

    How could I accomplish this task? I have checked to allow the height to increase or decrease in the text box properties, but it's not helping. The above values are in the matrix (row group).

    Any suggestions would be greatly appreciated. Thank you

  • September 6, 2018 at 2:28 pm

    #2004768

    soldout6000 - Thursday, September 6, 2018 2:13 PM

    Below is the screen shot of the report in excel after export. The cell in 18 has more text than appearing.

    https://social.msdn.microsoft.com/Forums/getfile/1323522

    I would like it to appear as follows.

    https://social.msdn.microsoft.com/Forums/getfile/1323523

    How could I accomplish this task? I have checked to allow the height to increase or decrease in the text box properties, but it's not helping. The above values are in the matrix (row group).

    Any suggestions would be greatly appreciated. Thank you

    The only way I can think to do it is to write a macro in Personal.xlsb to format the spreadsheet and add a button to Excel that will run the macro. Then just run the macro when you open the spreadsheet.

  • September 11, 2018 at 1:48 pm

    #2005324

    soldout6000 - Thursday, September 6, 2018 2:13 PM

    Below is the screen shot of the report in excel after exporting my SSRS report. The cell in 18 has more text than appearing.

    https://social.msdn.microsoft.com/Forums/getfile/1323522

    I would like it to appear as follows.

    https://social.msdn.microsoft.com/Forums/getfile/1323523

    How could I accomplish this task? I have checked to allow the height to increase or decrease in the text box properties, but it's not helping. The above values are in the matrix (row group).

    Any suggestions would be greatly appreciated. Thank you

    You will want to check out how the report appears on the report server.  If you don't see it that way in the report itself, it won't export to Excel that way either.   You may need to ensure that the entire row of your tablix or matrix has the property "Can Grow" set to True.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply