SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

tooba
Posting Yak Master

136 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).

Question:-

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,

visakh16
Very Important crosS Applying yaK Herder

India
52249 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
http://visakhm.blogspot.com/

Go to Top of Page

tooba
Posting Yak Master

136 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

sunitabeck
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: http://excelsemipro.com/2011/06/regional-date-formats-in-excel/

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  
 New 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.05 seconds. Powered By: Snitz Forums 2000