Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Change and the world will change with you
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!


How Do I Work with Optional Parameters in Crystal Reports?

Since Crystal Reports 2008, designers have had the option to add optional parameters within their reports.

Optional parameters, provides designer the flexiblity to allow the end-user of the report to not have to select or enter a value for the parameter when the report is run.

In order for this to work correctly, Crystal Reports has introduced the HasValue function, to test to see if the Parameter field is empty

Effectively, this means that the parameter is being used in the report as the True condition, in the Select Criteria and will return all records for the field:
(Not HasVAlue({?ParameterField}) or
{TableName.FieldName} = {?ParameterField})

If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us


Name *

Email Address *

Comment *

To prove you are human what is:

39 + 50 =