问题描述
Hi Folks
我使用报告查看器来显示网格视图。我有5列。 2是日期,一次是货币,另外两种是一般的。
I am using report viewer to display a grid view. I have 5 columns. 2 are dates and once is currency and the other two are general.
当我导出excel格式为我的单元格如果我双击它设置为日期的每个单元格,日期将设置为常规。我希望它们是日期格式,当我从报表查看器导出时,对于货币字段同样。
When I export to excel the format on the cells for my dates are set to general if I double click each cell it sets to date. I want them to be date format when I export from report viewer at the start same for the currency field.
我该怎么办?我已经尝试了我能想到的一切。
How can I do this I have tried everything I can think of.
谢谢
推荐答案
右键单击该字段在报告上选择Properites。得到Numbers并将格式设置为日期类型。我认为这将解决您的问题。
Right click on the field on the report and select Properites. Got to Numbers and set the formatting to a date type. I think this will fix your problem.
Bernie
这篇关于报表查看器控制并在导出到Excel时保持格式化的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!