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.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] % symbol not displayed in EXL2k but it does show up in both PDF and HTML

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] % symbol not displayed in EXL2k but it does show up in both PDF and HTML
 Login/Join
 
Prabhakar
Member
posted
Hello there,
Today I experienced a new issue and sure that its not a excel version issue. Here is the scenario.
In our report we are holding and printing the SQLORA file which includes some sql packages. Data is coming as expected. In some columns the data has % symbol in it like "TES%T". The out put is same in PDF and HTML. But when the same is taken on to a excel the % symbol is getting stripped off and displaying as "TEST".
Please assist. Thanks,

This message has been edited. Last edited by: <Kathryn Henning>,


WebFOCUS 7.7.05 and 8.x
Windows, All Outputs
 
Posts: 27 | Registered: December 13, 2012Report This Post
njsden
Virtuoso
posted Hide Post
Taking your Oracle package out of the equation and trying to render an '%' with a simple request in EXL2K format works fine:

TABLE FILE CAR
PRINT COUNTRY
COMPUTE TEST/A20 = 'TEST%ME';
ON TABLE PCHOLD FORMAT EXL2K
END



How about this:

SQL SQLORA
<your PL/SQL call here>
;
TABLE ON TABLE HOLD AS HDATA
END
-RUN

TABLE FILE HDATA
PRINT *
ON TABLE PCHOLD FORMAT HTML
END


Does that keep your '%' sign intact?

If so, try then changin the format to EXL2K and see what happens.

As the report is now being produced out of a binary HOLD file, at least you can take Oracle out of consideration and focus on what may be causing the '%'character to dissapear ... or not.

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


Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
Prabhakar
Member
posted Hide Post
Thanks for your response. Here is the example to explain my issue better. let suppose

SQL SQLORA

FIELD1 (ACTUAL FIELD LENGTH - A300V)
FIELD2 (ACTUAL FIELD LENGTH - A4000V)
;
ON TABLE HOLD AS HDATA
END
-RUN



TABLE FILE HDATA
PRINT
FIELD1
FIELD2
ON TABLE PCHOLD FORMAT HTML/PDF
END
O/P:
FIELD1 FIELD2
For%testing%purpose TES%T01
For%testing%purpose TES%T

Same date when pulled on to an exl2k, % symbol is getting stripped off. However for field 1, the % symbol is showing up.
TABLE FILE HDATA
PRINT
FIELD1
FIELD2
ON TABLE PCHOLD FORMAT EXL2K
END
O/P:
FIELD1 FIELD2
For%testing%purpose TEST01
For%testing%purpose TEST

If we keep a compute field with data type A300V as that of FIELD1 its working. Not sure how.

TABLE FILE HDATA
PRINT
FIELD1
COMPUTE/A300V =FIELD2; AS FIELDS2_1
ON TABLE PCHOLD FORMAT EXL2K
END
O/P:
FIELD1 FIELD2_1
For%testing%purpose TES%T01
For%testing%purpose TES%T

There might be strings with more than A300V for which the report might break. Please assist. Thanks.


WebFOCUS 7.7.05 and 8.x
Windows, All Outputs
 
Posts: 27 | Registered: December 13, 2012Report This Post
Tony A
Expert
posted Hide Post
Try trapping the MHT output from the EXL2K format and look at it in your favorite editor app. If you see the data with the '%' inclusion then it's MS Excel causing you issues, otherwise contact support.

T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Prabhakar
Member
posted Hide Post
In spite of trying with the .mht (Excel) format option, I am still not able to get the % symbol in the Excel output.
To isolate the issue. Please check the below example
TABLE FILE CAR
PRINT
COMPUTE TEST/A600V = 'SAMP%LE%';
CAR
ON TABLE PCHOLD FORMAT EXL2K
END
For PDF, % is being displayed on the O/P for col TEST.
For excel its simply showing as SAMPLE. However if i change the data type from A600V to A575V it is working fine. Not sure why it is getting broken after A575V. Please assist. Thanks.

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


WebFOCUS 7.7.05 and 8.x
Windows, All Outputs
 
Posts: 27 | Registered: December 13, 2012Report 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] % symbol not displayed in EXL2k but it does show up in both PDF and HTML

Copyright © 1996-2020 Information Builders