Parameter is Null

[bpvsc]

I have created a report in Crystal 8.5 with parameters and have several combinations for the parameters. I need to use the null or blank field in some of the parameter choices. I can choose this as a parameter for reportingby selecting the "" in the choices but when published on the server for execution an error returns stating the syntax for the value prompt is not correct. Can anyone tell me how to code this in 8.5 so Enterprise will acknowledge the field that is null and return based on that parameter?
Thanks in advance.

 

[synapsevampire]

I don't think that CR parameters are ever null, though CE may interpret them this way.

I recall adding both a check for "" and isnull() when coding for CE...

You might try sharing some specifics, such as the type of parameter, and what is actually chosen, and how you're checking the parameter.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[meetcck]

Its possible to send null, the following might be of some help. This you can do using RDC.

Dim app As New CRAXDRT.Application
Dim rptAs CRAXDRT.Report

rpt.ParameterFields.Item(1).EnableNullValue = True
rpt.ParameterFields.Item(1).AddCurrentValue Empty

 

[synapsevampire]

I had coded for null in CE, so it must be that you can have a null within CE, but if you check the value of a parm in CR, it is NOT null, at least for text fields.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com