Post reply

Opening SSRS report in Excel

  • October 19, 2015 at 5:39 am

    #399207

    Hello

    I've noticed than when opening an SSRS report in Excel, its columns increase. Eg where in SSRS it would have 4 columns, once it gets opened in Excel, we now have two columns where there was just one in SSRS.

    Does anyone know a way of stopping this happening? I have one or two teams who like to move the data into Excel for further analysis, and the multiple-column issue is a pain for them.

    Thanks

  • October 19, 2015 at 6:53 am

    #1834049

    I'd added a company logo to the report: its position was affecting the way columns exported. Problem fixed.

  • November 4, 2015 at 3:46 am

    #1837575

    It's caused by textboxes and images. Try to align the image/textbox with the table cells and graphs.

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

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