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     [CLOSED] positive, negative, and All parameter
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] positive, negative, and All parameter
 Login/Join
 
Guru
posted
Does any one know how can I give my users options to select positive only, negitive only or all numbers in one report?

I have a reprot that showes customers positive balances and negitive balances. Some users only want to see negitive balances, some want positive only, and some want all balances. How can this be accomplished?

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Reply With QuoteReport This Post
Gold member
posted Hide Post
If the users are using a Launch screen you could define 3 radio buttons Positive Negative and all. Then set a variable &TSTVLU
-set &TSTVLU = IF PIOSITIVE THEN 'GE' ELSE
- IF NEGATIVE THEN LE
- ELSE 'FOC_NONE'
then include the following in the report

WHERE BALANCE &TSTVLU 0


Duane

WebFOCUS 8.0.7
DS 8.0.7 AS 8.0.7
Windows
Output: Excel, HTML, PDF, AHTML,Mobile
In Focus 1982
 
Posts: 83 | Location: Princeton NJ | Registered: October 26, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] positive, negative, and All parameter

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