New Variable in a Report

[ACABLE]

HI all...

I am using BO 5.1.3 and have a report that pulls data back for my department for our Clairfy Clear Support cases. I am then required to split this data into mulitiple sections based on Team Leaders. Currently I have the employees for each Team Leader in each variable. I would like to be able to define a variable that contains each employees for each Team Leader and then use that in my variable. This would mean that I would only have to update one varaiable as employees are updated in the department.

This is an example of what I currently am using; (var is set as a Dimenison and name is NA TL TAG)
= If <Case Appointee.User Login Name> InList (&quot;DEANGELI&quot; ,&quot;KTOLER&quot;,&quot;JTUCKER&quot Then &quot;TUCKER&quot; Else If <Case Appointee.User Login Name> InList (&quot;FGROVES&quot; ,&quot;ERJOHN&quot; , &quot;TKAY&quot Then &quot;TKAY&quot; Else &quot;NON NA Team&quot;

I would like to be able to remove the list of names and use a varaiable in it place such as “Tuckers Team” which would contain all the employees asigned to Tucker.

An example of what I would like would be;
= If <Case Appointee.User Login Name> =<Tuckers Team> then “TUCKER” Else if < Case Appointee.User Login Name> = <Tkay Team> then “TKAY” Else “NON NA Team”

Where “Tuckers Team” = (&quot;DEANGELI&quot; ,&quot;KTOLER&quot;,&quot;JTUCKER&quot setup as a Detail object.

I am not sure if this can be done or not (the above does not work). If anyone has any ideas please let me know, it would save me a lot of time from having to update all my variables for a single user update.

Thanks for any help…
Andrew

 

[skrandel]

You'd need to build a variable somewhere that hardcodes the list.

The best answer is to build a table at the database level that does what you want. Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com

 

[ACABLE]

Steve,

Thanks for the reply. My problem is that I dont have access to the database level. I only have access to create reports. Can this be done at the report level?

Andrew

 

[skrandel]

Yes, but you have to build the groups somewhere. You can use the BO grouping funtionality or do it the way you've already done it.

Personally, I like the grouping method. Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com

 

[ACABLE]

Steve,

I have tried using the BO grouping but it appears to be a dynamic list based on . I am looking to create a static list. Is there anyway to create a static grouping list?

Thanks again for your help...
Andrew

 

[skrandel]

I'm confused. Most people consider the BO grouping functionality to be static. If it were dynamic, it would be able to handle new additions to the list without touching the report.

You won't be able to do exactly what you want. What you could do is build some more variables.

1) <Tuckers Team> defined as
=<Case Appointee.User Login Name> InList (&quot;DEANGELI&quot; ,&quot;KTOLER&quot;,&quot;JTUCKER&quot

2) Build other variables just like it for the other teams

3) Define your report column as
=if (<Tuckers Team> = &quot;True&quot then &quot;TUCKER&quot; else
if (<TKays Team> = &quot;True&quot then &quot;TKAY&quot; else
&quot;NON NA Team&quot;
Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com