SAP Knowledge Base Article - Public

2355804 - No data returned, when refreshing a report based off a Universe Stored Procedure with a Date Time parameter in Crystal Reports

Symptom

  • No data returned, despite expecting data.
  • Report based off a Universe returns no records.
  • In Crystal Reports, when refreshing a report based off a Universe Stored Procedure with a Date Time parameter, it returns no data.
  • When reporting directly from the same stored procedure, and entering the same parameter value, the report returns data.

Environment

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

Reproducing the Issue

  • Create a Stored Procedure with a Date Time parameter in any database.
  • In the Universe Design Tool, create a Universe based off the Stored Procedure with a Date Time parameter.
  • Save and export the Universe to the SAP BusinessObjects Repository.
  • In Crystal Reports, create a report off the Universe based off the Stored Procedure.
  • When refreshing the report, enter a date time value that should return data, but notice the report returns no data.

Cause

  • This issue occurs due to the Date Time value mapped to the wrong data type when reporting off a Universe in Crystal Reports.
  • This issue has been tracked under SAP Note 2353835

Resolution

  • The issue is resolved, or will be resolved in the following product updates, and above:
             
    • Crystal Reports 2013:
      • Support Pack 09
            
    • Crystal Reports 2016:
      • Support Pack 04
             
    • Crystal Reports for Visual Studio 2010
      • Support Pack 18
                            
                 
  • To workaround this issue:
    • Create a report directly off the stored procedure instead of using a Universe; or
    • If the time portion of the date is not important, then modify the stored procedure to only have a  date parameter instead of a date time parameter, then update the Universe.

Keywords

CR, UNV, .UNV, sproc , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Bug Filed

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016