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,
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
DS 8.0.7 AS 8.0.7
Output: Excel, HTML, PDF, AHTML,Mobile
In Focus 1982
|Powered by Social Strata|