Create group from data not in the database. Is it possible.

[drgonzo1972]

is it possible to create a group based on data not available in the tables you are gathering data from without creating another table in the database. I am using a server application which stores data on our agents(employees) by agent ID field. If I want to group these agents by team ID can I create a group by team group even though no table exists with this data on the database.

I am using CR6

Cheers

 

[TheBlondOne]

Hi there, you could create a formula like this:

if {emp_id} in [1,3,5,6,7,8] then "Team Id 1" else
if {emp_id} in [2,4,9,10,11] then "Team Id 2" etc...

This is not very practical if there are a lot of teams, and its time consuming, but you will be able to group on the formula you've just created. HTH

 

[drgonzo1972]

That ought to do it. Only 3 teams......about 40 employees. Thanks!

 

[Andie]

Another idea is to use "specified" group order. You can group on emp_id but set up the groups in specified order. Name the specified group Team_1 and include all the appropriate agents.