Post reply

SSRS Formatting Issue - Textbox height increases in Excel Export of a Matrix

  • May 21, 2014 at 8:29 am

    #291645

    Hi All,

    I have been struggling for some time around this Issue and couldn't find any solution and so here I am. Kindly have a look at the screenshot and suggest some solution to it. Whenever I export my report to Excel (pdf is fine) the tablix seems to go weird and the textboxes changes their height to give a very bad shape to the Chart.

    I am using 4 tablix.

    3 on the left are contained in 1 rectangle. The 4th is contained inside a 2nd rectangle.

    if I don't use any rectangle at all, then the height issue doesn't appear, instead the alignment of the tablix changes. To fix the alignment I have to use rectangles.

    Any help on this would be really appreciated. Thanks a lot in advance for your time.

    Regards,

    Athar Iqbal

  • May 21, 2014 at 8:34 am

    #1715387

    You're feeling the pain of many of us who have done the same thing. Basically, SSRS does not export to Excel very well. There are some things you can do:

    1. Set texboxes/tablix rows to CanGrow=False and CanShrink=False, then set an explicit line length.

    2. Pay close attention to the alignment of your tablixes. If they don't line up exactly, you may see extraneous, hidden (or tiny) columns in Excel.

    3. Communicate with your users that the Excel output may not look as nice as doing it by hand. The upside is, of course, they don't have to do it by hand!

  • May 28, 2014 at 1:44 am

    #1716913

    Hi Thanks for your help...

    My bad that I didn't mentioned earlier, I have played around with Cangrow and CanShrink properties, they WEREN'T useful for me.

    the alignments to check are a very good point. More often than not I have had this Issue, but this time I have made the alignment perfect upto exact decimal places for location and sizes of controls in designer.

    As of now, Users are OK with this(excel alignment not perfect)....I believe though that with some arrangement of rectangle the required behavior can be achieved. For now I have moved to something else, but will work on this a later point in time and possible post a detailed solution, assuming I get one.

    Thanks again for your time.

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

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