Hello
How do I add TOC drillthru report as a first page with links on the front of compound report ? I am attaching to the case is compound report developed with car file.
Client wants to add TOC DRILLTHROUGH as a first page on this compound report like list of countries and on clicking on country name we will go to page for that country.

This PDF file will be sent to user email by RC job. Can we do this using DRILLTHROUGH=DOWN? I tried but could not do.


Thanks,


-*******************************
-*** code **************
-*******************************
COMPOUND LAYOUT
UNITS=IN, $
SECTION=section1, LAYOUT=ON, MERGE=ON, ORIENTATION=PORTRAIT, PAGESIZE=Letter, $
pagelayout=1, name='Layout page 1', $
-*component='report0', type=report, position=(0 0), dimension=(8.500 11.000),$
component='report1', type=report, position=(0.208 0.312), dimension=(3.000 3.125), $
component='graph1', type=report, position=(3.229 0.312), dimension=(3.625 3.167), $
END
-GOTO REP1;
SET COMPONENT='report0'
TABLE FILE CAR
PRINT CAR
BY COUNTRY
ON TABLE SET PAGE-NUM OFF
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=HEADING,STYLE=BOLD, BORDER=MEDIUM, $
TYPE=DATA,
COLUMN=CAR,
DT DN(COUNTRY CAR),
$
ENDSTYLE
END
-REP1
SET COMPONENT='report1'
-*component_type report
TABLE FILE CAR
PRINT
CAR AS ''
BY COUNTRY NOPRINT
ON COUNTRY PAGE-BREAK
HEADING
"Cars in ON TABLE SET PAGE-NUM OFF
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=HEADING,STYLE=BOLD, BORDER=MEDIUM, $
ENDSTYLE
END
SET COMPONENT='graph1'
-*component_type graph
GRAPH FILE CAR
HEADING
"SUM DEALER_COST
ACROSS CAR
BY COUNTRY
ON GRAPH SET LOOKGRAPH PIEMULTI
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 3.167
ON GRAPH SET HAXIS 3.625
ON GRAPH SET UNITS INCHES
ON GRAPH SET GRWIDTH 0
ON GRAPH HOLD AS TEST FORMAT SVG
ON GRAPH SET GRAPHSTYLE *
setLegendMarkerPosition(1);
setMarkerDisplay(false);
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(2);
setTextFormatPreset(getPieSliceLabel(),1);
setLegendDisplay(true);
setTitleString("Dealer Cost by Car");
setFontSizeAbsolute(getTitle(),true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
PAGESIZE='Letter',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
TITLETEXT='Dealer Cost by Car',
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=1,
OBJECT=FIELD,
ITEM=1,
COLOR='BLACK',
$
ENDSTYLE
END
TABLE FILE CAR
" "
SUM
COMPUTE CNTR/I4 = CNTR + 1; NOPRINT
COMPUTE CNTR2/A4 = FTOA(CNTR-1,'(F4)','A4');NOPRINT
COMPUTE IMG/A16 = 'TEST'||LJUST(4,CNTR2,'A4')|| '.svg';NOPRINT
BY COUNTRY NOPRINT
ON 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), $
END
COMPOUND END
-EXIT

This example is a bit confusing you have a Graph stylesheet...but no Graph...
Also what version are you on?

Prarie,

We are on 7.1.0.
First we have report. and second is a graph request that saves images. Purpose of third report is just display image in Graph heading.
THis will print a report for cars and to the right of report it iwill print graph.

We want to add TOC Report as a first report and clicking on Link of country will take us to page desiged.


Thanks

Yogi,
If you can upgrade to 7.6 then you'll have access to a TOC object which you add to your PDF document using the PDF Layout Painter and the drilldown is setup for you.

Greg

gregv,
Is there anything that can be done in 7.1?

There is one thing I can think of, Yogi. You can create 2 PDF documents: 1 a Table of Contents PDF report with a drilldown to a second PDF report (compound) that passes Country and generates a report and graph just for that country.

If you want to give out the entire report with all pages and drill-through from the first TOC page through to the correct report + graph page then I'm not so sure. Let me look at the code generated in 7.6 and see if it can be rewritten in a way to use in 7.1.

Greg

