Why does column heard repeat it self at every expansion? For example:
+ Division +DISTRICT A

DIVISION +DISTRICT B

DIVISION

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

TABLE FILE AGG_ENROLLMENT
SUM
'AGG_ENROLLMENT.AGG_ENROLLMENT.ENROLLED'
BY 'J1.DIM_SCHOOL.DIVISIONNAME'
BY 'J1.DIM_SCHOOL.DISTRICTNAME'
BY 'J1.DIM_SCHOOL.BRAND'
BY 'J1.DIM_SCHOOL.SCHOOLID'
ACROSS 'J0.DIM_TIME.WEEK'
HEADING
""
FOOTING
""
WHERE ( J0.DIM_TIME.FISCALYEAR EQ &FISCALYEAR.(FIND DIM_TIME.DIM_TIME.FISCALYEAR,DIM_TIME.DIM_TIME.FISCALYEAR IN dim_time).FISCALYEAR. ) AND ( J0.DIM_TIME.PERIOD EQ &PERIOD.(FIND DIM_TIME.DIM_TIME.PERIOD,DIM_TIME.DIM_TIME.PERIOD IN dim_time).PERIOD. );
WHERE READLIMIT EQ 1000
WHERE RECORDLIMIT EQ 1000
ON TABLE SET PAGE-NUM ON
ON TABLE SET EXPANDABLE ON
ON TABLE SUMMARIZE AGG_ENROLLMENT.AGG_ENROLLMENT.ENROLLED AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=ON,
FONT='ARIAL',
SIZE=9,
LINES-PER-PAGE=20,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
ENDSTYLE
END

Hi Arif,

Not sure if this is exactly what you are asking about, but IF you would like to see the BYFIELD on every line, please try to add ON TABLE SET BYDISPLAY ON

Within a vertical sort group, the sort field value displays only on the first line of the rows for its sort group. However, using the SET BYDISPLAY command, you can display the appropriate BY field on every row of a report produced in a styled output format.

ON TABLE SET BYDISPLAY {OFF|ON}

where:

OFF
Displays a BY field value only on the first line of the report output for the sort group. OFF is the default value.

ON
Displays the associated BY field value on every line of report output produced in a styled format.

If you are reporting an issue, please open a case with Information Builders' Customer Support Services. You may either call 1-800-736-6130, or access online InfoResponse.

Cheers,

Kerry