SSRS Excel export

5 pts.
Tags:
Microsoft Excel
SQL Server reporting
SQL Server Reporting Services
SSRS
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Exporting from SSRS is not great, and although you are staying in the microsoft range of products, complications do occur. If you have extra resources you could always splash out and buy an add-on for SSRS that performs exports better such as OfficeWriter from www.softartisans.com which provides much more control over Excel output.
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.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Pionerka
    I have a report using SSRS,when export report to Excel file the first column of report gets exported into merged 2 columns.How to solve the problem?
    15 pointsBadges:
    report
  • Brijesh
    Hi,

    Check the resource Export report to Excel hope this guides you with sufficient information.
    8,755 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following