将Crystal Report的PrintDate字段更改为SqlServer日期 [英] Change Crystal Report PrintDate Field to SqlServer Date

问题描述

我有服务器和客户端。我想在Crystal报表打印字段中显示服务器日期，而不是客户端的本地日期。

解决方案

您必须将服务器日期从SQL Server返回到Crystal

 选择Col1，
 Col2，
 ... 
 GetDate '
 
从dbo.MyTable 
  

替换在数据库字段列表中的 {ServerDateTime} 的Crystal报表中

$

I have Server, and a Client. I want to display Server Date in Crystal report Print field instead of local date of Client. How can I do that?

解决方案

You would have to return the server date from the SQL Server to your Crystal Report and replace the PrintDate field with your new field.

e.g

SQL

Select Col1,
Col2,
...
GetDate() as 'ServerDateTime'

From dbo.MyTable

Replace {PrintDate} in the Crystal Report with {ServerDateTime} from the list of Database Fields

这篇关于将Crystal Report的PrintDate字段更改为SqlServer日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！