Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tooba
Posting Yak Master
224 Posts |
 Posted - 2012-09-27 : 17:53:49
|
| 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
52326 Posts |
Posted - 2012-09-27 : 22:53:54
|
| 1, You can use casting functions in SSRS like CSTR(),CDate() etc to cast to relevant data types2, Nope you cant. Each report will render itself to new excel sheet------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
tooba
Posting Yak Master
224 Posts |
Posted - 2012-09-27 : 23:15:59
|
| 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? |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-09-28 : 06:56:57
|
| 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. |
|
|
|
|
|
|
SSRS Help