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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parameter is Null

Status
Not open for further replies.

bpvsc

MIS
Apr 30, 2002
18
US
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.
 
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 kai@informeddatadecisions.com
 
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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top