[SOLVED] Displaying the Greater-than-or-less-than symbol
Hello all,
I have a report that requires me to display the symbol for "greater than or equal to" and "less that or equal to". I am attempting to use the function "HEXBYT" to convert the decimal representation to the sysbols, however when I use 8804 and 8805 , which is what the web says is the decimal representation for these fields, get different values. Does anyone have any sugestion:
DEFINE FILE CAR
CR/A2 = HEXBYT(8805, 'A2');
END
TABLE FILE CAR
PRINT
MODEL CR
END
ThanksThis message has been edited. Last edited by: tlbrydie2,
Prod: WebFOCUS 7.6.10 MRE Oracle/Sybase Test: DevStudio 7.6.6 WF Server 7.6.6 Report Caster 7.6.6 Web Server - Tomcat MS Windows XP SP2 Output: HTML, Excel 2000 , PDF, CSV, DOC
I'm looking for the symbolic representation for "greater than or equal to" and "less that or equal to" which from my understanding are 8804 and 8805 but this is not returning the right symbols
Prod: WebFOCUS 7.6.10 MRE Oracle/Sybase Test: DevStudio 7.6.6 WF Server 7.6.6 Report Caster 7.6.6 Web Server - Tomcat MS Windows XP SP2 Output: HTML, Excel 2000 , PDF, CSV, DOC
March 23, 2011, 04:45 PM
Tom Flynn
Tim,
Is this the representation you are looking for?
DEFINE FILE CAR
CR/A2 = IF COUNTRY IN ('JAPAN','ENGLAND') THEN HEXBYT(60, 'A1')|| HEXBYT(61, 'A1') ELSE
HEXBYT(61, 'A1')|| HEXBYT(62, 'A1');
END
TABLE FILE CAR
PRINT
MODEL CR
END
Thanks very much for taking time in your day trying to assist me.
I don't seem to be getting the right results, I wanted to exhaust all possibilities, before I went back to the client and told them WF could not handle this. I'm looking at one other thing..but thanks allot for both of your help.
Timothy
Prod: WebFOCUS 7.6.10 MRE Oracle/Sybase Test: DevStudio 7.6.6 WF Server 7.6.6 Report Caster 7.6.6 Web Server - Tomcat MS Windows XP SP2 Output: HTML, Excel 2000 , PDF, CSV, DOC
March 24, 2011, 03:26 PM
Tom Flynn
Well, I never give up - How about this:
DEFINE FILE CAR
CR/A1 = IF COUNTRY IN ('JAPAN','ENGLAND') THEN HEXBYT(60, 'A1') ELSE HEXBYT(62, 'A1');
END
TABLE FILE CAR
PRINT
MODEL CR
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=N2, STYLE=NORMAL+UNDERLINE, JUSTIFY=CENTER,$
ENDSTYLE
END
-EXIT
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
March 24, 2011, 04:13 PM
tlbrydie2
Tom,
That was a very creative solution...it just might be acceptable to the client.
Why did'nt I think of that1! :-)
Thanks allot, Timothy
Prod: WebFOCUS 7.6.10 MRE Oracle/Sybase Test: DevStudio 7.6.6 WF Server 7.6.6 Report Caster 7.6.6 Web Server - Tomcat MS Windows XP SP2 Output: HTML, Excel 2000 , PDF, CSV, DOC
March 24, 2011, 04:21 PM
Tom Flynn
Thanks to both of you, and, hope it works for the "client".
Every once in a while, it's good to be creative, even though, as Francis stated earlier, don't need HEXBYTE, just the '>' or '<' test...