Jump to content
Changes to the Jaspersoft community edition download ×

Stuck at 'Opening Connection' - URGENT


Recommended Posts

By: Sohan Kasula - skasula

Stuck at 'Opening Connection' - URGENT

2003-05-07 15:04

I have a master report and sub report.

Sub report returns around 45 records in the detail section. When Tested sub report and Master report work fine by themselves. However When I try to print the report output (pdf) by using both together, the compiler is stuck at "Opening Connection..." message. When I limit the data in the sub report to 10 records, the pdf file is generated quickly. When I try to go for larger data set like 13 records or beyond the tool is stuck.

I think it has to do with data not being formatted.

I tried reducing the pageheight of subreport from 842 and added dummy pagebreak group too. Still doesn't work.

 

Help is appreciated.

thanks.

copied are master and subreport xml's

 

master report

-------------------

<?xml version="1.0" encoding="UTF-8" ?>

- <!-- Created with iReport - A designer for JasperReports -->

<!DOCTYPE jasperReport (View Source for full doctype...)>

- <jasperReport name="APM" columnCount="1" printOrder="Vertical" orientation="Portrait" pageWidth="612" pageHeight="792" columnWidth="535" columnSpacing="0" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" whenNoDataType="AllSectionsNoDetail" isTitleNewPage="false" isSummaryNewPage="false">

- <parameter name="PSNAPM" isForPrompting="true" class="java.lang.Integer">

- <defaultValueExpression>

- <![CDATA[ new Integer(307) ]]>

</defaultValueExpression>

</parameter>

- <parameter name="APMSubReport2" isForPrompting="true" class="java.lang.String">

- <defaultValueExpression>

- <![CDATA[ "APMSubReport2.jasper" ]]>

</defaultValueExpression>

</parameter>

- <queryString>

- <![CDATA[

select sn_apm, apm.MMS_COMPANY_NUM, API_WELL_NUMBER, WELL_NM_ST_SFIX,

WELL_NM_BP_SFIX, WATER_DEPTH, WELL_NAME,

SN_SURF_LSE_FK,

SN_BOTM_LSE_FK,

APM_OP_CD,

BOREHOLE_STAT_CD,

WELL_TYPE_CODE,

sfl.AREA_CODE SURF_AREA_CODE,

sfl.BLOCK_NUMBER SURF_BLOCK_NUMBER,

sfl.LEASE_NUMBER SURF_LEASE_NUMBER,

bfl.AREA_CODE BOTM_AREA_CODE,

bfl.BLOCK_NUMBER BOTM_BLOCK_NUMBER,

bfl.LEASE_NUMBER BOTM_LEASE_NUMBER

from e_apms apm, boreholes, field_leases sfl, field_leases bfl

where SN_BOREHOLE_FK = SN_BOREHOLE

and SN_SURF_LSE_FK = sfl.sn_fld_lse

and SN_BOTM_LSE_FK = bfl.sn_fld_lse

and sn_apm = $P{PSNAPM}

 

]]>

</queryString>

<field name="SN_APM" class="java.lang.Integer" />

<field name="MMS_COMPANY_NUM" class="java.lang.String" />

<field name="API_WELL_NUMBER" class="java.lang.String" />

<field name="WELL_NM_ST_SFIX" class="java.lang.String" />

<field name="WELL_NM_BP_SFIX" class="java.lang.String" />

<field name="WATER_DEPTH" class="java.lang.Integer" />

<field name="WELL_NAME" class="java.lang.String" />

<field name="SN_SURF_LSE_FK" class="java.lang.Integer" />

<field name="SN_BOTM_LSE_FK" class="java.lang.Integer" />

<field name="APM_OP_CD" class="java.lang.String" />

<field name="BOREHOLE_STAT_CD" class="java.lang.String" />

<field name="WELL_TYPE_CODE" class="java.lang.String" />

<field name="SURF_AREA_CODE" class="java.lang.String" />

<field name="SURF_BLOCK_NUMBER" class="java.lang.String" />

<field name="SURF_LEASE_NUMBER" class="java.lang.String" />

<field name="BOTM_AREA_CODE" class="java.lang.String" />

<field name="BOTM_BLOCK_NUMBER" class="java.lang.String" />

<field name="BOTM_LEASE_NUMBER" class="java.lang.String" />

- <title>

- <band height="42">

- <staticText>

<reportElement mode="Transparent" x="79" y="5" width="400" height="19" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Center" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica-Bold" size="12" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded="false" pdfEncoding="Cp1250" isStrikeThrough="false" />

</textElement>

- <text>

- <![CDATA[ Application for Permit to Modify ]]>

</text>

</staticText>

</band>

</title>

- <pageHeader>

- <band height="93">

- <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None">

