Support our 100% FREE Projects: Donate Now OR Sponsor Now

  
›

SSRS export to excel formatting

In this SSRS tutorial I will show you how to preserve formatting from SSRS report when you export to Excel. For the purpose of this tutorial I used SSRS 2008 R2.

When you try to export your SSRS report to Excel you might lose formatting. This may happen when you format your data for instance using  expressions. To retain formatting when you export to excel go to cell property and change the formatting there.

This simple change allows Excel to understand what formatting you would like to get after the export and hopefully that will fix your formatting issue.

Hope that helps!
Emil
Share: Share on FacebookShare on Google PlusTweet it
Comments Add Comment
Name: Hemanth
Comment:

can u give the example for ssrs export to excel
Date Posted: 18/09/2012 5:19:58 AM

Name: Kumar
Comment:

Hi Emil,

Where we set the format property ?Will you elaborate it ?
Date Posted: 05/03/2013 10:16:07 AM

Share your thoughts, questions and suggest improvements:
Add Comment

You found us! Below are 50 most popular searched keywords

created at TagCrowd.com

Disclaimer: While every caution has been taken to provide our readers with most accurate information and honest analysis, please use your discretion before taking any decisions based on the information in this blog. Author will not compensate you in any way whatsoever if you ever happen to suffer a loss/inconvenience/damage because of/while making use of information in this blog.