Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 SSRS Help
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Posting Yak Master

224 Posts

Posted - 09/27/2012 :  17:53:49  Show Profile  Reply with Quote
Hi guys,

I need help. I have question,

I create SSRS Report and that report i am saving in excel format and upload to our website. Here is the problem, when i save my SSRS report in excel my date file change i.e (in SSRS DATE Format is 08/19/2012 after i save this report in Excel Date format change to 8/19/2012).


1) Is it possible in SSRS i can chage Datatypes? I know i can we change through expressions, If i want to save in Excel format i can change datatypes?

2) I can use Excel Template and save my report to that Template?

Thank You,

Very Important crosS Applying yaK Herder

52326 Posts

Posted - 09/27/2012 :  22:53:54  Show Profile  Reply with Quote
1, You can use casting functions in SSRS like CSTR(),CDate() etc to cast to relevant data types
2, Nope you cant. Each report will render itself to new excel sheet

SQL Server MVP

Go to Top of Page

Posting Yak Master

224 Posts

Posted - 09/27/2012 :  23:15:59  Show Profile  Reply with Quote
Thanks for reply Visakh, I tried to change datatypes and its looks good in Reports but same problem when i save in Excel. Any other advise?
Go to Top of Page

Flowing Fount of Yak Knowledge

5155 Posts

Posted - 09/28/2012 :  06:56:57  Show Profile  Reply with Quote
What you see in Excel is really a function of the regional settings of the computer on which you open the Excel sheet and of the default date format that Excel uses. There is a pretty good discussion of it here:

You can force the formatting to be something by changing the regional settings on the computer. But when someone else opens it, they will see it in their default format. You can also force it to be something specific on a given spreadsheet.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000