<reportElement mode="Transparent" x="77" y="6" width="92" height="14" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="Helvetica" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded="false" isStrikeThrough="false" />

</textElement>

- <textFieldExpression class="java.lang.String">

- <![CDATA[ $F{API_WELL_NUMBER} ]]>

</textFieldExpression>

</textField>

- <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None">

<reportElement mode="Transparent" x="218" y="6" width="42" height="14" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="Helvetica" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded="false" isStrikeThrough="false" />

</textElement>

- <textFieldExpression class="java.lang.String">

- <![CDATA[ $F{WELL_NM_ST_SFIX} ]]>

</textFieldExpression>

</textField>

- <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None">

<reportElement mode="Transparent" x="317" y="6" width="47" height="14" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded="false" pdfEncoding="Cp1250" isStrikeThrough="false" />

</textElement>

- <textFieldExpression class="java.lang.String">

- <![CDATA[ $F{WELL_NM_BP_SFIX} ]]>

</textFieldExpression>

</textField>

- <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None">

<reportElement mode="Transparent" x="77" y="25" width="80" height="14" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="Helvetica" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded="false" isStrikeThrough="false" />

</textElement>

- <textFieldExpression class="java.lang.String">

- <![CDATA[ $F{WELL_NAME} ]]>

</textFieldExpression>

</textField>

- <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None">

<reportElement mode="Transparent" x="218" y="25" width="42" height="14" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="Helvetica" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded="false" isStrikeThrough="false" />

</textElement>

- <textFieldExpression class="java.lang.String">

- <![CDATA[ $F{BOREHOLE_STAT_CD} ]]>

</textFieldExpression>

</textField>

- <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None">

<reportElement mode="Transparent" x="317" y="25" width="47" height="14" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded="false" pdfEncoding="Cp1250" isStrikeThrough="false" />

</textElement>

- <textFieldExpression class="java.lang.String">

- <![CDATA[ $F{WELL_TYPE_CODE} ]]>

</textFieldExpression>

</textField>

- <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None">

<reportElement mode="Transparent" x="77" y="42" width="80" height="14" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded="false" pdfEncoding="Cp1250" isStrikeThrough="false" />

</textElement>

- <textFieldExpression class="java.lang.String">

- <![CDATA[ $F{SURF_LEASE_NUMBER} ]]>

</textFieldExpression>

</textField>

- <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None">

<reportElement mode="Transparent" x="218" y="42" width="42" height="14" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded="false" pdfEncoding="Cp1250" isStrikeThrough="false" />

</textElement>

- <textFieldExpression class="java.lang.String">

- <![CDATA[ $F{SURF_AREA_CODE} ]]>

</textFieldExpression>

</textField>

- <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None">

<reportElement mode="Transparent" x="317" y="42" width="47" height="14" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded="false" pdfEncoding="Cp1250" isStrikeThrough="false" />

</textElement>

- <textFieldExpression class="java.lang.String">

- <![CDATA[ $F{SURF_BLOCK_NUMBER} ]]>

</textFieldExpression>

</textField>

- <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None">

<reportElement mode="Transparent" x="77" y="60" width="80" height="14" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded="false" pdfEncoding="Cp1250" isStrikeThrough="false" />

</textElement>

- <textFieldExpression class="java.lang.String">

- <![CDATA[ $F{BOTM_LEASE_NUMBER} ]]>

</textFieldExpression>

</textField>

- <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None">

<reportElement mode="Transparent" x="317" y="60" width="47" height="14" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded="false" pdfEncoding="Cp1250" isStrikeThrough="false" />

</textElement>

- <textFieldExpression class="java.lang.String">

- <![CDATA[ $F{BOTM_BLOCK_NUMBER} ]]>

</textFieldExpression>

</textField>

- <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None">

<reportElement mode="Transparent" x="218" y="60" width="42" height="14" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded="false" pdfEncoding="Cp1250" isStrikeThrough="false" />

</textElement>

- <textFieldExpression class="java.lang.String">

- <![CDATA[ $F{BOTM_AREA_CODE} ]]>

</textFieldExpression>

</textField>

- <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None">

<reportElement mode="Transparent" x="450" y="6" width="80" height="14" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="Helvetica" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded="false" isStrikeThrough="false" />

</textElement>

- <textFieldExpression class="java.lang.Integer">

- <![CDATA[ $F{WATER_DEPTH} ]]>

</textFieldExpression>

</textField>

- <staticText>

<reportElement mode="Transparent" x="3" y="6" width="27" height="14" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica-Bold" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded="false" pdfEncoding="Cp1250" isStrikeThrough="false" />

</textElement>

- <text>

- <![CDATA[ API: ]]>

</text>

</staticText>

- <staticText>

