Problem exporting to excel from SQL Reporting Services

Question

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

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

Stephane Le Tanter Old Hand Points: 304 More actions · Answer 1

I had the same problem with some of my reports.

I finally found the answer on the microsoft newsgroups.

In fact excel is considering the report as a single big table.

What you have to do is to make sure that all the left and right limits of the report objects are aligned.

The following is not good. the Column 2 will be exported as merge of 2 columns in excel.

Not Good

The following is the good one.

Good

Hope it will help you.

Stephane Le Tanter

fkearney SSC Enthusiast Points: 111 More actions · Answer 2

Stephane -

Can you elaborate a little bit on what you mean by "the left and right limits of the report objects are aligned"?

frank

Stephane Le Tanter Old Hand Points: 304 More actions · Answer 3

Frank

Sorry if I was not clear.

I have reupload the screenshots from my previous post.

You should be able to see them.

By left and right limits I mean the left and right borders of the objects (textbox, table column or table).

If you look at the screenshot of my other post.

On the bad one, you can see that the right border of the textbox is not aligned with the right border of the first column.

If you export this into excel, the first column will be exported as 1 "excel" column but the 2nd one will be exported as a merge of 2 "excel" column.

Hope this will help you better.

Stephane Le Tanter