Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Where Clause Clarification
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Where Clause Clarification
 Login/Join
 
Gold member
posted
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
 
Posts: 51 | Registered: November 30, 2012Reply With QuoteReport This Post
Expert
posted Hide Post
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

 
Posts: 6136 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
Gold member
posted Hide Post
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
 
Posts: 51 | Registered: November 30, 2012Reply With QuoteReport This Post
Expert
posted Hide Post
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

 
Posts: 6136 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Where Clause Clarification

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.