Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Displaying the Greater-than-or-less-than symbol
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Displaying the Greater-than-or-less-than symbol
 Login/Join
 
Platinum Member
posted
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

 
Posts: 133 | Registered: December 29, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
Tim,

Try 60 and 62...

ASCII Conversion Chart


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1956 | Location: Centennial, CO | Registered: January 31, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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

 
Posts: 133 | Registered: December 29, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
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
 
Posts: 1956 | Location: Centennial, CO | Registered: January 31, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
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
 
Posts: 1956 | Location: Centennial, CO | Registered: January 31, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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

 
Posts: 133 | Registered: December 29, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
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
 
Posts: 1956 | Location: Centennial, CO | Registered: January 31, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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

 
Posts: 133 | Registered: December 29, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
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
 
Posts: 1956 | Location: Centennial, CO | Registered: January 31, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Good job Tom. Always hate to see someone say something can't be done in WebFocus...there is usually a way!
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Reply With QuoteReport This Post
Expert
posted Hide Post
THANKS Linda! Hope all is well with you in San Antonio Texas...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1956 | Location: Centennial, CO | Registered: January 31, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Enjoying Spring!
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Displaying the Greater-than-or-less-than symbol

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.