Hi,

I have tried to create a graph and report in the PDF layout tool, but we are set up so our output in developer studio is on the standard reports area of MRE. I get the graph beautifully, however the report portion is basically 'gobblly gook'. Does any one know if this is because of our set up, or some other issue. Thanks.

Leah,

I am tempted to say that it is because you used the GUI .

Have you looked at the code produced and tried to determine the problem?

T

These items might help:

1.) How are you saving the graph - as .jpg, .gif, .png, .svg? It might make a difference.
2.) Where are you situating the graph: in the header, in the footer, in the report itself? Our experience has been to put the graph in the heading or footing and not in the report itself.

I used the gui to answer Tony, I verified the graph type is correct for holding, the graph displays in the pdf, the report portion looks like a raw data file. I looked at the code generated by the gui and it includes -include for each part. Anything in particular I should check for. Customer really likes the graph, would be nice to generate the supporting detail at the same time.

Leah,

The first part was meant to be a statement - e.g. it was because you used the GUI!!

As for the code, what environment are you using? Your test on 7.6? I guess so because of the new compound tool.

Unfortunately I do not have 7.6 to test but this is code I produced using the GUI (a rare occurence) on 7.1.3. How does it compare to the syntax in 7.6?

T

-* File pdf_layout
-* Default Mode: ResourceLayout
COMPOUND LAYOUT
UNITS=IN, $
SECTION=section1, LAYOUT=ON, MERGE=OFF, ORIENTATION=PORTRAIT, PAGESIZE=Letter, $
pagelayout=1, name='Layout page 1', $
component='report1', type=report, position=(0.5 1.0), dimension=(6.5 4.0), $
component='graph1', type=report, position=(0.5 5.5), dimension=(6.5 4.0), $
END
SET COMPONENT='report1'
-*component_type report
TABLE FILE CAR
SUM
'CAR.BODY.DEALER_COST'
'CAR.BODY.RETAIL_COST'
BY 'CAR.ORIGIN.COUNTRY'
BY 'CAR.COMP.CAR'
BY 'CAR.CARREC.MODEL'
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',SQUEEZE=ON,ORIENTATION=PORTRAIT,$
TYPE=REPORT,GRID=OFF,FONT='ARIAL',SIZE=9,COLOR='BLACK',BACKCOLOR='NONE',
STYLE=NORMAL,$
TYPE=TITLE,STYLE=BOLD,$
TYPE=TABHEADING,SIZE=12,STYLE=BOLD,$
TYPE=TABFOOTING,SIZE=12,STYLE=BOLD,$
TYPE=HEADING,SIZE=12,STYLE=BOLD,$
TYPE=FOOTING,SIZE=12,STYLE=BOLD,$
TYPE=SUBHEAD,SIZE=10,STYLE=BOLD,$
TYPE=SUBFOOT,SIZE=10,STYLE=BOLD,$
TYPE=SUBTOTAL,BACKCOLOR=RGB(210 210 210),$
TYPE=ACROSSVALUE,SIZE=9,$
TYPE=ACROSSTITLE,STYLE=BOLD,$
TYPE=GRANDTOTAL,BACKCOLOR=RGB(210 210 210),STYLE=BOLD,$
ENDSTYLE
END
SET COMPONENT='graph1'
-*component_type graph
GRAPH FILE CAR
SUM CAR.BODY.DEALER_COST CAR.BODY.RETAIL_COST
ACROSS CAR.CARREC.MODEL
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.0
ON GRAPH SET HAXIS 6.5
ON GRAPH SET UNITS INCHES
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);
setAxisAssignment(1,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 *
PAGESIZE='Letter',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
BACKCOLOR='NONE',
STYLE=NORMAL,
$
ENDSTYLE
END
TABLE FILE CAR
" "
BY CAR.CARREC.MODEL NOPRINT
ON TABLE SET PAGE-NUM NOLEAD
IF RECORDLIMIT EQ 1
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
type=HEADING, IMAGE=HOLD.svg, position=(0 0), $
END
COMPOUND END

This message has been edited. Last edited by: Tony A,

Tony,

I'm trying on our 7.1.5 linux version. Hadn't tried it on 7.6. Thanks for the example. I will compare.

I have not been able to go back to this issue, but it doesn't seem to work for me with imports.
https://forums.informationbuilders.com/eve/forums/a/tpc/...971083502#6971083502