Focal Point
dynamically position the column on PDF

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4101044591

November 08, 2006, 11:15 AM
<Neeraj>
dynamically position the column on PDF
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?
November 08, 2006, 11:26 AM
<Neeraj>
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?
November 08, 2006, 12:42 PM
mgrackin
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
November 08, 2006, 02:04 PM
Francis Mariani
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
November 08, 2006, 02:31 PM
KevinG
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
November 08, 2006, 03:21 PM
reFOCUSing
I agree with Francis. But this old post may give you an idea.