Using doen't contain and without

[surad]

I am trying to write query that pulls data that ommit certain group and certain process but not sure how to use does not contain in the proper format in crystal.

My queries are as follows:

1) All cases opened where the Originator Workgroup does not contain “Support” AND the case was closed without dispatch.

2)All cases opened where the Originator Workgroup does not contain “Support” AND the case was dispatched to a queue OTHER than User Support as first dispatch.

3)All cases opened where the Originator Workgroup does not contain “Support” AND the case was dispatched to User Support as first dispatch.

Thanks,
Yuri

 

[IdoMillet]

What version of Crystal? If, CR9, use COMMANDs or Views where you can leverage subqeries (NOT IN...) .
Doing this with subreport is possible but too painful... )

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[lyanch]

The easiest way to do this is with a subselect inserted into your select statement. Something along the lines of

(select count(*) from table tinner where tinner.workgroup = table.workgroup and tinner.workgroupmember = "support&quot = 0

Without your actual table structures, db type and crystal version I can't give you anything more exact.

Lisa

 

[surad]

I am using Crytal Reports version 8.5.

 

[lbass]

Please provide sample detail level data before applying the record selection criteria described above and also a sample of how you would like the report to look.

-LB