Group & Record Selection 1

[mnmdesigns]

Hi,
I am having problem with Group and record selection in my report. Here is what I am trying to do.

First I need to have a group where the {Employee.Position} has to be manager. In my case it would be {Employee.Position} = "MANAGER"

Then I only need to show those reocords in the deatial that fall under this manager. {Employee.Position} = "FRONT DESK ASSOCIATE} and {Employee.Position} = "ASSISTANT MANAGER"

The database has a field which shows their relationship in the field {Employee.ParentID}.

So my end result would be:

Group = Manager Name and ID.
Records = ID and Name of the Employee that work for this manager.

I will be very grateful if someone can show me how to do this.

Thanks in advance.
MD

 

[mnmdesigns]

Lbass,

Here is what my selection formula looks like.
{employee_1.position} = "Manager"
and
{employee.position} in ["Front Desk Associate","Assistant Manager"]
and
if {?ID or Name} = "ID"
then
(if {?ID} <> &quot;All&quot; then
{?ID} = {employee.id} else true) else

if {?ID or Name} = &quot;Name&quot; then
(if {?Name} <> &quot;All&quot; then
{?Name} = {employee_1.name} else true)

The problem is that when I enter a certian ID it is still showing me all the records. I tried the same thing with the last name and still get all the records.

Thanks for all your help and patience.
MD.

 

[lbass]

It tests out here for all, 1 or multiple selections of either parameter. When you select the parameter value are you being sure to take the second step of clicking on &quot;add&quot; before saying okay?

-LB

 

[mnmdesigns]

Lbass,
Oops I was not doing that, now when I do it I get 0 records in the report. :-(
MD.

 

[lbass]

I'm almost out of ideas here. When you created the string parameters did you enter all defaults (ID, Name, All) without any quotations marks? The case should be the same as in your record select statement also.

-LB

 

[mnmdesigns]

Lbass,

Thanks for all your help. I really appreciate it. I had to change the &quot;Browse table&quot; & &quot;Browse field&quot; to {Employee} and {ID} and the ID portion has started working. The Name field was optional. I am not going to add that to the report. I appreciate all your help and patience.

Thanks once again.
MD.