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     dynamically position the column on PDF

Read-Only Read-Only Topic
Go
Search
Notify
Tools
dynamically position the column on PDF
 Login/Join
 
<Neeraj>
posted
Does anyone know how to dynamically position the data depending on the # of
columns that the report produces?

Lets say the report produced 10 columns we need to calculate total width
of the columns and then accordingly position it on pdf so that it looks in
center.

Is there Anyway to know the total length of all columns (dynamic) for the
selection the user makes?

To proceed we need to find -
Step 1. first how many columns fits in one page.
Step 2. Always display the report in the center.

Can anyone help on this?
 
Report This Post
<Neeraj>
posted
I found the record length of all the columns
using -

SET HOLDLIST=PRINTONLY
SET ASNAMES=ON

TABLE FILE CAR
PRINT CAR
BY COUNTRY
ACROSS MODEL
ON TABLE HOLD AS NKR
END

? HOLD NKR

TABLE FILE SYSTABLE
PRINT RECLENGTH
WHERE NAME EQ 'nkr'
END

-EXIT

but how to adjust with the margins accordingly for getting it in center.

Any Guru there to resolve it?
 
Report This Post
mgrackin
Virtuoso
posted Hide Post
Neeraj,

There is a field in the SYSTABLE called COLCOUNT which contains the number of columns in the hold file.


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
 
Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003Report This Post
Francis Mariani
Expert
posted Hide Post
I don't think there's a reasonable way of doing this.

There are too many variables - the font size, the number of columns, the width of the columns, etc.


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
KevinG
Platinum Member
posted Hide Post
Neeraj,

You might experiment with using Dialogue Manager variables to set the squeeze value in the Style Sheet.

Since you know the columns available for selection, you could assign each a specific value to be used as the squeeze value in the Style Sheet.

Using IF logic, test to see if the column has been selected and add the values of the squeeze variables together to get the total width for the columns selected and adjust the margins accordingly.

The report heading is a different story, but assuming you want that centered, you will know the minimum width for the report based on that.

Keep us posted,

kevin


WF 7.6.10 / WIN-AIX
 
Posts: 141 | Location: Denver, CO | Registered: December 09, 2005Report This Post
reFOCUSing
Guru
posted Hide Post
I agree with Francis. But this old post may give you an idea.
 
Posts: 406 | Location: Canada | Registered: May 31, 2004Report 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     dynamically position the column on PDF

Copyright © 1996-2020 Information Builders