Home Forums Reporting Services Reporting Services Blank rows in Excel export RE: Blank rows in Excel export

  • March 8, 2018 at 9:00 am

    #1982449

    Andy Reilly - Thursday, March 8, 2018 8:57 AM

    I've just figured the problem out - if I include blank cells in my table in the main report 

    ------------------------------------------------
    |          |    SUB - REPORT  |            |
    ------------------------------------------------
    I get blank rows - If I take out the blank cells So the table only has one cell and put the blank cells in the sub-report - Happy days - Still no idea why, but it's fixed 

    Cheers
    Andy

    WYSIWYG.   What you see is what you get.   SSRS has been doing that for a rather long time.  If you include a blank cell and don't suppress blank rows, that's what you'll get.   Look into suppressing blank cells or rows.

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