Change Crystal Report PrintDate Field to SqlServer

Question

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?

Answer 1

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