Hello,

We are wanting to send a null value to a report parameter from the command line.  Is there a way to do this?

Thank you very much in advance!

To pass a null value, use the string "<NULL>". I think this only works for stored procedure parameters, because regular Crystal Reports parameters don't accept null values. For optional parameters (supported in recent versions of Crystal Reports) use an empty string ("") instead.

I tried "<NULL>" and just <NULL>, but I get the error:

Error: Failed to set parameter "@accntNum" to "<NULL>": Cast from string "<NULL>" to type 'Double' is not valid.

When I try "", it does not send the NULL on to SQL. 

Any other suggestions? 

What version of Report Commander are you using? I think the null support was not added until version 1.2, or maybe even slightly after that, so you should be using the latest version (1.4).

We are using Version 1.2 build 103 :(

Then you need to install version 1.4 from the download page. The license you have already will work for version 1.4.

Yes, but then we have to test to make sure everything will work the same with the new version.  We run a lot of production reports using report commander.  Or, can I have two different versions residing on the same server?

You cannot have 2 different versions of Report Commander on the same computer.