Jump to content

header of crosstab not printing in Excel format

glassner

By glassner
in Products

 Share

Recommended Posts

glassner Enthusiast

glassner

Posted
Posted

The entire header of my crosstab does not appear on my report if I export it in Excel, but it does appear in any other format (say, PDF).

I converted the Excel report into XML and then opened it with a text editor: the header of the report is just not there !

As I said, the header appears in any other type of export. The crosstab xml is below. Anyone would be kind enough to help in this ?

 

 <crosstab>
     <reportElement style="Crosstab Data Text" positionType="Float" x="14" y="33" width="548" height="67"/>
     <rowGroup name="courseCategoryCode" width="77">
      <bucket>
       <bucketExpression class="java.lang.String"><![CDATA[$F{courseCategoryCode}]]></bucketExpression>
      </bucket>
      <crosstabRowHeader>
       <cellContents backcolor="#FFFFFF" mode="Opaque">
        <box>
         <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/>
        </box>
        <textField>
         <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="-3" width="77" height="29" backcolor="#CCCCFF"/>
         <textElement verticalAlignment="Middle">
          <font size="7" isBold="false"/>
         </textElement>
         <textFieldExpression class="java.lang.String"><![CDATA[$V{courseCategoryCode} + " Totals"]]></textFieldExpression>
        </textField>
       </cellContents>
      </crosstabRowHeader>
      <crosstabTotalRowHeader>
       <cellContents backcolor="#FFFFFF"/>
      </crosstabTotalRowHeader>
     </rowGroup>
     <columnGroup name="academicDegreeType" height="35" totalPosition="End">
      <bucket>
       <bucketExpression class="java.lang.String"><![CDATA[$F{academicDegreeType}]]></bucketExpression>
      </bucket>
      <crosstabColumnHeader>
       <cellContents backcolor="#FFFFFF" mode="Opaque">
        <box>
         <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/>
        </box>
        <textField>
         <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="0" width="50" height="20" backcolor="#CCCCCC"/>
         <textElement verticalAlignment="Middle">
          <font size="8" isBold="true"/>
         </textElement>
         <textFieldExpression class="java.lang.String"><![CDATA[$V{academicDegreeType} == "DOCTORATE" ? "PhD" :
$V{academicDegreeType} == "NT MASTER" ? "NT MS" :
$V{academicDegreeType} == "MASTER" ? "MS" :
$V{academicDegreeType} == "OTHER" ? "Other":
$V{academicDegreeType} == "NO DEGREE" ? "Non Degree" :
$V{academicDegreeType}]]></textFieldExpression>
        </textField>
        <staticText>
         <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="20" width="25" height="14" backcolor="#CCCCCC"/>
         <textElement verticalAlignment="Top">
          <font size="7" isBold="true"/>
         </textElement>
         <text><![CDATA[A]]></text>
        </staticText>
        <staticText>
         <reportElement style="Crosstab Data Text" mode="Opaque" x="25" y="20" width="25" height="14" backcolor="#CCCCCC"/>
         <textElement verticalAlignment="Top">
          <font size="7" isBold="true"/>
         </textElement>
         <text><![CDATA[P]]></text>
        </staticText>
       </cellContents>
      </crosstabColumnHeader>
      <crosstabTotalColumnHeader>
       <cellContents backcolor="#FFFFFF" mode="Opaque">
        <box>
         <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/>
        </box>
        <staticText>
         <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="0" width="106" height="20" backcolor="#CCCCCC"/>
         <textElement textAlignment="Center" verticalAlignment="Middle">
          <font size="8" isBold="true"/>
         </textElement>
         <text><![CDATA[Total Approved]]></text>
        </staticText>
        <staticText>
         <reportElement style="Crosstab Data Text" mode="Opaque" x="78" y="20" width="28" height="14" backcolor="#CCCCCC"/>
         <textElement verticalAlignment="Top">
          <font size="7" isBold="true"/>
         </textElement>
         <text><![CDATA[ManYears P]]></text>
        </staticText>
        <staticText>
         <reportElement style="Crosstab Data Text" mode="Opaque" x="25" y="20" width="25" height="14" forecolor="#000000" backcolor="#CCCCCC"/>
         <textElement verticalAlignment="Top">
          <font size="7" isBold="true"/>
         </textElement>
         <text><![CDATA[P]]></text>
        </staticText>
        <staticText>
         <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="20" width="25" height="14" backcolor="#CCCCCC"/>
         <textElement verticalAlignment="Top">
          <font size="7" isBold="true"/>
         </textElement>
         <text><![CDATA[A]]></text>
        </staticText>
        <staticText>
         <reportElement style="Crosstab Data Text" mode="Opaque" x="50" y="20" width="28" height="14" backcolor="#CCCCCC"/>
         <textElement verticalAlignment="Top">
          <font size="7" isBold="true"/>
         </textElement>
         <text><![CDATA[ManYears A]]></text>
        </staticText>
       </cellContents>
      </crosstabTotalColumnHeader>
     </columnGroup>
     <measure name="ACTUAL_DEGREE_QTYMeasure" class="java.math.BigDecimal" calculation="Sum">
      <measureExpression><![CDATA[$F{actualDegreeQty}]]></measureExpression>
     </measure>
     <measure name="PROJECTED_DEGREE_QTYMeasure" class="java.math.BigDecimal" calculation="Sum">
      <measureExpression><![CDATA[$F{projectedDegreeQty}]]></measureExpression>
     </measure>
     <measure name="PROJECTED_MANYEARS_QTYMeasure" class="java.math.BigDecimal" calculation="Sum">
      <measureExpression><![CDATA[$F{projectedApprovedManyears}]]></measureExpression>
     </measure>
     <measure name="ACTUAL_MANYEARS_QTYMeasure" class="java.math.BigDecimal" calculation="Sum">
      <measureExpression><![CDATA[$F{actualApprovedManyears}]]></measureExpression>
     </measure>
     <crosstabCell width="50" height="26">
      <cellContents backcolor="#FFFFFF">
       <box>
        <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/>
       </box>
       <textField>
        <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="-3" width="25" height="29" backcolor="#CCCCFF"/>
        <textElement verticalAlignment="Middle">
         <font size="7" isBold="true"/>
        </textElement>
        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{ACTUAL_DEGREE_QTYMeasure} == null ?  "0" : $V{ACTUAL_DEGREE_QTYMeasure}]]></textFieldExpression>
       </textField>
       <textField>
        <reportElement style="Crosstab Data Text" mode="Opaque" x="25" y="-3" width="25" height="29" backcolor="#CCCCFF"/>
        <textElement verticalAlignment="Middle">
         <font size="7" isBold="true"/>
        </textElement>
        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{PROJECTED_DEGREE_QTYMeasure} == null ? "0" : $V{PROJECTED_DEGREE_QTYMeasure}]]></textFieldExpression>
       </textField>
      </cellContents>
     </crosstabCell>
     <crosstabCell height="25" rowTotalGroup="courseCategoryCode">
      <cellContents backcolor="#FFFFFF" mode="Opaque">
       <box>
        <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/>
       </box>
       <textField>
        <reportElement style="Crosstab Data Text" x="0" y="0" width="50" height="25"/>
        <textElement/>
        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{ACTUAL_DEGREE_QTYMeasure}]]></textFieldExpression>
       </textField>
      </cellContents>
     </crosstabCell>
     <crosstabCell width="106" height="26" columnTotalGroup="academicDegreeType">
      <cellContents backcolor="#FFFFFF" mode="Opaque">
       <box>
        <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/>
       </box>
       <textField>
        <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="-3" width="25" height="29" backcolor="#CCCCFF"/>
        <textElement verticalAlignment="Middle">
         <font size="7" isBold="true"/>
        </textElement>
        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{ACTUAL_DEGREE_QTYMeasure}]]></textFieldExpression>
       </textField>
       <textField>
        <reportElement style="Crosstab Data Text" mode="Opaque" x="25" y="-3" width="25" height="29" forecolor="#000000" backcolor="#CCCCFF"/>
        <textElement verticalAlignment="Middle">
         <font size="7" isBold="true"/>
        </textElement>
        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{PROJECTED_DEGREE_QTYMeasure}]]></textFieldExpression>
       </textField>
       <textField>
        <reportElement style="Crosstab Data Text" mode="Opaque" x="50" y="-3" width="28" height="29" backcolor="#CCCCFF"/>
        <textElement verticalAlignment="Middle">
         <font size="7" isBold="true"/>
        </textElement>
        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{ACTUAL_MANYEARS_QTYMeasure} ==  null ? "0" : $V{ACTUAL_MANYEARS_QTYMeasure}]]></textFieldExpression>
       </textField>
       <textField>
        <reportElement style="Crosstab Data Text" mode="Opaque" x="78" y="-3" width="28" height="29" backcolor="#CCCCFF"/>
        <textElement verticalAlignment="Middle">
         <font size="7" isBold="true"/>
        </textElement>
        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{PROJECTED_MANYEARS_QTYMeasure} == null ? "0" : $V{PROJECTED_MANYEARS_QTYMeasure}]]></textFieldExpression>
       </textField>
      </cellContents>
     </crosstabCell>
     <crosstabCell rowTotalGroup="courseCategoryCode" columnTotalGroup="academicDegreeType">
      <cellContents backcolor="#FFFFFF" mode="Opaque">
       <box>
        <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/>
       </box>
       <textField>
        <reportElement style="Crosstab Data Text" x="0" y="0" width="50" height="25"/>
        <textElement/>
        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{ACTUAL_DEGREE_QTYMeasure}]]></textFieldExpression>
       </textField>
      </cellContents>
     </crosstabCell>
    </crosstab>
   </band>
  </groupFooter>
 </group>
 <group name="CATEGORY SUBTYPE CODE">
  <groupExpression><![CDATA[$F{courseCategorySubtypeCode}]]></groupExpression>
  <groupHeader>
   <band height="15"/>
  </groupHeader>
  <groupFooter>
   <band height="153">
    <crosstab>
     <reportElement x="14" y="20" width="557" height="96"/>
     <crosstabDataset>
      <dataset resetType="Group" resetGroup="CATEGORY SUBTYPE CODE"/>
     </crosstabDataset>
     <rowGroup name="courseProgramCode" width="58" totalPosition="End">
      <bucket>
       <bucketExpression class="java.lang.String"><![CDATA[$F{courseProgramCode}]]></bucketExpression>
      </bucket>
      <crosstabRowHeader>
       <cellContents backcolor="#FFFFFF" mode="Opaque">
        <box>
         <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/>
        </box>
        <textField>
         <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="0" width="58" height="25"/>
         <textElement verticalAlignment="Middle">
          <font size="7" isBold="true"/>
         </textElement>
         <textFieldExpression class="java.lang.String"><![CDATA[$V{courseProgramCode} == null ? "-" : $V{courseProgramCode}]]></textFieldExpression>
        </textField>
       </cellContents>
      </crosstabRowHeader>
      <crosstabTotalRowHeader>
       <cellContents backcolor="#FFFFFF" mode="Opaque">
        <box>
         <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/>
        </box>
        <staticText>
         <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="0" width="121" height="27" backcolor="#CCCCFF"/>
         <textElement textAlignment="Center" verticalAlignment="Middle"/>
         <text><![CDATA[Total]]></text>
        </staticText>
       </cellContents>
      </crosstabTotalRowHeader>
     </rowGroup>
     <rowGroup name="faculty_code" width="63">
      <bucket>
       <bucketExpression class="java.lang.String"><![CDATA[$F{facultyPrepCode}]]></bucketExpression>
      </bucket>
      <crosstabRowHeader>
       <cellContents backcolor="#FFFFFF" mode="Transparent">
        <textField>
         <reportElement style="Crosstab Data Text" mode="Transparent" x="0" y="0" width="63" height="25"/>
         <textElement verticalAlignment="Middle">
          <font size="7" isBold="true"/>
         </textElement>
         <textFieldExpression class="java.lang.String"><![CDATA[$V{faculty_code} == null ? "-" : $V{faculty_code}]]></textFieldExpression>
        </textField>
       </cellContents>
      </crosstabRowHeader>
      <crosstabTotalRowHeader>
       <cellContents backcolor="#FFFFFF"/>
      </crosstabTotalRowHeader>
     </rowGroup>
     <columnGroup name="academicDegreeType" height="41" totalPosition="End">
      <bucket>
       <bucketExpression class="java.lang.String"><![CDATA[$F{academicDegreeType}]]></bucketExpression>
      </bucket>
      <crosstabColumnHeader>
       <cellContents backcolor="#FFFFFF" mode="Opaque">
        <box>
         <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/>
        </box>
        <textField>
         <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="0" width="50" height="20" backcolor="#CCCCCC"/>
         <textElement textAlignment="Center" verticalAlignment="Middle">
          <font size="8" isBold="true"/>
         </textElement>
         <textFieldExpression class="java.lang.String"><![CDATA[$V{academicDegreeType} == "DOCTORATE" ? "PhD" :
$V{academicDegreeType} == "NT MASTER" ? "NT MS" :
$V{academicDegreeType} == "MASTER" ? "MS" :
$V{academicDegreeType} == "OTHER" ? "Other":
$V{academicDegreeType} == "NO DEGREE" ? "Non Degree" :
$V{academicDegreeType}]]></textFieldExpression>
        </textField>
        <staticText>
         <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="21" width="25" height="19" backcolor="#CCCCCC"/>
         <textElement>
          <font size="7" isBold="true"/>
         </textElement>
         <text><![CDATA[A]]></text>
        </staticText>
        <staticText>
         <reportElement style="Crosstab Data Text" mode="Opaque" x="25" y="21" width="25" height="19" backcolor="#CCCCCC"/>
         <textElement>
          <font size="7" isBold="true"/>
         </textElement>
         <text><![CDATA[P]]></text>
        </staticText>
       </cellContents>
      </crosstabColumnHeader>
      <crosstabTotalColumnHeader>
       <cellContents backcolor="#FFFFFF" mode="Opaque">
        <box>
         <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/>
        </box>
        <staticText>
         <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="0" width="120" height="20" backcolor="#CCCCCC"/>
         <textElement textAlignment="Center" verticalAlignment="Middle">
          <font size="8" isBold="true"/>
         </textElement>
         <text><![CDATA[Total Approved]]></text>
        </staticText>
        <staticText>
         <reportElement style="Crosstab Data Text" mode="Opaque" x="30" y="21" width="30" height="19" forecolor="#000000" backcolor="#CCCCCC"/>
         <textElement>
          <font size="7" isBold="true"/>
         </textElement>
         <text><![CDATA[P]]></text>
        </staticText>
        <staticText>
         <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="21" width="30" height="19" backcolor="#CCCCCC"/>
         <textElement>
          <font size="7" isBold="true"/>
         </textElement>
         <text><![CDATA[A]]></text>
        </staticText>
        <staticText>
         <reportElement style="Crosstab Data Text" mode="Opaque" x="60" y="21" width="30" height="19" backcolor="#CCCCCC"/>
         <textElement>
          <font size="7" isBold="true"/>
         </textElement>
         <text><![CDATA[ManYears A]]></text>
        </staticText>
        <staticText>
         <reportElement style="Crosstab Data Text" mode="Opaque" x="90" y="21" width="30" height="19" backcolor="#CCCCCC"/>
         <textElement>
          <font size="7" isBold="true"/>
         </textElement>
         <text><![CDATA[ManYears P]]></text>
        </staticText>
       </cellContents>
      </crosstabTotalColumnHeader>
     </columnGroup>
     <measure name="ACTUAL_DEGREE_QTYMeasure" class="java.math.BigDecimal" calculation="Sum">
      <measureExpression><![CDATA[$F{actualDegreeQty}]]></measureExpression>
     </measure>
     <measure name="PROJECTED_DEGREE_QTYMeasure" class="java.math.BigDecimal" calculation="Sum">
      <measureExpression><![CDATA[$F{projectedDegreeQty}]]></measureExpression>
     </measure>
     <measure name="PROJECTED_MANYEARS_QTYMeasure" class="java.math.BigDecimal" calculation="Sum">
      <measureExpression><![CDATA[$F{projectedApprovedManyears}]]></measureExpression>
     </measure>
     <measure name="ACTUAL_MANYEARS_QTYMeasure" class="java.math.BigDecimal" calculation="Sum">
      <measureExpression><![CDATA[$F{actualApprovedManyears}]]></measureExpression>
     </measure>
     <crosstabCell width="50" height="25">
      <cellContents>
       <box>
        <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/>
       </box>
       <textField>
        <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="0" width="25" height="25" backcolor="#CCCCCC"/>
        <textElement verticalAlignment="Middle">
         <font size="7" isBold="true"/>
        </textElement>
        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{ACTUAL_DEGREE_QTYMeasure} == null ? "0" : $V{ACTUAL_DEGREE_QTYMeasure}]]></textFieldExpression>
       </textField>
       <textField>
        <reportElement style="Crosstab Data Text" mode="Opaque" x="25" y="0" width="25" height="25" backcolor="#FFFFFF"/>
        <textElement verticalAlignment="Middle">
         <font size="7" isBold="true"/>
        </textElement>
        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{PROJECTED_DEGREE_QTYMeasure} == null ? "0" : $V{PROJECTED_DEGREE_QTYMeasure}]]></textFieldExpression>
       </textField>
      </cellContents>
     </crosstabCell>
     <crosstabCell width="134" columnTotalGroup="academicDegreeType">
      <cellContents backcolor="#FFFFFF" mode="Opaque">
       <box>
        <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/>
       </box>
       <textField>
        <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="0" width="30" height="25" backcolor="#CCCCCC"/>
        <textElement verticalAlignment="Middle">
         <font size="7" isBold="true"/>
        </textElement>
        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{ACTUAL_DEGREE_QTYMeasure}]]></textFieldExpression>
       </textField>
       <textField>
        <reportElement style="Crosstab Data Text" mode="Opaque" x="30" y="0" width="30" height="25" forecolor="#000000" backcolor="#FFFFFF"/>
        <textElement verticalAlignment="Middle">
         <font size="7" isBold="true"/>
        </textElement>
        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{PROJECTED_DEGREE_QTYMeasure}]]></textFieldExpression>
       </textField>
       <textField>
        <reportElement style="Crosstab Data Text" mode="Opaque" x="60" y="0" width="30" height="25" backcolor="#CCCCCC"/>
        <textElement verticalAlignment="Middle">
         <font size="7" isBold="true"/>
        </textElement>
        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{ACTUAL_MANYEARS_QTYMeasure} ==  null ? "0" : $V{ACTUAL_MANYEARS_QTYMeasure}]]></textFieldExpression>
       </textField>
       <textField>
        <reportElement style="Crosstab Data Text" mode="Opaque" x="90" y="0" width="30" height="25" backcolor="#FFFFFF"/>
        <textElement verticalAlignment="Middle">
         <font size="7" isBold="true"/>
        </textElement>
        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{PROJECTED_MANYEARS_QTYMeasure} == null ? "0" : $V{PROJECTED_MANYEARS_QTYMeasure}]]></textFieldExpression>
       </textField>
      </cellContents>
     </crosstabCell>
     <crosstabCell width="50" height="27" rowTotalGroup="courseProgramCode">
      <cellContents backcolor="#FFF3E6" mode="Opaque">
       <box>
        <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/>
       </box>
       <textField>
        <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="0" width="25" height="25" backcolor="#CCCCFF"/>
        <textElement verticalAlignment="Middle">
         <font size="7" isBold="true"/>
        </textElement>
        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{ACTUAL_DEGREE_QTYMeasure} == null ? "0" : $V{ACTUAL_DEGREE_QTYMeasure}]]></textFieldExpression>
       </textField>
       <textField>
        <reportElement style="Crosstab Data Text" mode="Opaque" x="25" y="0" width="25" height="25" backcolor="#CCCCFF"/>
        <textElement verticalAlignment="Middle">
         <font size="7" isBold="true"/>
        </textElement>
        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{PROJECTED_DEGREE_QTYMeasure} == null ? "0" : $V{PROJECTED_DEGREE_QTYMeasure}]]></textFieldExpression>
       </textField>
      </cellContents>
     </crosstabCell>
     <crosstabCell width="134" height="27" rowTotalGroup="courseProgramCode" columnTotalGroup="academicDegreeType">
      <cellContents backcolor="#FFFFFF" mode="Opaque">
       <box>
        <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/>
       </box>
       <textField>
        <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="0" width="30" height="25" backcolor="#CCCCFF"/>
        <textElement verticalAlignment="Middle">
         <font size="7" isBold="true"/>
        </textElement>
        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{ACTUAL_DEGREE_QTYMeasure}]]></textFieldExpression>
       </textField>
       <textField>
        <reportElement style="Crosstab Data Text" mode="Opaque" x="30" y="0" width="30" height="25" backcolor="#CCCCFF"/>
        <textElement verticalAlignment="Middle">
         <font size="7" isBold="true"/>
        </textElement>
        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{PROJECTED_DEGREE_QTYMeasure}]]></textFieldExpression>
       </textField>
       <textField>
        <reportElement style="Crosstab Data Text" mode="Opaque" x="60" y="0" width="30" height="25" backcolor="#CCCCFF"/>
        <textElement verticalAlignment="Middle">
         <font size="7" isBold="true"/>
        </textElement>
        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{ACTUAL_MANYEARS_QTYMeasure}]]></textFieldExpression>
       </textField>
       <textField>
        <reportElement style="Crosstab Data Text" mode="Opaque" x="90" y="0" width="30" height="25" backcolor="#CCCCFF"/>
        <textElement verticalAlignment="Middle">
         <font size="7" isBold="true"/>
        </textElement>
        <textFieldExpression class="java.math.BigDecimal"><![CDATA[$V{PROJECTED_MANYEARS_QTYMeasure}]]></textFieldExpression>
       </textField>
      </cellContents>
     </crosstabCell>
     <crosstabCell rowTotalGroup="faculty_code">
      <cellContents/>
     </crosstabCell>
     <crosstabCell rowTotalGroup="faculty_code" columnTotalGroup="academicDegreeType">
      <cellContents/>
     </crosstabCell>
    </crosstab>

