• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 389
  • Last Modified:

Optional Parameter fields in Crystal Reports

I have a crystal report that was written in crystal 2008 off a 2008 sql server.
The report has a total of 5 parameters.
Not all the parameters need to be selected for the report to be ran.
Is there a way to make some optional and some required?
0
metalteck
Asked:
metalteck
2 Solutions
 
vastoCommented:
Edit the parameter and set the optional prompt to true as it is shown in the attached file. In you formulas you can use HasValue to check if the parameter was set
if hasvalue({?Parameter} then 
....

Open in new window

0
 
mlmccCommented:
Be sure the value returned is TRUE if there is no value passed.

I generally do this by

(Not HasValue({?Param1}) OR {?Param1} = {Field1})

mlmcc
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now