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     [Solved] Problem opening/displaying PDF reports with text fields

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[Solved] Problem opening/displaying PDF reports with text fields
 Login/Join
 
Deana
Gold member
posted
I am trying to convert reports from 7.6.8 to 7.7.03. The last report I need to convert prompts the user for selection criteria.

The datasource is SQL. The report displays multiple fields; one of which is varchar(max) in SQL. The focus master file desciption is USAGE=TX50, ACTUAL=TX.

In 7.7.03 - depending on the size of result set of the selection criteria my pdf will open. However, the text field never prints on the report.

In 7.6.8 - regardless of the size of the result set, the pdf opens. The entire text field is displayed, regardless of length.

Thank you in advance for your assistance.

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


WebFOCUS 7.6.8 and 7.7.03; Windows Server 2003 R2 and Windows Server 2008 R2, respectively; Development environments - Windows Server 2003 R2 and Windows 7 Professional, respectively;
excel, html, pdf
 
Posts: 89 | Registered: March 19, 2011Report This Post
GamP
Virtuoso
posted Hide Post
This really seems to be an issue with that particular version of webfocus.
What I'd do is register a call with IB tech support to see if this is already a known problem and/or can be remedied.


GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Deana
Gold member
posted Hide Post
The solution was to change the definition from TX50 to AnV where n is the max size of the field. I believe the max is 4098. Thank you.


WebFOCUS 7.6.8 and 7.7.03; Windows Server 2003 R2 and Windows Server 2008 R2, respectively; Development environments - Windows Server 2003 R2 and Windows 7 Professional, respectively;
excel, html, pdf
 
Posts: 89 | Registered: March 19, 2011Report This Post
Deana
Gold member
posted Hide Post
After running into other fields which contained data with more characters than the max for AnV fields, I did more research.

I added 'ENGINE SQLMSS SET CONVERSION LONGCHAR TEXT' to the edasprof.prf. This appears to have fixed my problem, allowing me to use USAGE=TX50, ACTUAL=TX for the sql varchar(max) fields.


WebFOCUS 7.6.8 and 7.7.03; Windows Server 2003 R2 and Windows Server 2008 R2, respectively; Development environments - Windows Server 2003 R2 and Windows 7 Professional, respectively;
excel, html, pdf
 
Posts: 89 | Registered: March 19, 2011Report 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     [Solved] Problem opening/displaying PDF reports with text fields

Copyright © 1996-2020 Information Builders