asked on

Group by a Parameter in Crystal 2008

Is it possible to group by a parameter in Crystal Reports 2008?

Basically created a parameter to pull in Employees. It is setup so the user can select multiple employees or just a few. Problem is I need to group these employees that are being selected in the Parameter. The parameter just doesn't show up in the list in the Group Expert.

Thanks in Advance!

peter57r

" ...I need to group these employees ..."
Group them how?

Into a single group?
Are there other employees in the data? If so what happens to them?

SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Kurt Reinhardt

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jeremy Campbell

ASKER

mlmcc I believe that will work.. Let me give it a try and get back. Thanks for the quick response!

Jeremy Campbell

ASKER

Ended up using the select expert. TOTALLY forgot about that.. I didn't really need to have an "Others" category per say for the unselected employees so the select expert was simpler and kept the report much more organized.

For those searching for this to setup the select expert to, let's say, select specific employees, do the following:

Create a parameter for Employees that will allow you to select multiple employees.
Next go to Report in the menu>Select Expert>Record . Then select the employeename field and set it equal to your parameter... Simple as that..

Thanks again for the help though guys!

Jeremy Campbell

ASKER

Added instructions on how to use the select expert as stated by rhinok's comment.