excelreporting-servicesreportingservices-2005excel-2003

SSRS 2005 - Border issue exporting to Microsoft Excel 2003


I'm working on a SSRS report which is to be exported in PDF as well as Excel 2003 formats.

In the report, I have a rectangle having several tables & text boxes with border style of all but rectangle marked as "None".

When I preview the report & export as PDF, the borders appear only around the rectangle & all the other elements within are borderless, but when I export it as Excel format, borders are mysteriously appearing around various text boxes out of nowhere.

Why is this happening at all?

Snapshot of PDF:

Snapshot of PDF

Snapshot of Excel:

Snapshot of Excel


Solution

  • I finally managed a workaround for the same.

    I got rid of rectangle control & brought all the controls outside rectangle. Then I manipulated the borders again on all the elements & it worked as desired.

    Please share, if you find a better potential solution.