Crystal Reports & Parameters

[saw15]

I am using Crystal reports v7.

I am writing a report and would like to allow the user to specify one ticket # or using a wildcard, get all of the tickets. Ticket ticket field is a string field.

Ex.. User selects the start date, and then the ticket #. Assuming that he does not want to select a specific ticket #, how can I set the parameter using somelike * or %, which will give back all of the ticket #'s from the start date?

I have tried using the % or * as the default in the parameter, but it did not work.

Thanks..

 

[VE]

Try this:

In the select expert choose formula

if {?ticket number parameter} = "" then true
else {ticket number field} = {?ticket number parameter}


That will give you all ticket numbers when the user leaves the parameter blank.

VE