Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 594
  • Last Modified:

Setting Excel column Format in SSRS

I have a stored procedure that runs and generates report which is consumed in ssrs,

But when the reports gets exported in excel, the date column gets changed and the number columns gets into a format that I do not want,

How can set the column format of the date column to yyyy-mm-dd hh:mm:SS.sss when the report is exported into excel from SSRS.
Is there a way to do this

Thanks.
0
marvo2010
Asked:
marvo2010
1 Solution
 
HumpdyCommented:
0
 
marvo2010Author Commented:
I have been on this for ages and having to run this report manually. I hope that this works out and that the date format persist when the report is exported to excel.

Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now