Focal Point
[SOLVED] Displaying the Greater-than-or-less-than symbol

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

March 23, 2011, 03:55 PM
tlbrydie2
[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 



Thanks

This 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

March 23, 2011, 04:11 PM
Tom Flynn
Tim,

Try 60 and 62...

ASCII Conversion Chart


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
March 23, 2011, 04:37 PM
tlbrydie2
Tom:

60 and 62 worked..but the results are < and >,

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 



Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
March 23, 2011, 05:08 PM
Francis Mariani
Tom, according to tlbrydie2's sig, his platform is Windows. You don't need HEXBYT for these characters - they're on the keyboard, so
CR/A2 = '>=';
works.

tlbrydie2's looking for ≥ which I can't seem to get to display with HEXBYT. For HTML only, this
&ge;
gives you ≥.


Francis


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 23, 2011, 05:13 PM
Tom Flynn
AHH! Thanks Francis.

I almost put your CTRAN link up, but, thought better of it.

Well, it's always doable via an image...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
March 24, 2011, 08:40 AM
tlbrydie2
Tom and Francis,

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

Works in HTML and EXCEL, also...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
March 24, 2011, 03:48 PM
Francis Mariani
Very inventive!


Francis


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...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
March 25, 2011, 09:46 AM
Prarie
Good job Tom. Always hate to see someone say something can't be done in WebFocus...there is usually a way!
March 25, 2011, 11:15 AM
Tom Flynn
THANKS Linda! Hope all is well with you in San Antonio Texas...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
March 25, 2011, 11:44 AM
Prarie
Enjoying Spring!