Option to select all values of a parameter?

[TimothyP]

I am creating an employee performance review report.

One of my input parameters is to select the department(s) to be included in the report. On occasion, the client wants the option to select all departments without having to click on each one.
I have added to the department value list a “Select All Departments” option but do not know how to tie it back to select all the departments in the table.

Any suggestions?

Thanks in advance for your help.

 

[IdoMillet]

In the record selection formula use something like:
--------------------------------------------
{?Parm} = "Select All Departments" OR {dept} = {?Parm}
--------------------------------------------

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[jercisneros]

I had a similar problem a while back ago and here is what solved my problem:

From Helpful Member! DanENW (MIS)


You could set a default value for the parameter to some value that is not a legal dept, like "All Departments". Then replace the selection formula with the following:

(( {?Param} = 'All Departments' ) or // Accept all Departments.
( {?Param} <> 'All Departments' and // Accept only select Departments.
{Table.Department_Number} = {?Param} ))

Hope this helps you as much as it did me,

Jerry