Parameter Selection

[ChrisH1]

Using Crystal 8

I have a report using one parameter that Im having problems structuring.

The user needs to be able to select the offices the report displays.

I have used the following parameter

Called Office
Type = String
Allow Multiple Values = Ticked
Allow editing of default values when there is more than one value = ticked

Within Set Default Values :

I have added in all the offices

eg

Office 1
Office 2
Office 3
and so on

The select expert has

Unit is equal to {?Unit)


The user can select the offices they want but if they want all offices they will ignore this parameter and just run the report. How do I get the report to run for all offices if the user does not use the Unit parameter ?

Thanks

Chris

 

[Madawc]

Say that a blank parameter means "select all". Do a check formula field @OfficeCheck

?ParamOffice = " " or ?ParamOffice = {field.office}

In selection, include @OfficeCheck - this is taken to mean that record should be selected when @OfficeCheck returns 'True'.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[ChrisH1]

I have set up a new fomula called Office

as (?Office) = " "

You mentioned

"In selection, include @OfficeCheck - this is taken to mean that record should be selected when @OfficeCheck returns 'True'. "

I dont understand what you mean by " In selection"

What do I do with the formula ?

Thanks

 

[Madawc]

If you create @OfficeCheck using my formula and put it against unselected detail lines, it would show True or False.

If you put it as a command in the record selection, it will select just those details for which it returned 'True'.

You could also have it as @OfficeCheck = "True", but this isn't necessary.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10