Q:
SSRS Excel export
Hello
I have a slight problem when end users are trying to export reports into Excel. When they export the report, one or two columns in the report appear to merge together once exported into Excel, thereby making it difficult for my end users to perform spreadsheet data manipulations.
I have a slight problem when end users are trying to export reports into Excel. When they export the report, one or two columns in the report appear to merge together once exported into Excel, thereby making it difficult for my end users to perform spreadsheet data manipulations.
ASKED:
Jul 25 2008 8:33 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
From my experience its basically headers (either column or page) and footers which cause the issue If any of these headers / footers overlap with data columns in your report, you can find that the exprted version of the report has merged cells.
Also checks columns next to each other (simple I know) to make sure there is no overlap in the rpeort designer in BIDS.
-----------------------------------------------------------------------------
I was having this problem with a 3-line header that was centered. It merged columns on either side of where the header text began and ended.
I was able to get around this by creating a textbox with the page header text that spans the full width of the page AND then giving it a background color. I know it sounds silly, but this a way to explicitly tell it to create a header that was the full width. My previous background color was transparent, and I changed it to White, and it worked.
Browse IT Answers by Topic
