Focal Point
[CLOSED] positive, negative, and All parameter

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

December 08, 2011, 11:04 AM
Arif
[CLOSED] positive, negative, and All parameter
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
December 08, 2011, 11:29 AM
Dgraff
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