Hi,
Am creating matrix report(PDF) with single BY and ACROSS columns. Here, the BY column is displaying value only in the 1st page when the report goes to multiple pages. Is there any way to display the BY column values at all pages of the report

below is the sample code i used..


SET NODATA = ''
SET BYDISPLAY = ON

TABLE FILE CAR
SUM SALES AS ''
BY COUNTRY AS ''
ACROSS CAR AS ''
WHERE SALES NE 0;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE COLUMN-TOTAL AS ''
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
$
TYPE=REPORT,
GRAPHCOLOR='GREEN',
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=9,
$
TYPE=DATA,
COLUMN=N1,
BORDER-RIGHT=LIGHT,
FONT='ARIAL',
SIZE=9,
$
TYPE=DATA,
ACROSSCOLUMN=N1,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
COLUMN=N1,
BORDER-RIGHT=LIGHT,
FONT='ARIAL',
SIZE=9,
$
TYPE=TITLE,
ACROSSCOLUMN=N1,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
$
TYPE=ACROSSVALUE,
ACROSS=1,
BACKCOLOR='WHITE',
WRAP=ON,
$
TYPE=ACROSSVALUE,
ACROSS=1,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR='SILVER',
JUSTIFY=RIGHT,
$
TYPE=GRANDTOTAL,
COLUMN=COUNTRY,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=OFF,
BORDER-RIGHT=LIGHT,
BACKCOLOR='WHITE',
JUSTIFY=RIGHT,
$
TYPE=GRANDTOTAL,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
BACKCOLOR='SILVER',
JUSTIFY=RIGHT,
$
TYPE=REPORT,
OBJECT=MENU,
COLOR='WHITE',
HOVER-COLOR=RGB(66 70 73),
BACKCOLOR=RGB(102 102 102),
HOVER-BACKCOLOR=RGB(218 225 232),
BORDER-COLOR='WHITE',
$
TYPE=REPORT,
OBJECT=STATUS-AREA,
COLOR='WHITE',
BACKCOLOR=RGB(102 102 102),
$
TYPE=REPORT,
OBJECT=CURRENT-ROW,
HOVER-BACKCOLOR=RGB(218 225 232),
BACKCOLOR=RGB(200 200 200),
$
TYPE=REPORT,
OBJECT=CALC-AREA,
COLOR='WHITE',
BACKCOLOR=RGB(102 102 102),
$
TYPE=REPORT,
COLUMN=N2,
FONT='ARIAL',
SIZE=9,
SQUEEZE=1.055556,
$
TYPE=REPORT,
ACROSSCOLUMN=N1,
SQUEEZE=0.555556,
$
ENDSTYLE
END

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

You have to limit the width of your report ...

Thanks MichaelBalle..

I just have given sample code for example.. In real, the number of across columns go more than 50.. So, when it goes to next pages the same BY column values needs to be printed in all the pages.. Is there any other idea to get it?

Thanks,
Mathan.S

Take a look at HEADPANEL attribute. It may give you a clue.

All you need is:-
ON TABLE SET BYPANEL ON
after the:-
ON TABLE SET PAGE-NUM NOLEAD
statement and should work fine.

Thanks All..

Finally "ON TABLE SET BYPANEL ON" or "SET BYPANEL = ON" re giving me expected result..

Thanks,
Mathan.S