Query is for specific group, do not want to include others

[cathey04]

I am using Crystal 10, HP Service Desk running on Oracle. I have a need where I only want to show specified groups in a report and not others, how would I exclude them? I have tried just using the Selection option

{V_SERVICECALL.ASSWORKGROUP_NAME} startswith ["Access Request", "Tier 3 Ops Security", "Tier 4 Business Avvert", "Tier 4 Business Awert", "Tier 4 Eng Info Security"] and {V_SERVICECALL.ID} > 1600000 and {V_SERVICECALL.CREATED} in LastFullWeek or V_SERVICECALL.ACTUALFINISH} in LastFullWeek

but when I setup a cross tab for service calls closed, I get every group. I tried the following workgroup formula in a cross tab and it works, but I still get a blank row with the number of calls closed that day by other groups. Here is the workgroup formula.

If {V_SERVICECALL.ASSWORKGROUP_NAME} startswith ["Access Request", "Tier 3 Ops Security", "Tier 4 Business Avvert", "Tier 4 Business Awert", "Tier 4 Eng Info Security"] then {V_SERVICECALL.ASSWORKGROUP_NAME}

Here is the output crosstab results

6/17/07 6/18/07 6/19/07 6/20/07 6/21/07 6/22/07 6/23/07 6/25/07 6/26/07 6/27/07 6/28/07 Total
0 981 3,255 3,476 3,380 3,340 3,545 1,687 0 0 0 0 19,664
Access Request 96 0 101 100 70 74 74 0 58 70 54 3 700
Tier 3 Ops Security Access Management 79 0 25 22 35 3 34 0 32 11 18 9 268
Tier 3 Ops Security Proxy-Outbound 1 0 0 0 0 0 0 0 0 0 0 0 1
Tier 3 Ops Security Shaws 11 0 26 24 7 5 8 0 7 8 10 2 108
Tier 4 Eng Info Security 0 0 2 2 0 0 1 0 0 1 0 0 6
Total 187 981 3,409 3,624 3,492 3,422 3,662 1,687 97 90 82 14 20,747

Thanks!

 

[lbass]

You need parens in your record selection formula:

V_SERVICECALL.ASSWORKGROUP_NAME} startswith ["Access Request", "Tier 3 Ops Security", "Tier 4 Business Avvert", "Tier 4 Business Awert", "Tier 4 Eng Info Security"] and
{V_SERVICECALL.ID} > 1600000 and
(
{V_SERVICECALL.CREATED} in LastFullWeek or
{V_SERVICECALL.ACTUALFINISH} in LastFullWeek
)

Otherwise the last clause is treated as an alternative to all clauses prior to it.

-LB

 

[cathey04]

Thanks you so much, it worked like a champ