Hi All,

Iam trying to do a conditional stylling for AHTML report.It is applying perfectly for HTML and Excel formats.AHTML it is not applying.Any help/Suggestions greatley appretiated.Please find the below code.The filter date conditions are dynamic.

TABLE FILE DAILYOS
SUM
RCTDSB_SMRY_A/P13.2CB AS 'Cash, OS'
STORE_STAT_C
BY GROUP AS 'Group'
BY DISTRICT AS 'District'
BY STORE_I AS 'Store, Number'
BY STORE_N AS 'Store Name'
BY ST_C AS 'State'
BY THRESH AS 'Store,Threshold'
BY REG_THRESH AS 'Register, Threshold'
BY AUDITOR
BY FYR AS 'Fiscal,Year'
BY FMO AS 'Fiscal,Month'
BY MTD_OS AS 'Month To, Date O/S'
ACROSS HIGHEST SLS_D AS 'Sales Date'
WHERE (SLS_D GT '&OLD_DT' AND SLS_D LT '&TODAY');
HEADING
"Total Cash O/S Report"
"Sales Date Range From &OLD_DT to &TODAY"
ON TABLE PCHOLD FORMAT AHTML
ON TABLE SET PAGE-NUM OFF
ON TABLE SET BYDISPLAY ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
TITLETEXT='Total Cash OS',
$
DEFMACRO=UNAUD,
MACTYPE=RULE,
WHEN=N13 EQ '01',
$
DEFMACRO=INPROC,
MACTYPE=RULE,
WHEN=N13 EQ '02',
$
DEFMACRO=AUD,
MACTYPE=RULE,
WHEN=N13 EQ '03',
$
DEFMACRO=SYS,
MACTYPE=RULE,
WHEN=N13 EQ '04',
$
DEFMACRO=NEGOS,
MACTYPE=RULE,
WHEN=N12 LT 0,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=8,
COLOR='BLACK',
BACKCOLOR='NONE',
HEADALIGN=BODY,
$
TYPE=TITLE,
FONT='ARIAL',
SIZE=8,
BORDER=LIGHT,
BORDER-COLOR=BLACK,
BACKCOLOR=RGB(153 153 153),
STYLE=-UNDERLINE+BOLD,
COLOR=BLACK,
JUSTIFY=CENTER,
$
TYPE=DATA,
FONT='ARIAL',
SIZE=8,
BACKCOLOR=( 'WHITE' RGB(240 240 240) ),
COLOR=BLACK,
BORDER=LIGHT,
BORDER-COLOR=BLACK,

$
TYPE=DATA,
ACROSSCOLUMN=N1,
BACKCOLOR=RGB(255 153 204),
MACRO=UNAUD,
$
TYPE=DATA,
ACROSSCOLUMN=N1,
BACKCOLOR=RGB(255 153 204),
MACRO=INPROC,
$
TYPE=DATA,
ACROSSCOLUMN=N1,
BACKCOLOR=RGB(255 255 153),
MACRO=AUD,
$
TYPE=DATA,
ACROSSCOLUMN=N1,
BACKCOLOR=RGB(204 255 204),
MACRO=SYS,
$
TYPE=DATA,
ACROSSCOLUMN=N1,
COLOR='RED',
MACRO=NEGOS,
$

TYPE=ACROSSTITLE,
FONT='ARIAL',
SIZE=8,
BORDER=LIGHT,
BORDER-COLOR=BLACK,
BACKCOLOR=RGB(153 153 153),
STYLE=-UNDERLINE+BOLD,
COLOR=BLACK,
JUSTIFY=CENTER,
$
ENDSTYLE
END
-RUN
-EXIT

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

Consider using the actual field name instead of the "N##" notation.

quote:

WHEN=N13 EQ '01',

Hi Dough Thank you for your inputs.I have tried giving actual filed Name it will work fine in HTML format but not in AHTML.The across dates are not static filters.

TABLE FILE CAR
SUM SALES
ACROSS HIGHEST COUNTRY
BY MODEL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ONLINE-FMT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT,
BORDER=LIGHT,
FONT='ARIAL',
SIZE=8,
$
TYPE=DATA,
ACROSSCOLUMN=N1,
STYLE=NORMAL,
COLOR=RED,
WHEN=N2 GT 0,
$
END

how can we achieve the same styling in an AHTML report? I used the above code by just replacing HTML with AHTML and it completely removed the styling.