Jaspersoft studio - colspan grid layout

Posted on May 19, 2021 at 12:28am

I have to make a calendar with weeks and months.

Month -> |   month1  |     month2   |     month3    |
Weeks -> |w1|w2|w3|w4|w5|w6|w7|w8|w9|w10|w11|w12|w13|

A month can have 4 or 5 weeks.

I would like the month columns to take the value 4 or 5 which is returned by an SQL stored procedure. But when I put this value from propertyExpression, it does not work.

My details band is in grid layout.

Have you any ideas to make that ?

This my textfiels code :

<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.grid.JSSGridBagLayout"/>
            <textField>
                <reportElement positionType="Float" mode="Opaque" x="0" y="0" width="90" height="21" backcolor="rgba(255, 255, 255, 0.0)" uuid="13ae2fa8-c4b2-4c56-b1d9-35c78a3241f2">
                    <propertyExpression name="com.jaspersoft.layout.grid.colspan"><![CDATA[$F{countM1}]]></propertyExpression>
                    <propertyExpression name="net.sf.jasperreports.style.backcolor"><![CDATA[$F{stylecMois1}]]></propertyExpression>
                    <propertyExpression name="com.jaspersoft.layout.grid.x"><![CDATA[$F{gridx}]]></propertyExpression>
                    <propertyExpression name="com.jaspersoft.layout.grid.y"><![CDATA[$F{gridy}]]></propertyExpression>
                    <propertyExpression name="com.jaspersoft.layout.grid.weight.x"><![CDATA[$F{colWeight}]]></propertyExpression>
                    <propertyExpression name="com.jaspersoft.layout.grid.weight.y"><![CDATA[$F{rowWeight}]]></propertyExpression>
                    <propertyExpression name="com.jaspersoft.layout.grid.rowspan"><![CDATA[$F{rowspan}]]></propertyExpression>
                    <propertyExpression name="com.jaspersoft.layout.grid.weight.fixed"><![CDATA[$F{fixed}]]></propertyExpression>
                </reportElement>
                <box>
                    <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                    <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/>
                </box>
                <textFieldExpression><![CDATA[$F{mois1}]]></textFieldExpression>
            </textField>

Thanks

Attachments: