Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need help with include/excludes 1

Status
Not open for further replies.

loveyoursite

Technical User
Apr 14, 2005
100
US
CRV10. I have a report that needs to show employees with more than one position, i.e. Level 1, Level 2, Level 4.
If an employee has more than 1 position, then all of the positions must be listed. I'm not sure how to exclude those employees who have ONLY 1 position. For example:

Include employees with more than 1 position:
J. Brown, Pos Level 1, Painter
J. Brown, Pos Level 2, Contractor
J. Brown, Pos Level 5, Engineer

Exclude employees who have ONLY 1 position, which would always be a Level 1:
B. Green, Pos Level 1, Painter

I would appreciate any assistance. Thanks!
 
Group on {table.employee}, and then go to report->edit selection formula->GROUP and enter:

distinctcount({table.position},{table.employee}) > 1

-LB
 
That worked perfectly. Thanks so much! If you have time, would you mind telling me what that formula is "saying"? I'm not sure I understand.
 
Select this group of employee records if the employee has more than one position."

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top