I just used the GUI to build a quick WF8 report...my first in some time. It has depts going down the side and months going across the top. It shows Chgs/Pmts etc.

No matter what I do its automatically wrapping and making the column as skinny as it possible can.

Further, I added a Page Heading and it never shows on the run report. I have tried HTML and Excel...does not matter.

TABLE FILE TBLMSTR_MIXDETAIL
SUM
TBLMSTR_MIXDETAIL.TBLMSTR_MIXDETAIL.ADJUSTMENTS/D12 AS 'Total Adjs'
TBLMSTR_MIXDETAIL.TBLMSTR_MIXDETAIL.ADMINISTRATIVE/D20 AS 'Administrative'
TBLMSTR_MIXDETAIL.TBLMSTR_MIXDETAIL.BADDEBTWRITEOFF/D20 AS 'BadDebt WriteOff'
TBLMSTR_MIXDETAIL.TBLMSTR_MIXDETAIL.CAPITATION/D20 AS 'Capitation'
TBLMSTR_MIXDETAIL.TBLMSTR_MIXDETAIL.CHARITY/D20 AS 'Charity'
TBLMSTR_MIXDETAIL.TBLMSTR_MIXDETAIL.CONTRACTUAL/D20 AS 'Contractual'
TBLMSTR_MIXDETAIL.TBLMSTR_MIXDETAIL.DISCOUNT/D20 AS 'Discount'
TBLMSTR_MIXDETAIL.TBLMSTR_MIXDETAIL.PLBADJUSTMENT/D20 AS 'PLB Adjustment'
TBLMSTR_MIXDETAIL.TBLMSTR_MIXDETAIL.QUALITYDEBIT/D20 AS 'Quality Debit'
TBLMSTR_MIXDETAIL.TBLMSTR_MIXDETAIL.REFUND/D20 AS 'Refund'
TBLMSTR_MIXDETAIL.TBLMSTR_MIXDETAIL.RESEARCH/D20 AS 'Research'
TBLMSTR_MIXDETAIL.TBLMSTR_MIXDETAIL.PAYMENTREVERSAL/D20 AS 'Pmt Reversal'
TBLMSTR_MIXDETAIL.TBLMSTR_MIXDETAIL.OTHER/D20 AS 'Other'
BY TBLMSTR_MIXDETAIL.TBLMSTR_MIXDETAIL.RPTBANBR AS 'BaNbr'
BY TBLMSTR_MIXDETAIL.TBLMSTR_MIXDETAIL.RPTBANAME AS 'BaName'
ACROSS LOWEST TBLMSTR_MIXDETAIL.TBLMSTR_MIXDETAIL.PERIOD AS ' '


HEADING
"Cost Center Trend"


WHERE ( TBLMSTR_MIXDETAIL.TBLMSTR_MIXDETAIL.FISCALYEAR EQ &FISCALYEAR.(FIND TBLMSTR_MIXDETAIL.TBLMSTR_MIXDETAIL.FISCALYEAR,TBLMSTR_MIXDETAIL.TBLMSTR_MIXDETAIL.FISCALYEAR IN TBLMSTR_MIXDETAIL).FISCALYEAR:. ) AND ( TBLMSTR_MIXDETAIL.TBLMSTR_MIXDETAIL.RPTBANBR EQ '&RPTBANBR' );


ON TABLE SET PAGE-NUM NOLEAD
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
TYPE=REPORT,
LINES-PER-PAGE=20,
ARGRAPHENGINE=JSCHART,
ALLOW-TOOLS=OFF,
$
TYPE=DATA,
COLUMN=N1,
STYLE=BOLD,
$
TYPE=DATA,
COLUMN=N2,
STYLE=BOLD,
$
TYPE=DATA,
COLUMN=N20,
BORDER-RIGHT=LIGHT,
$
TYPE=DATA,
ACROSSCOLUMN=N1,
STYLE=BOLD,
$
TYPE=DATA,
ACROSSCOLUMN=N2,
STYLE=BOLD,
$
TYPE=DATA,
ACROSSCOLUMN=N3,
STYLE=BOLD,
$
TYPE=DATA,
ACROSSCOLUMN=N4,
STYLE=BOLD,
$
TYPE=DATA,
ACROSSCOLUMN=N5,
STYLE=BOLD,
$
TYPE=DATA,
ACROSSCOLUMN=N6,
STYLE=BOLD,
$
TYPE=DATA,
ACROSSCOLUMN=N7,
STYLE=BOLD,
$
TYPE=DATA,
ACROSSCOLUMN=N8,
STYLE=BOLD,
$
TYPE=DATA,
ACROSSCOLUMN=N9,
STYLE=BOLD,
$
TYPE=DATA,
ACROSSCOLUMN=N10,
STYLE=BOLD,
$
TYPE=DATA,
ACROSSCOLUMN=N11,
STYLE=BOLD,
$
TYPE=DATA,
ACROSSCOLUMN=N12,
STYLE=BOLD,
$
TYPE=DATA,
ACROSSCOLUMN=N13,
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N1,
BACKCOLOR=RGB(153 204 255),
$
TYPE=TITLE,
COLUMN=N2,
BACKCOLOR=RGB(153 204 255),
$
TYPE=TITLE,
ACROSSCOLUMN=N1,
BACKCOLOR=RGB(153 204 255),
$
TYPE=TITLE,
ACROSSCOLUMN=N2,
BACKCOLOR=RGB(153 204 255),
$
TYPE=TITLE,
ACROSSCOLUMN=N3,
BACKCOLOR=RGB(153 204 255),
$
TYPE=TITLE,
ACROSSCOLUMN=N4,
BACKCOLOR=RGB(153 204 255),
$
TYPE=TITLE,
ACROSSCOLUMN=N5,
BACKCOLOR=RGB(153 204 255),
$
TYPE=TITLE,
ACROSSCOLUMN=N6,
BACKCOLOR=RGB(153 204 255),
$
TYPE=TITLE,
ACROSSCOLUMN=N7,
BACKCOLOR=RGB(153 204 255),
$
TYPE=TITLE,
ACROSSCOLUMN=N8,
BACKCOLOR=RGB(153 204 255),
$
TYPE=TITLE,
ACROSSCOLUMN=N9,
BACKCOLOR=RGB(153 204 255),
$
TYPE=TITLE,
ACROSSCOLUMN=N10,
BACKCOLOR=RGB(153 204 255),
$
TYPE=TITLE,
ACROSSCOLUMN=N11,
BACKCOLOR=RGB(153 204 255),
$
TYPE=TITLE,
ACROSSCOLUMN=N12,
BACKCOLOR=RGB(153 204 255),
$
TYPE=TITLE,
ACROSSCOLUMN=N13,
BACKCOLOR=RGB(153 204 255),
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=16,
$
TYPE=ACROSSVALUE,
ACROSS=1,
BACKCOLOR='WHITE',
$
TYPE=ACROSSTITLE,
ACROSS=1,
BORDER-TOP=OFF,
$
TYPE=GRANDTOTAL,
BACKCOLOR='NAVY',
$
TYPE=REPORT,
ACROSSCOLUMN=N5,
SQUEEZE=ON,
$
TYPE=REPORT,
ACROSSCOLUMN=N10,
SQUEEZE=ON,
$
ENDSTYLE
END

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

Duh--the page heading was centered...need to scroll over to see it. I still can not format the column widths though no matter what I try.

Hi Robert,

Which GUI tool did you use to create the report? Which release of WebFOCUS 8 are you running?

Thanks and regards,

Kathryn