Infoview NULL value for DateTime parameter

[techie2]

Using Crystal Reports Server XI with SP1.
Database is SQL Server 2000.
Connection to report using ODBC, using SQL Server driver.

This report is written against the stored procedure. I can set the value to NULL from the designer; parameter type is datetime.

When I try to set a parameter value to NULL from Infoview, I am getting the following error message:
An error has occurred: One or more arguments are invalid.

Are there any known issues while setting up the parameter values to NULL.

 

[Turkbear]

Hi,
IIRC,CE is picky about Date and DateTime parameters..
You may need to have a 'special' date, like 1/1/1800, and in the SP deal with ignoring it when it is set to that date.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[techie2]

This is a known issue. Here is the knowledge base on this and for installing the Hot Fix.

http://support.businessobjects.com/library/kbase/articles/c2018624.asp