Link to comment
Share on other sites
  • Replies 4
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

glassner Enthusiast

glassner

Posted
  • Author
Posted

ANyone could help me figure out why the columnGroup does not show in Excel format ?

 

 <columnGroup name="academicDegreeType" height="35" totalPosition="End">
      <bucket>
       <bucketExpression class="java.lang.String"><![CDATA[$F{academicDegreeType}]]></bucketExpression>
      </bucket>
      <crosstabColumnHeader>
       <cellContents backcolor="#FFFFFF" mode="Opaque">
        <box>
         <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/>
        </box>
        <textField>
         <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="0" width="50" height="20" backcolor="#CCCCCC"/>
         <textElement verticalAlignment="Middle">
          <font size="8" isBold="true"/>
         </textElement>
         <textFieldExpression class="java.lang.String"><![CDATA[$V{academicDegreeType} == "DOCTORATE" ? "PhD" :
$V{academicDegreeType} == "NT MASTER" ? "NT MS" :
$V{academicDegreeType} == "MASTER" ? "MS" :
$V{academicDegreeType} == "OTHER" ? "Other":
$V{academicDegreeType} == "NO DEGREE" ? "Non Degree" :
$V{academicDegreeType}]]></textFieldExpression>
        </textField>
        <staticText>
         <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="20" width="25" height="14" backcolor="#CCCCCC"/>
         <textElement verticalAlignment="Top">
          <font size="7" isBold="true"/>
         </textElement>
         <text><![CDATA[A]]></text>
        </staticText>
        <staticText>
         <reportElement style="Crosstab Data Text" mode="Opaque" x="25" y="20" width="25" height="14" backcolor="#CCCCCC"/>
         <textElement verticalAlignment="Top">
          <font size="7" isBold="true"/>
         </textElement>
         <text><![CDATA[P]]></text>
        </staticText>
       </cellContents>
      </crosstabColumnHeader>
      <crosstabTotalColumnHeader>
       <cellContents backcolor="#FFFFFF" mode="Opaque">
        <box>
         <pen lineWidth="0.5" lineStyle="Solid" lineColor="#FFFFFF"/>
        </box>
        <staticText>
         <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="0" width="106" height="20" backcolor="#CCCCCC"/>
         <textElement textAlignment="Center" verticalAlignment="Middle">
          <font size="8" isBold="true"/>
         </textElement>
         <text><![CDATA[Total Approved]]></text>
        </staticText>
        <staticText>
         <reportElement style="Crosstab Data Text" mode="Opaque" x="78" y="20" width="28" height="14" backcolor="#CCCCCC"/>
         <textElement verticalAlignment="Top">
          <font size="7" isBold="true"/>
         </textElement>
         <text><![CDATA[ManYears P]]></text>
        </staticText>
        <staticText>
         <reportElement style="Crosstab Data Text" mode="Opaque" x="25" y="20" width="25" height="14" forecolor="#000000" backcolor="#CCCCCC"/>
         <textElement verticalAlignment="Top">
          <font size="7" isBold="true"/>
         </textElement>
         <text><![CDATA[P]]></text>
        </staticText>
        <staticText>
         <reportElement style="Crosstab Data Text" mode="Opaque" x="0" y="20" width="25" height="14" backcolor="#CCCCCC"/>
         <textElement verticalAlignment="Top">
          <font size="7" isBold="true"/>
         </textElement>
         <text><![CDATA[A]]></text>
        </staticText>
        <staticText>
         <reportElement style="Crosstab Data Text" mode="Opaque" x="50" y="20" width="28" height="14" backcolor="#CCCCCC"/>
         <textElement verticalAlignment="Top">
          <font size="7" isBold="true"/>
         </textElement>
         <text><![CDATA[ManYears A]]></text>
        </staticText>
       </cellContents>
      </crosstabTotalColumnHeader>
     </columnGroup>

Link to comment
Share on other sites
Teodor Danciu Grand Master

Teodor Danciu

Posted
Posted

Hi,

 

The text fields in the column group seem to go beyond the bottom of their containing cell.

This makes them overlap with the content of the first row cells.

Overlapping elements do not show up in grid-based export formats such as Excel, as indicated in one of our FAQs.

You just need to make the column header cell taller, so that the text fields inside it fit.

Use iReport designer.

 

I hope this helps.

Teodor

 

Link to comment
Share on other sites

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
 Share
Go to topic listing
×
×
  • Create New...

© 2024 Cloud Software Group,
Inc. All rights reserved.

Products

Explore