Skip to Content
0
Former Member
Jun 04, 2013 at 12:46 PM

IBM DB2 date fields appear with a default null value of 01/01/2001 in Crystal Reports

24 Views

Hi,

In SAP Note 1217785 - IBM DB2 date fields appear with a default null value of 01/01/2001 in Crystal Reports - the resolution is to add a registry value NumberOfYearToShift to a key that depends on the Crystal Reports version. For Crystal Reports 2011, the key is HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\Database.

This resolution does not appear to work in the current Crystal Reports .NET Runtime (CRRuntime_32bit_13_0_5.msi). The SAP note also mentions an SDK issue that I'm not sure I understand but that I believe to mean that as a developer you have to work around the problem yourself.

Does anyone know if my interpretation is correct, or if the same fix as described in the SAP note might be available for Crystal Reports for Visual Studio and the CR .NET Runtime?

Thanks,

Michael