<reportElement mode="Transparent" x="3" y="25" width="56" height="14" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica-Bold" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded="false" pdfEncoding="Cp1250" isStrikeThrough="false" />

</textElement>

- <text>

- <![CDATA[ Well Name: ]]>

</text>

</staticText>

- <staticText>

<reportElement mode="Transparent" x="3" y="42" width="71" height="14" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica-Bold" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded="false" pdfEncoding="Cp1250" isStrikeThrough="false" />

</textElement>

- <text>

- <![CDATA[ Surface Lease: ]]>

</text>

</staticText>

- <staticText>

<reportElement mode="Transparent" x="3" y="60" width="71" height="14" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica-Bold" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded="false" pdfEncoding="Cp1250" isStrikeThrough="false" />

</textElement>

- <text>

- <![CDATA[ Bottom Lease: ]]>

</text>

</staticText>

- <staticText>

<reportElement mode="Transparent" x="179" y="6" width="27" height="14" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica-Bold" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded="false" pdfEncoding="Cp1250" isStrikeThrough="false" />

</textElement>

- <text>

- <![CDATA[ ST: ]]>

</text>

</staticText>

- <staticText>

<reportElement mode="Transparent" x="179" y="25" width="35" height="14" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica-Bold" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded="false" pdfEncoding="Cp1250" isStrikeThrough="false" />

</textElement>

- <text>

- <![CDATA[ Status: ]]>

</text>

</staticText>

- <staticText>

<reportElement mode="Transparent" x="180" y="42" width="27" height="14" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica-Bold" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded="false" pdfEncoding="Cp1250" isStrikeThrough="false" />

</textElement>

- <text>

- <![CDATA[ Area: ]]>

</text>

</staticText>

- <staticText>

<reportElement mode="Transparent" x="180" y="60" width="27" height="14" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica-Bold" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded="false" pdfEncoding="Cp1250" isStrikeThrough="false" />

</textElement>

- <text>

- <![CDATA[ Area: ]]>

</text>

</staticText>

- <staticText>

<reportElement mode="Transparent" x="281" y="6" width="27" height="14" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica-Bold" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded="false" pdfEncoding="Cp1250" isStrikeThrough="false" />

</textElement>

- <text>

- <![CDATA[ BP: ]]>

</text>

</staticText>

- <staticText>

<reportElement mode="Transparent" x="281" y="25" width="27" height="14" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica-Bold" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded="false" pdfEncoding="Cp1250" isStrikeThrough="false" />

</textElement>

- <text>

- <![CDATA[ Type: ]]>

</text>

</staticText>

- <staticText>

<reportElement mode="Transparent" x="281" y="42" width="31" height="14" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica-Bold" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded="false" pdfEncoding="Cp1250" isStrikeThrough="false" />

</textElement>

- <text>

- <![CDATA[ Block: ]]>

</text>

</staticText>

- <staticText>

<reportElement mode="Transparent" x="281" y="60" width="31" height="14" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica-Bold" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded="false" pdfEncoding="Cp1250" isStrikeThrough="false" />

</textElement>

- <text>

- <![CDATA[ Block: ]]>

</text>

</staticText>

- <staticText>

<reportElement mode="Transparent" x="381" y="6" width="65" height="14" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica-Bold" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded="false" pdfEncoding="Cp1250" isStrikeThrough="false" />

</textElement>

- <text>

- <![CDATA[ Water Depth: ]]>

</text>

</staticText>

- <staticText>

<reportElement mode="Transparent" x="3" y="78" width="103" height="14" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica-Bold" size="10" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded="false" pdfEncoding="Cp1250" isStrikeThrough="false" />

</textElement>

- <text>

- <![CDATA[ Permit Primary Type: ]]>

</text>

</staticText>

- <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None">

<reportElement mode="Transparent" x="112" y="78" width="80" height="14" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded="false" pdfEncoding="Cp1250" isStrikeThrough="false" />

</textElement>

- <textFieldExpression class="java.lang.String">

- <![CDATA[ $F{APM_OP_CD} ]]>

</textFieldExpression>

</textField>

</band>

</pageHeader>

- <columnHeader>

- <band height="55">

- <subreport isUsingCache="true">

<reportElement mode="Transparent" x="3" y="9" width="548" height="20" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="true" />

- <subreportParameter name="PSNAPM">

- <subreportParameterExpression>

- <![CDATA[

$P{PSNAPM}

 

]]>

</subreportParameterExpression>

</subreportParameter>

- <connectionExpression>

- <![CDATA[

$P{REPORT_CONNECTION}

 

]]>

</connectionExpression>

- <subreportExpression class="java.lang.String">

- <![CDATA[

$P{APMSubReport2}

 

]]>

