Is there an easy (GUI) way of formatting this report in PDF so it aligns correctly? looks great in html & xls.

DEFINE FILE CAR
r1c1/D12=125;
r1c2/D12.2=126;
r1c3/D12=23;
r1c4/D12.2=1268;
r1c5/D12.2=635.15;

r2c1/D12=526;
r2c2/D12.2=9954;
r2c3/D12=238;
r2c4/D12.2=12680;
r2c5/D12.2=6355.15;


row3column1/D12=349;
row3column2/D12=567;
row3column3/D12=1234959;
row3column4/D12=35;
row4column5/D12=4566;



END
TABLE FILE CAR
SUM
r1c1
r1c2
r1c3
r1c4
r1c5 OVER
r2c1
r2c2
r2c3
r2c4
r2c5 OVER
row3column1
row3column2
row3column3
row3column4
row3column5
ACROSS LOWEST CAR.ORIGIN.COUNTRY
WHERE CAR.ORIGIN.COUNTRY EQ 'ENGLAND';
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
PAGESIZE='Ledger',
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
WRAP=1.250000,
$
ENDSTYLE
END



----a solution that I think is not supportable in our environment--------



DEFINE FILE CAR
All/A3=IF MODEL EQ MODEL THEN '*' ELSE '*';
END

TABLE FILE CAR
SUM
COMPUTE Counter/D8 = Counter + 1;
BY CAR.CARREC.MODEL
BY CAR.CARREC.All

ON TABLE HOLD AS TEMPCTR FORMAT FOCUS INDEX 'All'
END
DEFINE FILE CAR
All/A3=IF MODEL EQ MODEL THEN '*' ELSE '*';

r1c1/D12=125;
r1c2/D12.2=126;
r1c3/D12=23;
r1c4/D12.2=1268;
r1c5/D12.2=635.15;
r2c1/D12=526;
r2c2/D12.2=9954;
r2c3/D12=238;
r2c4/D12.2=12680;
r2c5/D12.2=6355.15;
row3column1/D12=349;
row3column2/D12=567;
row3column3/D12=1234959;
row3column4/D12=35;
row3column5/D12=4566;

END
TABLE FILE CAR
PRINT
r1c1
r1c2
r1c3
r1c4
r1c5
r2c1
r2c2
r2c3
r2c4
r2c5
row3column1
row3column2
row3column3
row3column4
row3column5
BY CAR.CARREC.All
WHERE CAR.ORIGIN.COUNTRY EQ 'ENGLAND';
ON TABLE HOLD AS TEMPCAR FORMAT FOCUS INDEX 'All'
END
JOIN
LEFT_OUTER TEMPCAR.SEG01.All IN TEMPCAR TO MULTIPLE TEMPCTR.SEG01.All
IN TEMPCTR TAG J0 AS J0
END
DEFINE FILE TEMPCAR
Column1/D12=
IF J0.SEG01.Counter EQ 1 THEN TEMPCAR.SEG01.r1c1 ELSE
IF J0.SEG01.Counter EQ 2 THEN TEMPCAR.SEG01.r2c1 ELSE
IF J0.SEG01.Counter EQ 3 THEN TEMPCAR.SEG01.row3column1 ELSE 0;
Column2/D12=
IF J0.SEG01.Counter EQ 1 THEN TEMPCAR.SEG01.r1c2 ELSE
IF J0.SEG01.Counter EQ 2 THEN TEMPCAR.SEG01.r2c2 ELSE
IF J0.SEG01.Counter EQ 3 THEN TEMPCAR.SEG01.row3column2 ELSE 0;
Column3/D12=
IF J0.SEG01.Counter EQ 1 THEN TEMPCAR.SEG01.r1c3 ELSE
IF J0.SEG01.Counter EQ 2 THEN TEMPCAR.SEG01.r2c3 ELSE
IF J0.SEG01.Counter EQ 3 THEN TEMPCAR.SEG01.row3column3 ELSE 0;
Column4/D12=
IF J0.SEG01.Counter EQ 1 THEN TEMPCAR.SEG01.r1c4 ELSE
IF J0.SEG01.Counter EQ 2 THEN TEMPCAR.SEG01.r2c4 ELSE
IF J0.SEG01.Counter EQ 3 THEN TEMPCAR.SEG01.row3column4 ELSE 0;
Column5/D12=
IF J0.SEG01.Counter EQ 1 THEN TEMPCAR.SEG01.r1c5 ELSE
IF J0.SEG01.Counter EQ 2 THEN TEMPCAR.SEG01.r2c5 ELSE
IF J0.SEG01.Counter EQ 3 THEN TEMPCAR.SEG01.row3column5 ELSE 0;
END
TABLE FILE TEMPCAR
BY LOWEST J0.SEG01.Counter
BY LOWEST J0.SEG01.Column1
BY LOWEST J0.SEG01.Column2
BY LOWEST J0.SEG01.Column3
BY LOWEST J0.SEG01.Column4
BY LOWEST J0.SEG01.Column5
BY TOTAL LOWEST COMPUTE Column6/A6 = IF Counter EQ 1 THEN 'R1C6' ELSE
IF Counter EQ 2 THEN 'R2C6' ELSE
IF Counter EQ 3 THEN 'R3C6' ELSE '';
BY TOTAL LOWEST COMPUTE Profit/D12= Column1-Column2;
WHERE J0.SEG01.Counter LE 3;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END

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

The clue might be here: http://infocenter.informationb...om/wf81rel/index.jsp (search for "Controlling Wrapping of Report Data").

Documentation > Creating Reports With WebFOCUS Language > Formatting Report Data > Positioning Data in a Report > Controlling Wrapping of Report Data > OVER and WRAP With Non-Blank Column Titles

WRAP OVER - isn't that what Donald Trump has?



T

thanks Francis,

Using OVER and WRAP With Column Titles

Solution is to define virtual fields for the column titles and give both the title and data a blank AS name.

DEFINE FILE CAR

r1c1/D12=125;
r1c2/D12.2=126;
r1c3/D12=23;


r2c1/D12=526;
r2c2/D12.2=9954;
r2c3/D12=238;

r3c1/D12=5426;
r3c2/D12.2=94954;
r3c3/D12=2348;



Tr1c1/A125='r1c1';
Tr1c2/A125='r1c2';
Tr1c3/A125='r1c3';


Tr2c1/A125='r2c1';
Tr2c2/A125= 'r2c2';
Tr2c3/A125='r2c3';

Tr3c1/A125='r3c1- longer name';
Tr3c2/A125= 'r3c2 - longer name';
Tr3c3/A125='r3c3-longer name';



END
TABLE FILE CAR
SUM
Tr1c1 AS ''
r1c1 AS ''
Tr1c2 AS ''
r1c2 AS ''
Tr1c3 AS ''
r1c3 AS '' OVER
Tr2c1 AS ''
r2c1 AS ''
Tr2c2 AS ''
r2c2 AS ''
Tr2c3 AS ''
r2c3 AS '' OVER
Tr3c1 AS ''
r3c1 AS ''
Tr3c2 AS ''
r3c2 AS ''
Tr3c3 AS ''
r3c3 AS ''
ACROSS LOWEST CAR.ORIGIN.COUNTRY
WHERE CAR.ORIGIN.COUNTRY EQ 'ENGLAND';
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
PAGESIZE='Ledger',
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
WRAP=1.250000,
$
ENDSTYLE
END

I LOVE Cognos

Janet, yes, it's a bit painful. But it's probably even more painful trying to do it in the GUI.