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] Column heading to appear in 2 or 3 line

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Column heading to appear in 2 or 3 line
 Login/Join
 
Jan1
Gold member
posted
Hi,

I need to display a report in PDF with the column headign appearing in two or three lines.
I need the ouptut like

Country CAR
Seats Model
------------------------
ENGLAND JAGUAR
10 xxxx

FRANCE BMW
20 YYY

AND SO ON..I have tried using both using SUBHEAD as well using OVER.Iam having aligning issues with OVER.
Please find both the types of code below.

Using subhead
------------

TABLE FILE CAR

PRINT *

ON TABLE HOLD AS HLD_CAR
END



TABLE FILE HLD_CAR
BY COUNTRY NOPRINT
SUBHEAD
"CountryNAME<+0><+0>CARNAME<+0><+0>MODELNAME<+0><+0>NO.OFSEATS<+0><+0>TYPECAR<+0><+0>LENGTHOF"
"DEALERCOST"
"<+0><+0><+0><+0><+0>"ON TABLE SET PAGE-NUM OFF

ON TABLE SET ONLINE-FMT PDF

ON TABLE SET HTMLCSS ON

ON TABLE SET STYLESHEET *

TYPE=REPORT, FONT='TIMES',SIZE=6, $

TYPE=REPORT, GRID=OFF,SQUEEZE=ON, $

TYPE=SUBHEAD, LINE=1,ITEM=1, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1, $
TYPE=SUBHEAD, LINE=3,ITEM=1, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1,$
TYPE=SUBHEAD, LINE=1,ITEM=2, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1, $
TYPE=SUBHEAD, LINE=3,ITEM=2, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1, $

TYPE=SUBHEAD, LINE=1,ITEM=3, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1,$
TYPE=SUBHEAD, LINE=3,ITEM=3, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1, $
TYPE=SUBHEAD, LINE=1,ITEM=4, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1,$
TYPE=SUBHEAD, LINE=3,ITEM=4, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1,$

TYPE=SUBHEAD, LINE=1,ITEM=5, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1,$
TYPE=SUBHEAD, LINE=3,ITEM=5, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1,$

TYPE=SUBHEAD, LINE=1,ITEM=5, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1,$
TYPE=SUBHEAD, LINE=3,ITEM=5, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1,$

TYPE=SUBHEAD, LINE=1,ITEM=6, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1,$
TYPE=SUBHEAD, LINE=3,ITEM=6, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1,$

TYPE=SUBHEAD, LINE=2,ITEM=1, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1,$
TYPE=SUBHEAD, LINE=4,ITEM=1, WIDTH=1.25, JUSTIFY=RIGHT,WRAP=1,$

-*TYPE=DATA,COLUMN=N3,WRAP=3,$

ENDSTYLE

END

USING OVER
-----------

-* File Detail1_hyp.fex

TABLE FILE CAR
PRINT
*
ON TABLE HOLD AS HLD1_DET
END

DEFINE FILE HLD1_DET
DUMMY/A3='';
END

TABLE FILE HLD1_DET
HEADING
"COUNTRY CAR NAME "
"SEATS MODEL"
" "
PRINT
COUNTRY AS ''
CAR AS ''
OVER
SEATS AS ''
MODEL AS ''
OVER
COMPUTE DUMMY/A1 = ' '; AS ''
WHERE RECORDLIMIT EQ 10
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=HEADING,HEADALIGN=BODY,$
TYPE=DATA,COLUMN=N1,WIDTH=0.70,JUSTIFY=LEFT,$
TYPE=DATA,COLUMN=N2,WIDTH=0.90,JUSTIFY=LEFT,$
TYPE=DATA,COLUMN=N3,WIDTH=0.70,JUSTIFY=LEFT,$
TYPE=DATA,COLUMN=N4,WIDTH=0.70,JUSTIFY=LEFT,$
TYPE=DATA,COLUMN=N5,WIDTH=0.70,JUSTIFY=LEFT,$
ENDSTYLE
END


Thanks!
Janani

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


WebFOCUS 7.6.9
Windows
Excel, HTML, PDF
 
Posts: 71 | Registered: April 17, 2009Report This Post
<JG>
posted
If you want to use over to do what you want then to get the alignment each vertically aligned verb object must be the same width with the exception of the dummy which is just used as a blank line

 
COUNTRY/A10 AS ''
CAR/A20 AS ''
OVER
SEATS/A10 AS ''
MODEL/A20 AS ''
OVER
COMPUTE DUMMY/A1 = ' '; AS ''
 
Report This Post
Jan1
Gold member
posted Hide Post
HI,

Iam trying to use subhead and display my report
but iam having issue with the alignment.
Please find the code below:


