Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pass null value to field - Constant for null value

Status
Not open for further replies.

OlafOdersky

Programmer
Nov 28, 2001
9
DE
Does crystal support a constant for Null values? I like to pass null to a field but does not found anything in the help files.

Thanks in advance

Olaf
 
Assuming you have no actuall Null in the database, the only way to "manufacture" a Null within Crystal is to trick it.

Create a formula that returns a constant. Use that formula as the return value when you need a Null.
Go back and remove the constant expression in that formula.
Ignore the error message when trying to run the report.

hth,
- Ido ixm7@psu.edu
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top