TOPIC: Set as NULL - specified parameters

Set as NULL - specified parameters 08 Jul 2009 22:18 #461

  • NuttCorp
  • NuttCorp's Avatar
all of our reports have some parameters that are meant to be left null unless you want to filter the report. i am trying to set the scheduling system to email several of these reports but when i execute it i get a missing parameter values. (emailCrystalReport) error.
i need to be able to specify null in certain parameters so that it runs without any user intervention. how can i specify NULL as a value to a parameter.
The administrator has disabled public write access.

Re:Set as NULL - specified parameters 28 Jul 2009 21:41 #492

  • aellis
  • aellis's Avatar
Can you pass something like the word "NULL" into the parameter and then build your select expert to handle that? Something like:
If {?Parameter1} <> "NULL" Then {TABLE.FIELD} = {?Parameter} Else 1=1
The administrator has disabled public write access.