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

• 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.

• SAP Crystal Reports 2013
• SAP Crystal Reports 2016
• SAP Crystal Reports 2020

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.

• Crystal Reports does not connect directly to Universe (.UNV), and receives the information from Webi, to then connect to the database directly from Crystal Reports.
• Crystal Reports does not receive the exact type from Webi, and therefore it is prompting as Date Time, instead of a Date.

• To display a date prompt in Crystal Reports, add the database name or DSN name in the registry key: useDateInsteadOfDateTime:
    
  WARNING The following resolution involves editing the Microsoft Registry. Using the MS Registry Editor incorrectly can cause serious problems. Use the MS Registry Editor at your own risk. For more information see the SAP Knowledge Base Article 1323322
      

1. 1. Open the Microsoft Registry Editor, by typing: regedit      
      ( Note: It is recommended to backup the registry before making any modification. )
                  
   2. In the Microsoft Registry Editor, go to the following path:
      
          HKLM/Software/SAP Business Objects/Suite XI 4.0/Crystal Reports/Database
        
   3. Add a new string value: useDateInsteadOfDateTime
      ( Note: if the registry key already exist, go to next step )
      • • •   
   4. 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

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 Business View Manager , Problem

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020