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] Why data shifting and then overlapping on PDF

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Why data shifting and then overlapping on PDF
 Login/Join
 
Silver Member
posted
Recently, we upgraded to:
DataMigrator Server Version 7 Release 7.05
WebFOCUS Reporting Server Version 8.0.01

Some of the PDF reports appear with the column’s data shifting, and then overlapping.

Please see screen shot below.

http://imgur.com/XRoBjfA

The column’s data shifting and overlapping appear on the first line of the next page when data continue for a FACILITY doesn’t finish on the previous page. This was introduced in the new version since they have never happened before.

Please see code below.
---------------------
PRINT
START
END
ASSIGNMENTS/I4 AS 'GROUPS,ASSIGNED'
GROUPCAPACITY/I4 AS 'GROUP,CAPACITY'
NUMSTUDENTS/I4 AS 'STUDENTS,ASSIGNED'
STUDENTCAPACITY/I4 AS 'STUDENT,CAPACITY'
BY FACILITY
BY START NOPRINT

Has anyone met such case before? Have any solution?

Thanks

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


7703 on Linux, Windows
ReportCaster
PDF, HTML, Excel, AHTML, and CSV
 
Posts: 40 | Registered: January 31, 2008Report This Post
Expert
posted Hide Post
quote:
This was introduced in the new version since they have never happened before.

I would open a case with Tech Support.


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, 2005Report This Post
Platinum Member
posted Hide Post
It might not help, but try using
SET PRINTPLUS = ON
if it is not already in the code. It clears up many PDF formatting mysteries.


WebFOCUS 7.7.05 (Someday 8)
Windows 7, All Outputs
In Focus since 1983.
 
Posts: 103 | Registered: April 27, 2011Report This Post
Platinum Member
posted Hide Post
I have also had "shifting" data on reports when the actual data contains "special characters" e.g. tabs, new line etc.

As a side note though:
quote:

PRINT
START
END

I'm intrigued by the fact that WebFOCUS knows what to do with a field called "END" !


WebFOCUS 8.2.06 mostly Windows Server
 
Posts: 195 | Location: Johannesburg, South Africa | Registered: September 13, 2008Report This Post
Silver Member
posted Hide Post
Thanks all responses!!

We opened a case with Tech Support (Francis suggested also). Yesterday, we got an email from Tech Support:
- do not able to reproduce your issue so far in release 7.7.05.
-Change: SET PRINTPLUS=ON
To: SET PRINTPLUS=OFF

Also 'SET PRINTPLUS=ON' has been used in all our reports; PDF output contains page number on FOOTING BOTTOM.

Twanette, how to fix data shifting since contains special characters?

Have any one know other reasons can cause data shifting?

Thanks for the help.


7703 on Linux, Windows
ReportCaster
PDF, HTML, Excel, AHTML, and CSV
 
Posts: 40 | Registered: January 31, 2008Report This Post
Gold member
posted Hide Post
I am having this issue too. I tried both of these and same issue either way:

Change: SET PRINTPLUS=ON
To: SET PRINTPLUS=OFF

Has anyone figured this out yet?


8007
Windows 7, PDF, Excel
 
Posts: 75 | Registered: September 03, 2013Report This Post
Virtuoso
posted Hide Post
Maybe this can help : PDF Remediation


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2409 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Report 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] Why data shifting and then overlapping on PDF

Copyright © 1996-2020 Information Builders