1204856 - Date time prompt instead of a date prompt, when reporting off a Universe in Crystal Reports

SAP Knowledge Base Article - Public

1204856 - Date time prompt instead of a date prompt, when reporting off a Universe in Crystal Reports

Symptom

  • Date Time prompt displays instead of a date prompt.
  • When creating a report off a Universe in Crystal Reports, and adding a prompt on a date, it prompts for a date time. 

Environment

  • Crystal Reports XI R2
  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Reproducing the Issue

  1. In Crystal Reports, create a new report off a Universe.
  2. In the Query Panel window, add a filter on a date, and set it to prompt the user for the date.
  3. When refreshing the report, instead of prompting for a date, it prompts to enter a date time.

Cause

  • This is a known issue that has been tracked under ADAPT00735266

Resolution

  • To be prompted for a date parameter in Crystal Reports, when connecting to a universe, add the Universe connection database server name or ODBC DSN name to the registry key: useDateInsteadOfDateTime:
           
    1. For Crystal Reports XI R2, apply Fix Pack 2.1 or Service Pack 3 or higher.
      For Crystal Reports 2008 and higher, no product update is necessary.
         
    2. Verify the type of connection the universe you are connecting to is using:
      1. Open the universe in the Designer by clicking File > Import.
      2. In the Import Universe window, select the universe you were connecting to in Crystal Reports.
      3. Once the universe is successfully imported, click File > Parameters.
      4. In the Universe Parameters window, click the Definition tab then click the Edit button.
      5. In the Universe Connection window, click the Next button.
      6. In the Perform a test window, look in the upper right corner. If you are connecting via ODBC to your data source, it will display Data source name: and the DSN name will be written on the right side. If you are using a native connection it will display Alias: and the name of the server.
      7. Note the DSN name or the database server name.
              
    3. Close Crystal Reports.
          
    4. Add the database server name, or the ODBC DSN name to the registry key: useDateInsteadOfDateTime
        
      • Notes:
      • For Crystal Reports XI R2:
           
        • For 32 bit version of MS Windows: 
          HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 11.5\Crystal Reports\Database\useDateInsteadOfDateTime
                
        • For 64 bit version of MS Windows:
          HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432NodeSuite 11.5\Crystal Reports\Database\useDateInsteadOfDateTime
                     
      • For Crystal Reports 2008:
           
        • For 32 bit version of MS Windows:
          HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\Crystal Reports\Database\useDateInsteadOfDateTime
               
        • For 64 bit version of MS Windows:
          HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Business Objects\Suite 12.0\Crystal Reports\Database\useDateInsteadOfDateTime
               
      • For Crystal Reports 2011, 2013, 2016:
          
        • For 32 bit version of MS Windows:
          HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\Database\useDateInsteadOfDateTime
                
        • For 64 bit version of MS Windows:
          HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\Database\useDateInsteadOfDateTime
                 
               
    5. When creating a new report off a Universe in Crystal Reports, and adding a date prompt, it will now prompt for a date. Old report behavior will not change, it will still prompt for Date Time. It is required to remove the date prompt, and re-add it for changing the behavior of existing report.
             
  • Note: Adding the ODBC DSN name or database server name to the useDateInsteadOfDateTime registry key allows for overriding the default type for universe prompt date objects. You will now be prompted for a date parameter instead of the default date time parameter.

Keywords

DateTime, Date, Universe prompt, Crystal Reports , 7885162 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Bug Filed

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports XI R2