How to allow mulitple fields in dynamic parameter

[Oglesbay]

I am using Crystal XI and am trying to create a report with two dynamic parameters. The first parameter is to select the correct office and then the second parameter is to select the department within the office. I would like the ability to select multiple departments or select all of them. I have set the "Allow Multiple Values" to True for the second parameter, however when I select multiple departments the report only shows the last department that is on the list. Am I doing something wrong? Please help!

 

[IdoMillet]

What is your record selection formula?

- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[Oglesbay]

Right now it is this:

{class.xstartdate}in{?Start Date}to{?End Date} and
{person.dept} = {?My Parameter - dept} and
{person.loc} in [{?My Parameter - loc}] and
{event.xstatus} = "F

 

[IanWaterman]

Don't think you need to use in for your location param.

Try

{class.xstartdate}in{?Start Date}to{?End Date} and
{person.dept} = {?My Parameter - dept} and
{person.loc} ={?My Parameter - loc} and
{event.xstatus} = "F"

Ian

 

[Oglesbay]

Nope, that didn't work. I think it had the "in" because I was trying different things and the last thing I did was set the parameter to "One of" instead of "Exactly." Obviously that didn't work either.

Any other ideas?

 

[Oglesbay]

I think I figured out what it was doing...

Because each of our departments start with a number, the program is looking at the selected parameters and is finding the smallest number first and then going numerically from there. I happen to have the smallest numbered department last, which is why it was only showing the last department in the list.

If I started over and put the list in numerical order then I get every department. So at this point I think I can concider this point closed. Thanks for everyone's help and I guess the learning point to take away is to make sure your list is in numerical/alphabetical order!