Exporting to Excel with SQL Reporting Services


Tech Trek Log – 2010.01.31

Here’s a re-post of an issue I’ve encountered while working on SQL Server Reporting Services when exporting a report into Excel.

The key points in the blog are:

  • Sorting will not be possible when merged cells exist
  • Alignment of header/footer with the data elements resolves the issue

The additional tip I can add when using SQL Business Intelligence (BI) Development Studio is specifying textbox sizes in quarter units so that it will be easier to align elements in the RDL file.

RDL

Source: MSDN Blog – Merge Ahead

Advertisements

One thought on “Exporting to Excel with SQL Reporting Services

  1. Jon L.

    You hit on one of my pet peeves with SSRS, Fred. Whenever I design a report, I usually make several versions, each tweaked for the export types that will be supported. For excel, I think of the report designer as a spreadsheet itself, keeping all of the rows and columns a consistent size (like you said, 0.25 units works great). Otherwise, Excel is going to make some strange assumptions regarding merging things that will end up being a nightmare for your end users. The other option is to only support CSV export, that way you dont have to worry about the formatting. One thing I still havent figured out is how to turn off the “white” background in the Excel export, and go with the normal look and feel that we’re all accustomed to. That said, I do like SSRS, its free, and its definitely easy to work with.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s