SAP Knowledge Base Article - Public

1362039 - Universe Date prompt shows as Date Time in Crystal Reports

Symptom

  • Date Time prompt.
  • Prompts for Date Time when expecting a Date prompt.
  • When refreshing a report based off a Universe in Crystal Reports, it prompts for a Date Time, despite it is defined as a date in the Universe.

Environment

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

Reproducing the Issue

  1. In the Universe Designer, create a Universe off any data source with a dimension of data type: Date.
  2. Export the Universe to the BusinessObjects Enterprise Repository.
  3. In Crystal Reports, create a report off the Universe created, and in the filter, add a prompt on the Date dimension.
  4. When refreshing the report, it prompts to enter a Date Time, despite it is defined has a Date in the Universe.

Cause

  • This is situation was tracked under ADAPT00735266, and confirmed by the product developer to be normal behavior.

Resolution

  • To display a date prompt in Crystal Reports, add the database name or DSN name in the registry key: useDateInsteadOfDateTime:
    1. If you are using Crystal Reports XI R2, dowload and install Service Pack 6 or above.
        
    2. Open the Microsoft Registry Editor, by typing: regedit      
      ( Note: It is recommended to backup the registry before making any modification. )
                  
    3. In the Microsoft Registry Editor, go to the following path corresponding to the version of Crystal Reports used:
             
      • For Crystal Reports XI 2:
        • HKLM/Software/Business Objects/Suite 11.5/Crystal Reports/Database/         
               
      • For Crystal Reports 2008:
        • HKLM/Software/Business Objects/Suite 12.0/Crystal Reports/Database/
                   
      • For Crystal Reports 2011:
        • HKLM/Software/SAP Business Objects/Suite XI 4.0/Crystal Reports/Database/
        •         
      • For Crystal Reports 2013:
        • HKLM/Software/SAP Business Objects/Suite XI 4.0/Crystal Reports/Database/   
              
      • For Crystal Reports 2016:
                    HKLM/Software/SAP Business Objects/Suite XI 4.0/Crystal Reports/Database/      

      • Notes:  If you are using a 64bit version of Microsoft Windows, the path for the registry will be like
                    HKCU/Software/Wow6432Node/...
          
    4. Add a new string value: useDateInsteadOfDateTime
      ( Note: if the registry key already exist, go to next step )
          •   
    5. Add to the registry key: useDateInsteadOfDateTime, the information for the database the Universe point to:
      • For Native Connection to a database, add the database name the Universe points to; or
      • For a Universe connecting to a database via an ODBC Connection, add the ODBC DSN name.

Note: If the Universe object is actually a prompt defined in the Universe, ensure the Date Prompt is formatted in the date format: MM/DD/YYYY

Keywords

Date prompt , Universe date prompt, Teradata, Connectivity, "Failed to retrieve data from database", "Invalid operation for DateTime or Interval", filter , 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 2011, feature pack 03 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports XI R2