How to customize a record selection formula 1

[Sielah]

My report provides a breakdown of all hours worked by employees in a certain team. The only parameter to the report is the ID of the team leader.

The problem is that one team has an employee type that I don't want to include. How do I set up the record selection to recognize this?

I want it to work as follows :

1. Retrieve all records where boss_id = input parameter
2. If boss_id = 202, retrieve all records where boss_id = input parameter and role_id = 1

Any advice on how to implement this in the record selection criteria?

Thanks!

 

[Turkbear]

Hi,
Convert your posted sentences to a record selection formula:

If {?InputParameter} = 202 
Then
({Table.Boss_Id} = 202 AND {table.role_id} = 1)
Else
{Table.Boss_Id} = {?Inputparameter}

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lbass]

If you want to pull more than one team at a time (use a multiple value parameter), try a record selection formula like this:

{table.boss} = {?bossID} and
(
(
{table.boss} = 202 and
{table.roleID} = 1
) or
{table.boss} <> 202
)

-LB

 

[Sielah]

That worked beautifully. Thanks!