GregV
Can you pass on code written in 7.6 and I will try to play with it?

Thanks

Sorry Yogi,
I've been on the road all week.
Here's an example that runs on 7.6 though it has a lot going on. One thing to take note of is: TABLE FILE SYSCOLUM.

Greg

-* File pdfTOC2
-* Default Mode: ResourceLayout
SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=IN, $
OBJECT=TOC, NAME='Table of Contents', METADATA='Table of Contents', TEXT='Table of Contents', MARKUP=OFF, TOC-NUMBERING=ON, POSITION=(0.854 0.854), DIMENSION=(7.000 9.500), font='ARIAL', color=RGB(0 0 0),  size=10,  $
SECTION=section1, LAYOUT=ON, METADATA='0.5^0.5^0.5^0.5', MERGE=OFF, ORIENTATION=PORTRAIT, PAGESIZE=Letter, $
PAGELAYOUT=ALL, NAME='Page Master', $
OBJECT=IMAGE, NAME='image1', IMAGE=centlogo.gif, POSITION=(0.625 0.625), DIMENSION=(1.354 0.521), $
OBJECT=IMAGE, NAME='image2', IMAGE=red_border.gif, POSITION=(0.625 1.250), DIMENSION=(7.271 0.063), $
COMPONENT='DfltCmpt2', POSITION=(0 0), DIMENSION=(0 0), $
PAGELAYOUT=1, NAME='Page layout 1', text='Century Trades Summary', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='0^0.5^0^0.5', $
COMPONENT='report1', TEXT='Trades by Region', TOC-LEVEL=2, POSITION=(0.833 1.771), DIMENSION=(4.371 2.024), METADATA='Z-INDEX: 100; LEFT: 0.833in; WIDTH: 4.371in; POSITION: absolute; TOP: 1.771in; HEIGHT: 2.024in', $
COMPONENT='graph1', TEXT='Trades by Month', TOC-LEVEL=2, POSITION=(5.417 1.771), DIMENSION=(2.500 2.083), METADATA='Z-INDEX: 100; LEFT: 5.417in; WIDTH: 2.5in; POSITION: absolute; TOP: 1.771in; HEIGHT: 2.083in', $
COMPONENT='graph2', TEXT='Trades by Region', TOC-LEVEL=2, POSITION=(2.082 4.621), DIMENSION=(4.171 2.602), METADATA='Z-INDEX: 100; LEFT: 2.082in; WIDTH: 4.171in; POSITION: absolute; TOP: 4.621in; HEIGHT: 2.602in', $
PAGELAYOUT=2, NAME='Page layout 3', text='Century Funds Summary', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=1.5, METADATA='0^1.5^0^0.5', $
COMPONENT='report2', TEXT='Regional Fund Balances ', TOC-LEVEL=2, POSITION=(0.979 1.625), DIMENSION=(* *), METADATA='Z-INDEX: 100; LEFT: 0.979in; WIDTH: 6.561in; POSITION: absolute; TOP: 1.625in; HEIGHT: 3.413in', $
COMPONENT='graph3', TEXT='Balance by Region', TOC-LEVEL=2, POSITION=(+0.477 +0.483), DIMENSION=(5.725 2.686), RELATIVE-TO='report2', RELATIVE-POINT=BOTTOM-LEFT, POSITION-POINT=TOP-LEFT, METADATA='Z-INDEX: 100; LEFT: 1.456in; WIDTH: 5.725in; POSITION: absolute; TOP: 5.521in; HEIGHT: 2.686in', $
END
SET COMPONENT='DfltCmpt2'
TABLE FILE SYSCOLUM
" "
SUM TBNAME NOPRINT
IF READLIMIT EQ 1
ON TABLE SET PREVIEW ON
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
END
SET COMPONENT='report1'
-*component_type report
TABLE FILE TRADES
SUM
BUY_AMOUNT AS 'Buy Amount'
SELL_AMOUNT AS 'Sell Amount'
COMPUTE GAIN/D12.2CM = SELL_AMOUNT - BUY_AMOUNT; AS 'Gain'
BY TOTAL HIGHEST COMPUTE GAIN/D12.2CM = SELL_AMOUNT - BUY_AMOUNT; NOPRINT
BY REGION
HEADING
"Trades by Region"
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,
PAGESIZE='Letter',
LEFTMARGIN=0.000000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.000000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
PAGECOLOR='WHITE',
$
TYPE=REPORT,
$
TYPE=REPORT,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
FONT='ARIAL',
SIZE=9,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
RIGHTGAP=0.125000,
$
TYPE=DATA,
SIZE=8,
BACKCOLOR=( RGB(236 209 167) RGB(227 185 148) ),
$
TYPE=TITLE,
COLOR='WHITE',
-*BACKCOLOR=RGB(51 0 51),
BACKCOLOR=RGB(190 93 74),
STYLE=BOLD,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
BORDER-TOP-STYLE=OUTSET,
BORDER-BOTTOM-STYLE=OUTSET,
BORDER-LEFT-STYLE=RIDGE,
BORDER-RIGHT-STYLE=RIDGE,
-*BORDER-TOP-COLOR=RGB(51 0 51),
-*BORDER-BOTTOM-COLOR=RGB(51 0 51),
-*BORDER-LEFT-COLOR=RGB(51 0 51),
-*BORDER-RIGHT-COLOR=RGB(51 0 51),
BORDER-TOP-COLOR=RGB(190 93 74),
BORDER-BOTTOM-COLOR=RGB(190 93 74),
BORDER-LEFT-COLOR=RGB(190 93 74),
BORDER-RIGHT-COLOR=RGB(190 93 74),
SIZE=12,
STYLE=BOLD,
$
TYPE=FOOTING,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
SIZE=8,
STYLE=BOLD,
$
TYPE=FOOTING,
LINE=2,
JUSTIFY=RIGHT,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
BACKCOLOR='SILVER',
$
TYPE=ACROSSVALUE,
SIZE=8,
$
TYPE=ACROSSTITLE,
SIZE=9,
COLOR='WHITE',
BACKCOLOR=RGB(190 93 74),
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
BORDER-TOP-STYLE=GROOVE,
BORDER-BOTTOM-STYLE=GROOVE,
COLOR='BLACK',
BACKCOLOR='SILVER',
STYLE=BOLD,
$
ENDSTYLE
END
SET COMPONENT='graph1'
-*component_type graph
GRAPH FILE TRADES
SUM BUY_AMOUNT AS 'Buy Amount' SELL_AMOUNT AS 'Sell Amount'
ACROSS MONTH AS 'Month'
ON GRAPH SET LOOKGRAPH VLINE
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D ON
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET VAXIS 2.083
ON GRAPH SET HAXIS 2.500
ON GRAPH HOLD AS HOLD FORMAT SVG
-*ON GRAPH PCHOLD FORMAT SVG
ON GRAPH SET GRAPHSTYLE *
setFillColor(getSeries(0),new Color(153, 0, 0));
setFillColor(getSeries(1),new Color(190, 93, 74));
setFillColor(getSeries(2),new Color(209, 139, 111));
setFillColor(getSeries(3),new Color(227, 185, 148));
setFillColor(getSeries(4),new Color(236, 209, 167));
setFillColor(getSeries(5),new Color(241, 241, 190));
setFillColor(getSeries(6),new Color(213, 213, 162));
setFillColor(getSeries(7),new Color(172, 172, 121));
setFillColor(getSeries(8),new Color(130, 130 , 79));
setFillColor(getSeries(9),new Color(102, 102, 51));
setFillColor(getSeries(10),new Color(227, 227, 176));
setFillColor(getSeries(11),new Color(186, 210, 157));
setFillColor(getSeries(12),new Color(144, 193, 138));
setFillColor(getSeries(13),new Color(103, 176, 119));
setFillColor(getSeries(14),new Color(21, 142, 81));
setFillColor(getSeries(15),new Color(255, 200, 0));
setFillColor(getSeries(16),new Color(168, 132, 0));
setFillColor(getSeries(17),new Color(241, 236, 95));
setFillColor(getSeries(18),new Color(234, 229, 21));
setFillColor(getSeries(19),new Color(154, 151, 14));
setFillColor(getSeries(20),new Color(168, 164, 0));
setMarkerDisplay(true);
setConnectLineMarkers(true);
setConnectScatterMarkers(true);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setSeriesType(0,2);
setAxisAssignment(1,0);
setSeriesType(1,2);
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);
setTitleString("Trades by Month");
setFontSizeAbsolute(getTitle(),true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setTemplateFile("/images/tdg/template/IBIBeveledOnTan.txt");
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
PAGESIZE='Letter',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
TITLETEXT='Trades by Month',
$
TYPE=REPORT,
GRID=OFF,
$
ENDSTYLE
END
TABLE FILE SYSCOLUM
" "
SUM TBNAME NOPRINT
ON TABLE SET PAGE-NUM NOLEAD
IF READLIMIT EQ 1
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
type=HEADING, IMAGE=HOLD.svg, position=(0 0), $
END
SET COMPONENT='graph2'
-*component_type graph
GRAPH FILE TRADES
SUM AMOUNT
ACROSS REGION
ON GRAPH SET LOOKGRAPH PIEMULTI
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D ON
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET VAXIS 2.602
ON GRAPH SET HAXIS 4.171
ON GRAPH HOLD AS HOL0 FORMAT SVG
-*ON GRAPH PCHOLD FORMAT SVG
ON GRAPH SET GRAPHSTYLE *
setFillColor(getSeries(0),new Color(153, 0, 0));
setFillColor(getSeries(1),new Color(190, 93, 74));
setFillColor(getSeries(2),new Color(209, 139, 111));
setFillColor(getSeries(3),new Color(227, 185, 148));
setFillColor(getSeries(4),new Color(236, 209, 167));
setFillColor(getSeries(5),new Color(241, 241, 190));
setFillColor(getSeries(6),new Color(213, 213, 162));
setFillColor(getSeries(7),new Color(172, 172, 121));
setFillColor(getSeries(8),new Color(130, 130 , 79));
setFillColor(getSeries(9),new Color(102, 102, 51));
setFillColor(getSeries(10),new Color(227, 227, 176));
setFillColor(getSeries(11),new Color(186, 210, 157));
setFillColor(getSeries(12),new Color(144, 193, 138));
setFillColor(getSeries(13),new Color(103, 176, 119));
setFillColor(getSeries(14),new Color(21, 142, 81));
setFillColor(getSeries(15),new Color(255, 200, 0));
setFillColor(getSeries(16),new Color(168, 132, 0));
setFillColor(getSeries(17),new Color(241, 236, 95));
setFillColor(getSeries(18),new Color(234, 229, 21));
setFillColor(getSeries(19),new Color(154, 151, 14));
setFillColor(getSeries(20),new Color(168, 164, 0));
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);
setLegendDisplay(true);
setTitleString("Trades by Region");
setFontSizeAbsolute(getTitle(),true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
PAGESIZE='Letter',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
TITLETEXT='Trades by Region',
$
TYPE=REPORT,
GRID=OFF,
$
ENDSTYLE
END
TABLE FILE SYSCOLUM
" "
SUM TBNAME NOPRINT
ON TABLE SET PAGE-NUM NOLEAD
IF READLIMIT EQ 1
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
type=HEADING, IMAGE=HOL0.svg, position=(0 0), $
END
SET COMPONENT='report2'
-*component_type report
TABLE FILE SHORT
PRINT
BALANCE
BY REGION
BY MANAGER_ID
ACROSS SHORT_DATE
HEADING
"Regional Fund Balances"
" "
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.000000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.000000,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
PAGECOLOR='WHITE',
$
TYPE=REPORT,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
FONT='ARIAL',
SIZE=9,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
RIGHTGAP=0.055556,
$
TYPE=DATA,
SIZE=8,
BACKCOLOR=( RGB(236 209 167) RGB(227 185 148) ),
$
TYPE=DATA,
COLUMN=N1,
BACKCOLOR=RGB(209 139 111),
$
TYPE=TITLE,
COLOR='WHITE',
-*BACKCOLOR=RGB(51 0 51),
BACKCOLOR=RGB(190 93 74),
STYLE=BOLD,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
BORDER-TOP-STYLE=OUTSET,
BORDER-BOTTOM-STYLE=OUTSET,
BORDER-LEFT-STYLE=RIDGE,
BORDER-RIGHT-STYLE=RIDGE,
-*BORDER-TOP-COLOR=RGB(51 0 51),
-*BORDER-BOTTOM-COLOR=RGB(51 0 51),
-*BORDER-LEFT-COLOR=RGB(51 0 51),
-*BORDER-RIGHT-COLOR=RGB(51 0 51),
BORDER-TOP-COLOR=RGB(190 93 74),
BORDER-BOTTOM-COLOR=RGB(190 93 74),
BORDER-LEFT-COLOR=RGB(190 93 74),
BORDER-RIGHT-COLOR=RGB(190 93 74),
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=2,
SIZE=8,
STYLE=NORMAL,
$
TYPE=FOOTING,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
SIZE=8,
STYLE=BOLD,
$
TYPE=FOOTING,
LINE=2,
JUSTIFY=RIGHT,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
BACKCOLOR='SILVER',
$
TYPE=ACROSSVALUE,
SIZE=8,
$
TYPE=ACROSSVALUE,
ACROSS=1,
BACKCOLOR=RGB(209 139 111),
$
TYPE=ACROSSVALUE,
COLUMN=ROWTOTAL(2),
BACKCOLOR=RGB(209 139 111),
$
TYPE=ACROSSVALUE,
COLUMN=ROWTOTAL(1),
BACKCOLOR=RGB(209 139 111),
$
TYPE=ACROSSTITLE,
SIZE=9,
COLOR='WHITE',
BACKCOLOR=RGB(190 93 74),
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
BORDER-TOP-STYLE=GROOVE,
BORDER-BOTTOM-STYLE=GROOVE,
COLOR='BLACK',
BACKCOLOR='SILVER',
STYLE=BOLD,
$
TYPE=REPORT,
COLUMN=N0,
WRAP=0.138889,
$
ENDSTYLE
END
SET COMPONENT='graph3'
-*component_type graph
GRAPH FILE SHORT
SUM BALANCE
ACROSS SHORT_DATE AS 'Date'
BY REGION
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D ON
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET VAXIS 2.686
ON GRAPH SET HAXIS 5.725
ON GRAPH SET GRMERGE ON
ON GRAPH HOLD AS HOL1 FORMAT SVG
-*ON GRAPH PCHOLD FORMAT SVG
ON GRAPH SET GRAPHSTYLE *
setFillColor(getSeries(0),new Color(153, 0, 0));
setFillColor(getSeries(1),new Color(190, 93, 74));
setFillColor(getSeries(2),new Color(209, 139, 111));
setFillColor(getSeries(3),new Color(227, 185, 148));
setFillColor(getSeries(4),new Color(236, 209, 167));
setFillColor(getSeries(5),new Color(241, 241, 190));
setFillColor(getSeries(6),new Color(213, 213, 162));
setFillColor(getSeries(7),new Color(172, 172, 121));
setFillColor(getSeries(8),new Color(130, 130 , 79));
setFillColor(getSeries(9),new Color(102, 102, 51));
setFillColor(getSeries(10),new Color(227, 227, 176));
setFillColor(getSeries(11),new Color(186, 210, 157));
setFillColor(getSeries(12),new Color(144, 193, 138));
setFillColor(getSeries(13),new Color(103, 176, 119));
setFillColor(getSeries(14),new Color(21, 142, 81));
setFillColor(getSeries(15),new Color(255, 200, 0));
setFillColor(getSeries(16),new Color(168, 132, 0));
setFillColor(getSeries(17),new Color(241, 236, 95));
setFillColor(getSeries(18),new Color(234, 229, 21));
setFillColor(getSeries(19),new Color(154, 151, 14));
setFillColor(getSeries(20),new Color(168, 164, 0));
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setSeriesType(0,1);
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);
setTitleString("Balance by Region");
setFontSizeAbsolute(getTitle(),true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
PAGESIZE='Letter',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
TITLETEXT='Balance by Region',
$
TYPE=REPORT,
GRID=OFF,
$
ENDSTYLE
END
TABLE FILE SYSCOLUM
" "
SUM TBNAME NOPRINT
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
type=HEADING, IMAGE=HOL1.svg, position=(0 0), $
END
COMPOUND END