[CLOSED] HTML5 data grid chart: Trouble changing column header color and font

November 08, 2019, 04:03 PM

Hey, WebFocus noob here. I'm trying to build a simple KPI file that simply has the measure title and the measure below it. I originally built it using a tablular report format but it didn't provide what I needed once I put it on a portal.

The HTML5 data grid could could do what I need but I can't seem to style the column header. I'm aware you can't apply WF styling to it, so I'm following the instructions here and here.

I have this code in the fex file:

 dataGridProperties: {
	colHeader: {
		sorting: {enabled:false},
		fill: '#043B56',
		title: {color: '#FFFFFF'}
	}
}

It's giving me the blue filled header as it should, but it's not changing the title color to white. I'm also not able to change the default font from "Sans Serif" to something else, that completely errors out.

Does anyone have experience with this that can tell me what I'm overlooking?

This message has been edited. Last edited by: FP Mod Chuck,

November 08, 2019, 08:23 PM

Hallway

Hi kds! Welcome to the forum. 😁

One thing that will help us, help you, is if you can replicate the issues that you are seeing using the CAR file or some other dataset from the ibisamp folder, and post the code in it's entirety. This will enable us to be able run the code and see what you are seeing.

November 11, 2019, 08:01 AM

MartinY

ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
SET HTMLENCODE=ON
SET ARGRAPHENGINE=JSCHART
SET EMBEDHEADING=ON
SET GRAPHDEFAULT=OFF

GRAPH FILE GGSALES
SUM DOLLARS/P9C AS '$'
BY PRODUCT      AS 'Product'
BY REGION       AS ''

ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET HAXIS 600.0
ON GRAPH SET VAXIS 200.0
ON GRAPH SET LOOKGRAPH DATAGRID
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
setPlace(true);
setUseSeriesShapes(true);
*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$

TYPE=DATA, COLUMN=N1, BUCKET=row, $
TYPE=DATA, COLUMN=N2, BUCKET=column, $
TYPE=DATA, COLUMN=N3, BUCKET=measure, $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
*END
*GRAPH_JS
dataGridProperties: {
   cell: {layout: {width: {rule: 'minSize', value: 100}}}
}
*END
*GRAPH_JS_FINAL
dataGridProperties: {
 colHeader: {
      fill: '#043B56', 
      labels: {font: 'bold 12pt Sans-Serif', color: 'white'},
      lastLabels: {font: 'bold 12pt Sans-Serif', color: 'white'}
 } 
}
*END
ENDSTYLE
END
-RUN