Why do reports lose format when exporting to excel?

Question

1.00/5 (1 vote)

See more:

, +

I am building a large batch of reports that will be exported to excel on a frequent basis and printed on letterheads. Long story short, every time the report has the data placed to print correctly straight from SSRS(2012) it is not aligned on Excel and the same the other way around.

Does anyone know how to fix this?

Thanks

Posted 17-Oct-13 6:31am

Paulo Augusto Kunzel

Add a Solution

Comments

Kenneth Haugland 17-Oct-13 12:36pm

I actually dont get this, are you printing excel files from SSRS?

Paulo Augusto Kunzel 17-Oct-13 12:42pm

No, the user is exporting SSRS reports to excel and printing from there. Having them printing only straight from SSRS is out of question, unfortunately, so I am trying to see the best way to tackle this situation.

Kenneth Haugland 17-Oct-13 12:48pm

I dont know what SSRS are exept some database component, but I do know excel, so is the export to excel done with a build in function that you didnt build yourself?

Paulo Augusto Kunzel 17-Oct-13 12:57pm

SSRS -> SQL server reporting services
After creating a report it provides the possibility to print or export in various formats, one being xlsx. When doing so, for some reason it doesn't keep the distances which were set beforehand, ever. Probably it has to do with SSRS, but I am not sure

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 3931158 · Accepted Answer · 2013-11-09T05:54:00

Solution 1

Hi Paulo,

What format is not getting maintained? Is it that the data does not look good because of the cell size?

I am not sure what is the exact issue, but a suggestion would be - set the row height in Tablix to 12.75pt and set "CanGrow" to "False"

This should make your excel output look better. Only catch here is as "CanGrow" is set to false so you won't see the entire cell content unless you expand the cell in Excel.

If I did not understand your problem, then could you describe more about the formatting issue you are seeing.

Thanks,
Anil

Posted 9-Nov-13 5:54am

Member 3931158

Comments

Paulo Augusto Kunzel 10-Nov-13 6:08am

Hello Anilsharma0902,

That is one of the issues, the other one being the fact that, if I align a field at 1cm from the top and 6cm from the left, when I export it doesn't stay there. I've removed the margins and everything, but the issue continues...

Member 3931158 10-Nov-13 9:33am

By "align the field" you mean set the padding. When you say "removed the margins", what you mean? If you have padding set on the field, it should stay. Provide RDL or screenshot or a mock output you are getting and trying to achieve.