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

[Former Member]

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

[former_member183750 · Accepted solution]

Hello Michael

I've never experimented with any of this. However, the reg key given for CR 2011 would nto work for "SAP Crystal Reports, developer version for Microsoft Visual Studio". If I were to hazard a guess as to the correct key for that versi of CR, it would be:

HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Crystal Reports\Database

So, more than likely you'd have to create the Database folder and then add the String Value: NumberOfYearToShift. Finally then set the value of NumberOfYearToShift to: 100

Note that this modification will need to be done on all runtime computers.

Re. the note for developers. As I read it, this will only affect the report if the a selection formula exists in the report and it is created as Report->Select Expert->Record.

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Share Your Knowledge in SCN Topic Spaces

[Former Member · Accepted solution]

Hello Ludek,

You guessed correctly. As I found out using Process Monitor, the key on a 64-bit OS is slighty different:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Crystal Reports\Database

Problem solved. Thank you very much.

- Michael

[former_member183750 · Accepted solution]

Darn - so close . Many thanks for posting the solution. It will make a great KBA.

Happy coding,

- Ludek