Problem exporting to excel from SQL Reporting Services
-
I have a report that has a quite a few matrixes. Why is it when this report gets exported to excel some of the columns, not all will merge. What is meant by this is let's say I have 10 rows with 10 different columns. When I go to export there may be extra columns that the data is merged into. So if I have columns A - J, when this gets exported, I may have columns A - D that are fine, then E & F are merged, G is fine, H & I are merged, and then J, K, and L are fine. Notice, I now have columns A - L. Is there some property that needs to be changed?
-
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.
The following is the good one.
Hope it will help you.
Stephane Le Tanter -
Stephane -
Can you elaborate a little bit on what you mean by "the left and right limits of the report objects are aligned"?
frank
-
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply