Hello,
I noticed then when in the across I use only one sum value the style in not applied.
Like you can see here:



When I add another sum value works fine.

I think this is a bug. Is there any workaround?

Thanks,
Carlos Dias

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

It always helps if you show your code ...

You are right GamP.
Here is the code:

  
JOIN
 F_NWI_EQUIP_COD_STAR.D_ENTITY_NWI_EQUIP_COD.EQUIP_COD
 AND F_NWI_EQUIP_COD_STAR.D_ENTITY_NWI_EQUIP_COD.EQUIP_MODEL IN
F_NWI_EQUIP_COD_STAR TO MULTIPLE
 D_ENTITY_NWI_LV_PORT_TYPE.D_ENTITY_NWI_LV_PORT_TYPE.EQUIP_COD
 AND D_ENTITY_NWI_LV_PORT_TYPE.D_ENTITY_NWI_LV_PORT_TYPE.EQUIP_MODEL
 IN D_ENTITY_NWI_LV_PORT_TYPE TAG J1 AS J1
END

JOIN
 J1.D_ENTITY_NWI_LV_PORT_TYPE.ENTITY_KEY IN F_NWI_EQUIP_COD_STAR TO MULTIPLE
 F_NWI_LV_PORT_TYPE_ADD.F_NWI_LV_PORT_TYPE_ADD.ENTITY_KEY
 IN F_NWI_LV_PORT_TYPE_ADD TAG J2 AS J2
END

TABLE FILE F_NWI_EQUIP_COD_STAR
SUM
     J2.F_NWI_LV_PORT_TYPE_ADD.NUM_PORTS AS 'Num. Portos'
BY  LOWEST F_NWI_EQUIP_COD_STAR.D_ENTITY_NWI_EQUIP_COD.EQUIP_COD AS 'Sigla Nó'
BY  LOWEST F_NWI_EQUIP_COD_STAR.D_ENTITY_NWI_EQUIP_COD.EQUIP_MODEL AS 'Tipo Equipamento'
BY  LOWEST F_NWI_EQUIP_COD_STAR.D_ENTITY_NWI_EQUIP_COD.HIER_LEVEL AS 'Nível Hierarquico'
BY  F_NWI_EQUIP_COD_STAR.F_NWI_EQUIP_COD_ADD.NUM_FREE_SLOTS AS 'Slots Livres'
ACROSS LOWEST J1.D_ENTITY_NWI_LV_PORT_TYPE.HIER_LEVEL_TYPE AS 'Interfaces de interligação'
ACROSS J1.D_ENTITY_NWI_LV_PORT_TYPE.PORT_TYPE AS ''
WHERE F_NWI_EQUIP_COD_STAR.D_TIME.YEAR EQ &year;
WHERE F_NWI_EQUIP_COD_STAR.D_TIME.MONTH EQ &month;
WHERE F_NWI_EQUIP_COD_STAR.D_TIME.DAY_OF_MONTH EQ &day;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE HOLD AS RESULT FORMAT &WFFMT
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *

Style file:

  
TYPE=REPORT,
     COLOR='BLACK',
     FONT='VERDANA',
     UNITS=IN,
     SIZE=7,
     SQUEEZE=ON,
  GRID=ON,
     PAGESIZE='A4',
$
TYPE=REPORT,
     LINES-PER-PAGE=UNLIMITED,
     ALLOW-FREEZE=OFF,
     ALLOW-HIDE=OFF,
     ALLOW-EXPORT=OFF,
     ALLOW-ROLLUP=OFF,
     ALLOW-COMMENTS=OFF,
     ALLOW-WINDOW=OFF,
     ALLOW-SENDEMAIL=OFF,
     ALLOW-SAVECHANGE=OFF,
     ALLOW-PRINT=OFF,
     ALLOW-ACCORDION=OFF,
     ALLOW-GRID=OFF,
$
TYPE=REPORT,
     OBJECT=STATUS-AREA,
     JUSTIFY=RIGHT,
     PAGE-LOCATION=TOP,
     COLOR='WHITE',
     BACKCOLOR=RGB(115 150 191), 
$
TYPE=REPORT,
     OBJECT=MENU,
     COLOR='WHITE',
     HOVER-COLOR=RGB(51 51 51),
     BACKCOLOR=RGB(115 150 191),
     HOVER-BACKCOLOR='GRAY',
     BORDER-COLOR='SILVER',
$
TYPE=REPORT,
    OBJECT=CURRENT-ROW,
    HOVER-BACKCOLOR=RGB(200 200 200),
 BACKCOLOR=RGB(193 203 222),
$
TYPE=HEADING,
     LINE=1,
     COLOR=RGB(84 118 178),
     STYLE=BOLD,
     JUSTIFY=CENTER,
$
TYPE=FOOTING,
     LINE=1,
     JUSTIFY=RIGHT,
$
TYPE=TITLE,
     style=bold,
     COLOR='WHITE',
     BACKCOLOR=RGB(115 150 191),
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-COLOR=RGB(200 200 200),
     BORDER-BOTTOM-COLOR=RGB(200 200 200),
     BORDER-LEFT-COLOR=RGB(200 200 200),
     BORDER-RIGHT-COLOR=RGB(200 200 200),
$
type=data,
     COLOR='BLACK',
     BACKCOLOR=( 'WHITE' RGB(233 233 233) ),
     BORDER-STYLE=RIDGE,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-COLOR=RGB(200 200 200),
     BORDER-BOTTOM-COLOR=RGB(200 200 200),
     BORDER-LEFT-COLOR=RGB(200 200 200),
     BORDER-RIGHT-COLOR=RGB(200 200 200),
 
$
TYPE=ACROSSVALUE,
     style=bold,
     COLOR='WHITE',
     BACKCOLOR=RGB(115 150 191),
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-COLOR=RGB(200 200 200),
     BORDER-BOTTOM-COLOR=RGB(200 200 200),
     BORDER-LEFT-COLOR=RGB(200 200 200),
     BORDER-RIGHT-COLOR=RGB(200 200 200),
$
TYPE=ACROSSTITLE,
     style=bold,
     COLOR='WHITE',
     BACKCOLOR=RGB(115 150 191),
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-TOP-COLOR=RGB(200 200 200),
     BORDER-BOTTOM-COLOR=RGB(200 200 200),
     BORDER-LEFT-COLOR=RGB(200 200 200),
     BORDER-RIGHT-COLOR=RGB(200 200 200),
$

If I add another column in SUM works fine.

Thanks,
Carlos Dias

I think it's a bug. It works fine if you select HTML as output, but with AHTML it seems to default back to some internal styling.
There is a workaround: just add a second field in the SUM part, but specify NOPRINT for that field. Only thing then is that you will see that field in the Pivot submenu of the active report...
I'd open a case with IB Tech support to see if there is another possible solution for this.