Hi,

In my report I have 4 graphs.
One graph is in one line and the other 3 are placed one after the other horizontally.

Below the 3 graph I have placed 3 standard reports.
The data’s in the Standard may extend to more than one page.

I have done my report using HTML Layout.

The report looks fine in the Screen but when I take a print out it looks bad.

Is there a solution to overcome this issue?

Can I import these to a PDF and then will it print properly.

This is a dynamic report and the Graph and the Standard report is based on 2 cascading prompt, and Start Date and End Date which the user will have to choose.

My question is when I import an FEX file in a PDF layout the Prompt does not appear as it appears in HTML Layout.

Kindly provide me a solution for my printing problem and the PDF Layout problem

Thanks in advance

Regards
Navaneeth

Hi Navaneeth,

Has this issue been resolved on your side? Would you mind to post a sample code using the CAR file to this topic?

If this is an urgent issue, as always, you may contact Information Builders’ Customer Support Services immediately by calling 1-800-736-6130 or access online at http://techsupport.informationbuilders.com. At the time of contact, please clearly state that issue needs immediate attention.

Cheers,

Kerry

I saw those , but my requirment is slightly different.

In my case the graph needs to apper only in the first half of Page1. and in Second half of Page1 i have placed an standard report.

My problem is The standard report may go to more than 1 pages and if it goes to second page then i get my standard report only in the Second half of Page2. The first half of Page2 is left Blank.

Why is this happening? Is there any way to solve this

Regards
Navaneeth

SAMPLE CODE

-* File pdf-graph
-* Default Mode: ResourceLayout
COMPOUND LAYOUT
UNITS=IN, $
SECTION=section1, LAYOUT=ON, MERGE=OFF, ORIENTATION=LANDSCAPE, PAGESIZE=11 x 17, $
pagelayout=1, name='Layout page 1', $
component='graph1', type=report, position=(0.042 0.042), dimension=(8.000 4.542), $
component='report1', type=report, position=(0.104 4.792), dimension=(16.665 6.040), $
END
SET COMPONENT='graph1'
-*component_type graph
JOIN
A1.ATO MULTIPLE
A1.B AS J0
END
GRAPH FILE A
SUM
CNT.A2
ACROSS A3
WHERE ( NEWDATE GE '&STRT_TIME.START DATE.' ) AND ( NEWDATE LE '&END_TIME.END DATE.' );
ON GRAPH SET LOOKGRAPH PIEMULTP
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.542
ON GRAPH SET HAXIS 8.000
ON GRAPH SET UNITS INCHES
ON GRAPH SET GRWIDTH 0
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);
setSeriesType(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 *
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,
$
TYPE=HEADING,
LINE=1,
OBJECT=FIELD,
ITEM=1,
COLOR='BLACK',
$
ENDSTYLE
END
TABLE FILE T_ORA_TECH_PROB
" "
BY SEVR_NAME 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
SET COMPONENT='report1'
-*component_type report
TABLE FILE A
PRINT
A1
A2
A3
A4
A5
A6
A7
A8
A9
A10
A11
WHERE ( NEWDATE GE '&STRT_TIME.START DATE.' ) AND ( NEWDATE LE '&END_TIME.END DATE.' );
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,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=REPORT,
COLUMN=N2,
SQUEEZE=0.805556,
$
ENDSTYLE
END
COMPOUND END

Hi Navaneeth,

Unfortunately I do not have your master file here to do any testing. If this issue has not been resolved for you, maybe you would like to submit a case to Information Builders' Customer Support Services for further assistance. The phone number is 1-800-736-6130, or you can access InfoResponse at http://techsupport.ibi.com at your conveniences. Here is a list of information to be ready when you call: http://techsupport.ibi.com/before_you_call.jsp.

Hope this helps.

Cheers,

Kerry