报表查看器控制并在导出到Excel时保持格式化 [英] Report Viewer Control and Keeping my formating while exporting to Excel

问题描述

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.

 

谢谢

 

推荐答案

为什么报表上的日期字段设置为常规？

Why are the date fields on the report set to General?

右键单击该字段在报告上选择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时保持格式化的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！