Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] problem in excel reort while using < (Less than)symbol in header section

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] problem in excel reort while using < (Less than)symbol in header section
 Login/Join
 
Santhu
Gold member
posted
In a fex file whenever i am trying to display a string "-SET &&CONFLVL_NAME_VAL_E= 'c- < 75% xyz';" ,in header section, in excel format its throwing error "[FOC406) THE FIELDNAME IS NOT RECOGNIZED: 75% BYPASSING TO END OF COMMAND " .
"Confidence Level: <+0> &CONFLVL_NAME_VAL_E"-before execution.

"Confidence Level: <+0> c- < 75% xyz"- after execution
the problem is with the '<' symbol. how can i overcome this problem [with '>' the string works fine ).

Please help me out.

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


WebFOCUS 8.0.0.7 App Studio
 
Posts: 67 | Registered: September 26, 2008Report This Post
Darin Lee
Virtuoso
posted Hide Post
The < symbol used in a heading is an indication that a field is to be embedded in the heading and the next string indicates the name of that field. You might try putting that whole string [including the < symbol) into a DEFINEd field and embedding that field in the heading instead.


Regards,

Darin


In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Santhu
Gold member
posted Hide Post
Hi Darin,

Thanks for you reply,
I have tried this option. It prints just a .(dot) in the excel report.
as well as i tried in html also it is printing me .(dot) only.

can you give some other idea.


WebFOCUS 8.0.0.7 App Studio
 
Posts: 67 | Registered: September 26, 2008Report This Post
Danny-SRL
Virtuoso
posted Hide Post
Santhu,

What Darin is telling you is to use something like:
  
DEFINE FILE CAR
HH/A40 WITH COUNTRY='c- < 75% xyz';
END
TABLE FILE CAR
HEADING
"Confidence Level:<HH"
SUM SALES
BY COUNTRY
ON TABLE PCHOLD FORMAT EXL2K
END


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Santhu
Gold member
posted Hide Post
Thanks Danny for ur code.

what ever u posted the code is working fine.
when there is no data for the criteria you selected i.e 0 Records form table file then you will not be able to dispaly the value in header.

Second point is:
if table file has 45,000 records, by using define file perfomance gets effected.

what do you say?


WebFOCUS 8.0.0.7 App Studio
 
Posts: 67 | Registered: September 26, 2008Report This Post
Danny-SRL
Virtuoso
posted Hide Post
So, you use: SET EMPTYREPORT=ON, and yes the value won't be in the HEADING.

1. Can you use « instead?

2. If you don't link the header field to a field in the database (like I did), then there is no reason for performance to be affected. This field will be calculated once and has no effect on the retrieval. If it does, you should open a case with IBI.


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] problem in excel reort while using < (Less than)symbol in header section

Copyright © 1996-2020 Information Builders