</subreportExpression>

</subreport>

</band>

</columnHeader>

- <detail>

<band height="19" />

</detail>

- <columnFooter>

<band height="12" />

</columnFooter>

- <pageFooter>

<band height="33" />

</pageFooter>

- <summary>

<band height="5" />

</summary>

</jasperReport>

 

subreport

-------------

<?xml version="1.0" encoding="UTF-8" ?>

- <!-- Created with iReport - A designer for JasperReports -->

<!DOCTYPE jasperReport (View Source for full doctype...)>

- <jasperReport name="APMSubReport2" columnCount="1" printOrder="Vertical" orientation="Portrait" pageWidth="595" pageHeight="576" columnWidth="535" columnSpacing="0" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20" whenNoDataType="AllSectionsNoDetail" isTitleNewPage="false" isSummaryNewPage="false">

- <parameter name="PSNAPM" isForPrompting="true" class="java.lang.Integer">

- <defaultValueExpression>

- <![CDATA[ new Integer(1222) ]]>

</defaultValueExpression>

</parameter>

- <queryString>

- <![CDATA[

select APM_SUBOP_CD

from e_apm_suboperations

where rownum < 20

 

]]>

</queryString>

<field name="APM_SUBOP_CD" class="java.lang.String" />

- <group name="pagebreak" isStartNewColumn="false" isStartNewPage="false" isResetPageNumber="false" isReprintHeaderOnEachPage="false" minHeightToStartNewPage="0">

- <groupExpression>

- <![CDATA[

$V{REPORT_COUNT}

 

]]>

</groupExpression>

- <groupHeader>

- <band height="26">

- <staticText>

<reportElement mode="Transparent" x="27" y="6" width="150" height="17" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded="false" pdfEncoding="Cp1250" isStrikeThrough="false" />

</textElement>

- <text>

- <![CDATA[ ETSET2 ]]>

</text>

</staticText>

- <textField isStretchWithOverflow="false" pattern="" isBlankWhenNull="false" evaluationTime="Now" hyperlinkType="None">

<reportElement mode="Transparent" x="239" y="6" width="158" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded="false" pdfEncoding="Cp1250" isStrikeThrough="false" />

</textElement>

- <textFieldExpression class="java.lang.String">

- <![CDATA[ $F{APM_SUBOP_CD} ]]>

</textFieldExpression>

</textField>

</band>

</groupHeader>

- <groupFooter>

<band height="24" />

</groupFooter>

</group>

- <title>

- <band height="28">

- <staticText>

<reportElement mode="Transparent" x="143" y="7" width="218" height="18" forecolor="#000000" backcolor="#FFFF00" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded="false" pdfEncoding="Cp1250" isStrikeThrough="false" />

</textElement>

- <text>

- <![CDATA[ TEST CONNECTION OF SUB REPORTS ]]>

</text>

</staticText>

</band>

</title>

- <pageHeader>

- <band height="27">

- <staticText>

<reportElement mode="Transparent" x="18" y="6" width="110" height="18" forecolor="#000000" backcolor="#FFFFFF" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" />

- <textElement textAlignment="Left" verticalAlignment="Top" lineSpacing="Single">

<font fontName="" pdfFontName="Helvetica" size="10" isBold="false" isItalic="false" isUnderline="false" isPdfEmbedded="false" pdfEncoding="Cp1250" isStrikeThrough="false" />

</textElement>

- <text>

- <![CDATA[ TEST ]]>

</text>

</staticText>

</band>

</pageHeader>

- <columnHeader>

<band height="20" />

</columnHeader>

- <detail>

<band height="19" />

</detail>

- <columnFooter>

<band height="11" />

</columnFooter>

- <pageFooter>

<band height="11" />

</pageFooter>

- <summary>

<band height="9" />

</summary>

</jasperReport>

 

 

 

 

 

By: Teodor Danciu - teodord

RE: Stuck at 'Opening Connection' - URGENT

2003-05-08 09:01

 

Hi,

 

You have placed the subreport on the

column header of the master report.

 

This is a little strange, because if the subreport will

have enough records in it and will overflow to the

next page/column, then the column header will

be redisplayed again... and again it will not fit.

This way the engine enters an infinite loop trying

to create new columns due to a perpetual

overflowing column header.

 

Try to reconsider your report layout.

 

Thank you,

Teodor

 

 

 

 

 

By: Sohan Kasula - skasula

RE: Stuck at 'Opening Connection' - URGENT

2003-05-08 09:41

Thanks!, I moved the sub-report to detail section and it worked.

I followed the design by using tips&tricks document for "Bands Larer than one page". I overlooked the wording "might even work" for Page and Column Headers. So I know now that it doesn't work in Column Headers.

My mistake and thanks a lot.

Sohan

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...