yvkvijay

How to apply crosstab colors for measures based on row group values.. Eg;- Suppose we have four groups ..If second group is not null it has to apply on color for crosstab measure values i.e 1to 12 columns and in similar way for third group. colors has to be applied for measure values not for rowgroup values in crosstab Can anyone guide me how to do it??

Hi How to do grouping and ungrouping with excel ouput uisn ireport for four levels ?? can anyone please give me sample jrxml file how to do it?? Any suggestions/help is appreciated I was doing like this. can anyone correct me what i am doing wrong? <group name="first"> <groupExpression><![CDATA[$F{first}]]></groupExpression> <groupHeader> <band height="21"> <textField> <reportElement x="0" y="0" width="100" height="20"/> <textElement/> <textFieldExpression><![CDATA[$F{first}]]></textFieldExpression> </textField> </band> </groupHeader> </group> <group name="second" isStartNewColumn="true"> <groupExpression><![CDATA[$F{second}]]></groupExpression> <groupHeader> <band height="20"> <textField> <reportElement x="0" y="0" width="100" height="20"> <property name="net.sf.jasperreports.export.xls.row.outline.level.1" value="Body"/> </reportElement> <textElement/> <textFieldExpression><![CDATA[$F{second}]]></textFieldExpression> </textField> </band> </groupHeader> </group> <group name="third"> <groupExpression><![CDATA[$F{third}]]></groupExpression> <groupHeader> <band height="22"> <textField> <reportElement x="0" y="0" width="100" height="20"> <property name="net.sf.jasperreports.export.xls.row.outline.level.2" value="Body"/> </reportElement> <textElement/> <textFieldExpression><![CDATA[$F{third}]]></textFieldExpression> </textField> </band> </groupHeader> </group> <group name="fourth"> <groupExpression><![CDATA[$F{fourth}]]></groupExpression> <groupHeader> <band height="21"> <textField> <reportElement x="0" y="0" width="100" height="20"> <property name="net.sf.jasperreports.export.xls.row.outline.level.3" value="Body"/> </reportElement> <textElement/> <textFieldExpression><![CDATA[$F{fourth}]]></textFieldExpression> </textField> </band> </groupHeader> </group>