Happy new Year Everyone!
Here is the code for my problem. It was created in Infoassist.
-**************************
-* Created by Power Painter
-* Default Mode: ResourceLayout
-*Do not delete or modify the comments below
*-INTERNAL_COMMENT LINE#0$CjxSb290IHZlcnNpb249IjEuMCIgPgogICA8T2JqZWN0IG9iamVjdElkPSJUYWJsZV8yIiA+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJMaW5rZWRTb3J0cyIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPjwvUHJvcGVydHk+CiAgIDwvT2JqZWN0PgogICA8T2JqZWN0IG9iamVjdElkPSJDaGFydF8xIiA+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJMaW5rZWRTb3J0cyIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPjwvUHJvcGVydHk+CiAgIDwvT2JqZWN0PgogICA8T2JqZWN0IG9iamVjdElkPSJHTE9CQUwiID4KICAgICAgPFByb3BlcnR5IG5hbWU9IlNhbXBsZURhdGEiIHR5cGU9ImphdmEubGFuZy5Cb29sZWFuIiA+ZmFsc2U8L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iR2xvYmFsUmVjb3JkTGltaXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID41MDwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJHbG9iYWxSdW5SZWNvcmRMaW1pdCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPjA8L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iZmllbGREaXNwbGF5TW9kZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPmxhYmVsPC9Qcm9wZXJ0eT4KICAgICAgPFByb3BlcnR5IG5hbWU9InByZWZpeERpc3BsYXlNb2RlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+PC9Qcm9wZXJ0eT4KICAgICAgPFByb3BlcnR5IG5hbWU9Ik91dHB1dEZvcm1hdCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPkFQREY8L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iZW5hYmxlUHJldmlldyIgdHlwZT0iamF2YS5sYW5nLkJvb2xlYW4iID50cnVlPC9Qcm9wZXJ0eT4KICAgICAgPFByb3BlcnR5IG5hbWU9IkxpbmtlZFNvcnRzIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+bm90IGluaXRpYWxpemVkPC9Qcm9wZXJ0eT4KICAgICAgPFByb3BlcnR5IG5hbWU9IkZvY2V4ZWNQcmVmZXJlbmNlcyIgdHlwZT0iTWFwIiA+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRlZmF1bHRfY29tcG9zZV9mb3JtYXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5QREY8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5SW50ZXJhY3RpdmVNb2RlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+dHJ1ZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRlZmF1bHRfdGFibGVfZm9ybWF0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+SFRNTDwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlMYXlvdXRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5mYWxzZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlEYXRhVGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5UXVpY2tBY2Nlc3NUb29sYmFyU2F2ZUluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPnRydWU8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJpbmZvQXNzaXN0TW9kZUFsbG93ZWRJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5mYWxzZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlTbGljZXJzVGFiRWRpdEluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPmZhbHNlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheUVkaXRNb2RlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJleGNlbF9mb3JtYXRfdmlzaWJsZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPnRydWU8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkZWZhdWx0X3ByZXZpZXdfcGFnZWxpbWl0X2xheW91dCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPjE8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5SG9tZVRhYkluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPmZhbHNlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZGVmYXVsdF9jaGFydF9mb3JtYXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5IVE1MPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZGVmYXVsdF9wcmV2aWV3X3BhZ2VsaW1pdCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPjU8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5SW5zZXJ0VGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJlZGl0b3JUeXBlX3Zpc2libGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID50cnVlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0idGhlbWVzX2NvbnRyb2xfdmlzaWJsZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPnRydWU8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5U2VyaWVzVGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5Rm9ybWF0VGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+dHJ1ZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlTbGljZXJzVGFiSW50ZXJhY3RpdmVJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID50cnVlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheVJlc291cmNlc0ZpZWxkVGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8
*-INTERNAL_COMMENT LINE#1$L0VudHJ5PgogICAgICA8L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iY2FzY2FkZU5hbWVzIiB0eXBlPSJNYXAiID48L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iTWFzdGVyX0ZpbGVzIiB0eXBlPSJTZXQiID4KICAgICAgICAgPEVudHJ5IHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5DQVI8L0VudHJ5PgogICAgICA8L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iRmV4U3RhdGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID57JnF1b3Q7X2FyQ29tcG9uZW50cyZxdW90OzpbXX08L1Byb3BlcnR5PgogICA8L09iamVjdD4KPC9Sb290Pg==
-*Do not delete or modify the comments above
SET PAGE-NUM=NOLEAD
COMPOUND LAYOUT PCHOLD FORMAT APDF
SECTION=Section_1, LAYOUT=ON, MERGE=AUTO, PAGESIZE=E, ORIENTATION=LANDSCAPE, SHOW_GLOBALFILTER=OFF, ACTIVE_UNITS=PTS, $
PAGELAYOUT=1, LEFTMARGIN=0.25, RIGHTMARGIN=0.25, TOPMARGIN=0.25, BOTTOMMARGIN=0.25, $
COMPONENT=Table_2, COMPONENT-TYPE=REPORT, POSITION=(0.65625 2.208333), DIMENSION=(2.53125 2.5), METADATA='VERSION:1.0', $
OBJECT=list, NAME=List_2, ARDATA_REPORT=Table_2, ARDATA_COLUMN=COUNTRY, ARFILTER_TARGET='Table_2,', ARFILTER_CONDITION=EQ, ARFILTER_MULTIPLE=ON, ARFILTER_SHOWALL=ON, POSITION=(0.854166 0.625), DIMENSION=(1.041666 1.041666), FONT=Arial, SIZE=9, COLOR=RGB(66 70 73), $
COMPONENT=Chart_1, COMPONENT-TYPE=GRAPH, POSITION=(4.0625 2.15625), DIMENSION=(7.3125 3.822916), METADATA='VERSION:1.0', $
END
SET COMPONENT=Table_2
-*component_type report
TABLE FILE CAR
SUM CAR.BODY.SALES/I6CS
BY CAR.ORIGIN.COUNTRY NOPRINT
BY CAR.ORIGIN.COUNTRY
BY CAR.COMP.CAR
ON TABLE NOTOTAL
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET SQUEEZE ON
ON TABLE SET EMPTYREPORT ON
ON TABLE SET HTMLCSS ON
ON TABLE SET HTMLENCODE ON
ON TABLE SET STYLE *
INCLUDE=IBFS:/CFG/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=REPORT, ORIENTATION=LANDSCAPE, PAGESIZE=LETTER, $
ENDSTYLE
END
SET COMPONENT=Chart_1
-*component_type graph
GRAPH FILE CAR
-* Created by Info Assist for Graph
SUM CAR.BODY.DEALER_COST
CAR.BODY.RETAIL_COST
BY CAR.ORIGIN.COUNTRY NOPRINT
BY CAR.COMP.CAR
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET VAXIS 3.822916
ON GRAPH SET HAXIS 7.3125
ON GRAPH SET UNITS INCHES
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 1
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDepthRadius(5);
setCurveFitEquationDisplay(false);
setDisplay(getDataText(0), false);
setDisplay(getDataText(1), false);
setDisplay(getDataText(2), false);
setDisplay(getDataText(3), false);
setDisplay(getDataText(4), false);
setDisplay(getDataText(5), false);
setDisplay(getDataText(6), false);
setDisplay(getDataText(7), false);
setDisplay(getDataText(8), false);
setDisplay(getDataText(9), false);
setDisplay(getDataText(10), false);
setDisplay(getDataText(11), false);
setDisplay(getDataText(12), false);
setDisplay(getDataText(13), false);
setDisplay(getDataText(14), false);
setDisplay(getDataText(15), false);
setDisplay(getDataText(16), false);
setDisplay(getDataText(17), false);
setDisplay(getDataText(18), false);
setDisplay(getDataText(19), false);
setDisplay(getDataText(20), false);
setDisplay(getDataText(21), false);
setDisplay(getDataText(22), false);
setDisplay(getDataText(23), false);
setDisplay(getDataText(24), false);
setDisplay(getDataText(25), false);
setDisplay(getDataText(26), false);
setDisplay(getDataText(27), false);
setDisplay(getDataText(28), false);
setDisplay(getDataText(29), false);
setDisplay(getDataText(30), false);
setDisplay(getDataText(31), false);
setDisplay(getDataText(32), false);
setDisplay(getDataText(33), false);
setDisplay(getDataText(34), false);
setDisplay(getDataText(35), false);
setDisplay(getDataText(36), false);
setDisplay(getDataText(37), false);
setDisplay(getDataText(38), false);
setDisplay(getDataText(39), false);
setDisplay(getDataText(40), false);
setDisplay(getDataText(41), false);
setDisplay(getDataText(42), false);
setDisplay(getDataText(43), false);
setDisplay(getDataText(44), false);
setDisplay(getDataText(45), false);
setDisplay(getDataText(46), false);
setDisplay(getDataText(47), false);
setDisplay(getDataText(48), false);
setDisplay(getDataText(49), false);
setDisplay(getDataText(50), false);
setDisplay(getDataText(51), false);
setDisplay(getDataText(52), false);
setDisplay(getDataText(53), false);
setDisplay(getDataText(54), false);
setDisplay(getDataText(55), false);
setDisplay(getDataText(56), false);
setDisplay(getDataText(57), false);
setDisplay(getDataText(58), false);
setDisplay(getDataText(59), false);
setDisplay(getDataText(60), false);
setDisplay(getDataText(61), false);
setDisplay(getDataText(62), false);
setDisplay(getDataText(63), false);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
INCLUDE=IBFS:/CFG/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=REPORT, ORIENTATION=LANDSCAPE, PAGESIZE=LETTER, $
ENDSTYLE
END
COMPOUND END
WebFOCUS & ReportCaster 8.1.05, 7.7.03 - AIX/LINUX, FOCUS 7.6.13 MVS, Output PDF, XLS-XLSX, DOCX and HTML