TABLE FILE CAR
BY COUNTRY NOPRINT
ON COUNTRY SUBHEAD
""" ON TABLE SUBHEAD
"CAR REPORT FORM BASED!"
" "
HEADING
""
"COUNTRY<+0> CAR<+0> MODEL<+0> BODYTYPE<+0> SEATS<+0> DEALER_COST"
"RETAIL_COST<+0> SALES <+0> LENGTH<+0> WIDTH<+0> HEIGHT<+0> "
" BHPVALUE"
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=SUBHEAD,
BY=1,
FONT='ARIAL',
JUSTIFY=LEFT,
WRAP=1,
$

ENDSTYLE
END

I Have three lines of headings. FOr example

Line1 heading :"
Line2 heading : "
Line 3 heading:"CAR
SALES
BHP

fRANCE
200
8

tHANKS!
jANANI


WebFOCUS 7.6.9
Windows
Excel, HTML, PDF
 
Posts: 71 | Registered: April 17, 2009Report This Post
<JG>
posted
Like I have already said your cells must all be the same width in any particular column
and as it's for PDF use positioning <+n> where n is the number of spaces that you need
 
TABLE FILE CAR
PRINT
     COUNTRY/A10 AS ''
     CAR/A20 AS ''
     OVER
     SEATS/A10 AS ''
     MODEL/A20 AS ''
     OVER
     COMPUTE DUMMY/A1 = ' '; AS ''
ON TABLE SUBHEAD
"COUNTRY<+7>CAR"
"SEATS<+9>MODEL"
ON TABLE PCHOLD FORMAT PDF
END
 
Report This Post
Jan1
Gold member
posted Hide Post
Hi ,

From the below code , iam trying to align the column with respective data.

To display car name below country , the last data W Germany needs to wrap.But it gets displayed as W alone , only if i increase the width i can see the data displayed.

This is one of the example am facing in the report since i need to display a 32 digit number ,it needs to wrap.

TABLE FILE CAR
BY COUNTRY NOPRINT

ON COUNTRY SUBHEAD
""HEADING
"Total Transfers To an outgoing Pharmacy"
"Column1<+0>Column2<+0>Column3<+0>Column4<+0>Column5<+0>Column6"
"Column7<+0>Column8<+0>Column9<+0>Column10<+0>Column11<+0>Column12"
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
FONT='ARIAL',
$

TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
FONT='ARIAL',
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
LINE=2,
ITEM=1,
POSITION='N1',
WRAP=1.000000,
JUSTIFY=CENTER,
WIDTH=1.000,
$
TYPE=HEADING,
LINE=2,
ITEM=2,
WRAP=1.000000,
JUSTIFY=CENTER,
WIDTH=1.000,
$
TYPE=HEADING,
LINE=2,
ITEM=3,
WRAP=1.000000,
JUSTIFY=CENTER,
WIDTH=1.000,
$
TYPE=HEADING,
LINE=2,
ITEM=4,
WRAP=1.000000,
JUSTIFY=CENTER,
WIDTH=1.000,
$
TYPE=HEADING,
LINE=2,
ITEM=5,
WRAP=1.000000,
JUSTIFY=CENTER,
WIDTH=1.000,
$
TYPE=HEADING,
LINE=2,
ITEM=6,
WRAP=1.000000,
JUSTIFY=CENTER,
WIDTH=1.000,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
FONT='ARIAL',
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
LINE=3,
ITEM=1,
POSITION='N1',
WRAP=1.000000,
JUSTIFY=CENTER,
WIDTH=1.000,
$
TYPE=HEADING,
LINE=3,
ITEM=2,
WRAP=1.000000,
JUSTIFY=CENTER,
WIDTH=1.000,
$
TYPE=HEADING,
LINE=3,
ITEM=3,
WRAP=1.000000,
JUSTIFY=CENTER,
WIDTH=1.000,
$
TYPE=HEADING,
LINE=3,
ITEM=4,
WRAP=1.000000,
JUSTIFY=CENTER,
WIDTH=1.000,
$
TYPE=HEADING,
LINE=3,
ITEM=5,
WRAP=1.000000,
JUSTIFY=CENTER,
WIDTH=1.000,
$
TYPE=HEADING,
LINE=3,
ITEM=6,
WRAP=1.000000,
JUSTIFY=CENTER,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=1,
ITEM=1,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
WRAP=2.000000,
JUSTIFY=LEFT,
WIDTH=2.000000,
COLOR=RED,
$
TYPE=SUBHEAD,
BY=1,
LINE=1,
ITEM=2,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
WRAP=1.000000,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=1,
ITEM=3,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
WRAP=1.000000,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=1,
ITEM=4,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
WRAP=1.000000,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=1,
ITEM=5,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
WRAP=1.000000,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=1,
ITEM=6,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
WRAP=1.000000,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=2,
ITEM=1,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
WRAP=1.000000,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=2,
ITEM=2,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
WRAP=1.000000,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=2,
ITEM=3,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
WRAP=1.000000,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=2,
ITEM=4,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
WRAP=1.000000,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=2,
ITEM=5,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
WRAP=1.000000,
JUSTIFY=LEFT,
WIDTH=1.000,
$
TYPE=SUBHEAD,
BY=1,
LINE=2,
ITEM=6,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
WRAP=1.000000,
JUSTIFY=LEFT,
WIDTH=1.000,
$
ENDSTYLE
END


WebFOCUS 7.6.9
Windows
Excel, HTML, PDF
 
Posts: 71 | Registered: April 17, 2009Report This Post
Jan1
Gold member
posted Hide Post
Also i need the above report with grids.


WebFOCUS 7.6.9
Windows
Excel, HTML, PDF
 
Posts: 71 | Registered: April 17, 2009Report This Post
Jan1
Gold member
posted Hide Post
Hi,

I did not get the wrap issue resolved.It is similar to the given link which was posted after mine.Please refer to http://forums.informationbuild...=951108701#951108701.

Also are can the grids be implemented?.Have tried using GRID=ON,but does not work teh right way.

Thanks,
Janani


WebFOCUS 7.6.9
Windows
Excel, HTML, PDF
 
Posts: 71 | Registered: April 17, 2009Report This Post
<JG>
posted
Why do you keep demanding answers?

The forum is a place where people help if the can.
It is not a place to get free consultancy.

Have you raised a case with Information Builders Tech support?

Do a search on PDF and GRID and look at the online help, you will get plenty of possible answers.
 
Report This Post
Jan1
Gold member
posted Hide Post
Thanks for the reply!


WebFOCUS 7.6.9
Windows
Excel, HTML, PDF
 
Posts: 71 | Registered: April 17, 2009Report 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] Column heading to appear in 2 or 3 line

Copyright © 1996-2020 Information Builders