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