In the below graph , is there a way to show only the car where there is data, example in the first graph only show jaguar,jensen and triumph on x-axis.Not the others without data.

Similary in graph 2 only show pugeot.

  
SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=IN, $
SECTION=section1, LAYOUT=ON, METADATA='0.5^0.5^0.5^0.5^1', MERGE=ON, ORIENTATION=PORTRAIT, PAGESIZE=Letter,  $
PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='graph1', TEXT='graph1', TOC-LEVEL=2, POSITION=(1.458 0.833), DIMENSION=(5.621 4.269), METADATA='Z-INDEX: 100; LEFT: 1.458in; WIDTH: 5.621in; POSITION: absolute; TOP: 0.833in; HEIGHT: 4.269in', $
COMPONENT='report1', TEXT='report1', TOC-LEVEL=2, POSITION=(0.624 5.625), DIMENSION=(7.294 2.083), METADATA='Z-INDEX: 100; LEFT: 0.624in; OVERFLOW: auto; WIDTH: 7.294in; POSITION: absolute; TOP: 5.625in; HEIGHT: 2.083in', $
END
SET COMPONENT='graph1'
-*component_type graph
GRAPH FILE CAR
SUM CAR.BODY.RETAIL_COST
ACROSS CAR.COMP.CAR
BY CAR.ORIGIN.COUNTRY
-* ###### Commented out BY CAR.COMP.CAR
HEADING
"<CAR.ORIGIN.COUNTRY "
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET VAXIS 4.269
ON GRAPH SET HAXIS 5.621
ON GRAPH SET GRWIDTH 1
ON GRAPH HOLD AS HOLD FORMAT SVG
ON GRAPH SET GRAPHSTYLE *
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$
TYPE=HEADING,
LINE=1,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=14,
COLOR='BLACK',
$
TYPE=HEADING,
LINE=1,
OBJECT=FIELD,
ITEM=1,
SIZE=14,
COLOR='BLACK',
$
ENDSTYLE
END
-RUN
TABLE FILE CAR
" "
SUM
COMPUTE CNTR/I4 = CNTR + 1; NOPRINT
COMPUTE CNTR2/A4 = IF &FOCGRAPHCNT EQ 1 THEN ' ' ELSE FTOA(CNTR-1,'(F4)','A4'); NOPRINT
COMPUTE IMG/A16 = 'HOLD'||LJUST(4,CNTR2,'A4')|| '.svg';NOPRINT
BY CAR.ORIGIN.COUNTRY NOPRINT
ON CAR.ORIGIN.COUNTRY PAGE-BREAK
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
type=HEADING, IMAGE=(IMG), position=(0 0), $
TYPE=REPORT,PAGE-LOCATION=OFF,$
END
SET COMPONENT='report1'
-*component_type report
TABLE FILE CAR
PRINT
'CAR.CARREC.MODEL'
'CAR.BODY.BODYTYPE'
'CAR.BODY.DEALER_COST'
'CAR.BODY.RETAIL_COST'
BY 'CAR.ORIGIN.COUNTRY'
BY 'CAR.COMP.CAR'
ON CAR.ORIGIN.COUNTRY PAGE-BREAK
-* ###### Commented out ON CAR.COMP.CAR PAGE-BREAK
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$
ENDSTYLE
END
COMPOUND END

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

Can you post your code between the code tags.
The </> button

I posted the code in Tags

I think you may have to create each graph separately to remove the missing data.

Someone else on the forum may have a better idea though.

I cannot come out of the compound report setup and create them seperately as this is a simplified case of an even complex report template that is used in numerous reports.

Well perhaps someone else will have a suggestion.

Below is the code that would solve this problem for the example shown.

TABLE FILE CAR
BY COUNTRY
ON TABLE SAVE AS FLT_CNTY
END
-RUN
-SET &FOCGRAPHCNT = &LINES-1;
 
-REPEAT GRF_Loop FOR &GRF_Cntr FROM 0 TO &FOCGRAPHCNT ;
 
-READ FLT_CNTY NOCLOSE &CNTY.A10.
 
GRAPH FILE CAR
SUM CAR.BODY.RETAIL_COST
ACROSS CAR.COMP.CAR
-*BY CAR.ORIGIN.COUNTRY
WHERE COUNTRY EQ '&CNTY'
HEADING
"<CAR.ORIGIN.COUNTRY "
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET VAXIS 4.269
ON GRAPH SET HAXIS 5.621
ON GRAPH SET GRWIDTH 1
ON GRAPH HOLD AS HOLD&GRF_Cntr  FORMAT SVG
ON GRAPH SET GRAPHSTYLE *
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$
TYPE=HEADING,
LINE=1,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=14,
COLOR='BLACK',
$
TYPE=HEADING,
LINE=1,
OBJECT=FIELD,
ITEM=1,
SIZE=14,
COLOR='BLACK',
$
ENDSTYLE
END
-RUN
 
-GRF_Loop

SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=IN, $
SECTION=section1, LAYOUT=ON, METADATA='0.5^0.5^0.5^0.5^1', MERGE=ON, ORIENTATION=PORTRAIT, PAGESIZE=Letter,  $
PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='graph1', TEXT='graph1', TOC-LEVEL=2, POSITION=(1.458 0.833), DIMENSION=(5.621 4.269), METADATA='Z-INDEX: 100; LEFT: 1.458in; WIDTH: 5.621in; POSITION: absolute; TOP: 0.833in; HEIGHT: 4.269in', $
COMPONENT='report1', TEXT='report1', TOC-LEVEL=2, POSITION=(0.624 5.625), DIMENSION=(7.294 2.083), METADATA='Z-INDEX: 100; LEFT: 0.624in; OVERFLOW: auto; WIDTH: 7.294in; POSITION: absolute; TOP: 5.625in; HEIGHT: 2.083in', $
END
SET COMPONENT='graph1'
TABLE FILE CAR
" "
SUM
COMPUTE CNTR/I4 = CNTR + 1; NOPRINT
COMPUTE CNTR2/A4 = IF &FOCGRAPHCNT EQ 1 THEN ' ' ELSE FTOA(CNTR-1,'(F4)','A4'); NOPRINT
COMPUTE IMG/A16 = 'HOLD'||LJUST(4,CNTR2,'A4')|| '.svg'; NOPRINT
BY CAR.ORIGIN.COUNTRY NOPRINT
ON CAR.ORIGIN.COUNTRY PAGE-BREAK
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
type=HEADING, IMAGE=(IMG), position=(0 0), $
TYPE=REPORT,PAGE-LOCATION=OFF,$
END
-RUN

SET COMPONENT='report1'
-*component_type report
TABLE FILE CAR
PRINT
'CAR.CARREC.MODEL'
'CAR.BODY.BODYTYPE'
'CAR.BODY.DEALER_COST'
'CAR.BODY.RETAIL_COST'
BY 'CAR.ORIGIN.COUNTRY'
BY 'CAR.COMP.CAR'
ON CAR.ORIGIN.COUNTRY PAGE-BREAK
-* ###### Commented out ON CAR.COMP.CAR PAGE-BREAK
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$
ENDSTYLE
END
COMPOUND END

I finally got to test this. It works great. Thanks Waz, you are awesome!.