Focal Point
CLOSED****FOC NULL IN GRAPH TITLE

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

October 20, 2014, 09:02 AM
RobertF
CLOSED****FOC NULL IN GRAPH TITLE
We have an HTML Page with several drop downs, each has an: ALL option. In the Advanced graphing assistant, Chart Title, I type: Specialty: &THESPECIALTY, Rollup: &THEROLLUP, Provider: &THEPROVIDER.


It works fine shoing the user selections EXCEPT for when the user Selects: ALL. Instead of dsplaying teh word: ALL...it displays: FOC NULL.

How can I get around this?

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


WebFOCUS 8206.08
Windows, All Outputs
October 20, 2014, 09:07 AM
MartinY
To not loose value entered by user (and be able to use it going forward) and display it on screen in a title as you do, I process that way:
-SET &THESPECIALTY_TXT = IF &THESPECIALTY EQ FOC_NONE OR _FOC_NULL THEN 'ALL' ELSE &THESPECIALTY;

Then use &THESPECIALTY_TXT in you title.


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
October 20, 2014, 10:16 AM
RobertF
Thanks!


WebFOCUS 8206.08
Windows, All Outputs