Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Accordian Reports
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Accordian Reports
 Login/Join
 
Guru
posted
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,


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Reply With QuoteReport This Post
Guru
posted Hide Post
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


WebFOCUS 7.6.10
Windows
HTML
 
Posts: 294 | Registered: March 04, 2010Reply With QuoteReport This Post
Expert
posted Hide Post
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


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1950 | Location: New York | Registered: November 16, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Accordian Reports

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.