Focal Point
[SOLVED] Where Clause Clarification

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9947042336

September 04, 2013, 09:41 AM
cs_source
[SOLVED] Where Clause Clarification
This might be a very simple question but i don't know why i'm having trouble with this, i have a report where i have a cost center example 99999 and within that cost center i have employes 1 through 5.

I would like to create a report where i output costcenter 99999 and not include employee 4

WHERE ( COSTCENTER EQ '99999') AND ( jobcode NE '4' );

This message has been edited. Last edited by: <Kathryn Henning>,


WebFocus 8.02, SQL Server 2008r2
September 04, 2013, 05:38 PM
Waz
This looks right, but also depends on your data structure as well.

Have you tried it ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

September 16, 2013, 01:44 PM
cs_source
Hi Waz,

After just looking at the report again i found the issue, the error was not the where clause it was the field i was looking at. There is a case set on that field and it populates a value based on a certain criteria.

This is resolved now Thank you Smiler


WebFocus 8.02, SQL Server 2008r2
September 16, 2013, 04:44 PM
Waz
Please edit the first post in this thread and add [SOLVED] or [CLOSED] to the title.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code