How to add empty rows table

[r.reddy.galla]

Hi,

I want add 5*5 (5 rows,5 column) empty rows table.

Please let me know the possibility for this.

Thanks

[reportdev]

check this jrxml. the trick is all in the querying techniques.

I'm using oracle. you can do the samething on other databases too.

 

<?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.2.0.final using JasperReports Library version 6.2.0  --><!-- 2017-05-11T09:04:28 --><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="empty_table" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="bccfd59a-8725-4ee9-b36b-b2a9fe2f7189">    <style name="Table_TH" mode="Opaque" backcolor="#F0F8FF">        <box>            <pen lineWidth="0.5" lineColor="#000000"/>            <topPen lineWidth="0.5" lineColor="#000000"/>            <leftPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>            <rightPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="Table_CH" mode="Opaque" backcolor="#BFE1FF">        <box>            <pen lineWidth="0.5" lineColor="#000000"/>            <topPen lineWidth="0.5" lineColor="#000000"/>            <leftPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>            <rightPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <style name="Table_TD" mode="Opaque" backcolor="#FFFFFF">        <box>            <pen lineWidth="0.5" lineColor="#000000"/>            <topPen lineWidth="0.5" lineColor="#000000"/>            <leftPen lineWidth="0.5" lineColor="#000000"/>            <bottomPen lineWidth="0.5" lineColor="#000000"/>            <rightPen lineWidth="0.5" lineColor="#000000"/>        </box>    </style>    <subDataset name="null" uuid="0c7ef6fb-a5e1-437d-87a4-1898ba4fc14f">        <property name="com.jaspersoft.studio.data.sql.tables" value=""/>        <property name="com.jaspersoft.studio.data.defaultdataadapter" value="PRODSUP"/>        <queryString>            <![CDATA[select null as ID, null as ID2, null as ID3, null as ID4, null as ID5  from dualunion allselect null as ID, null as ID2, null as ID3, null as ID4, null as ID5  from dualunion allselect null as ID, null as ID2, null as ID3, null as ID4, null as ID5  from dualunion allselect null as ID, null as ID2, null as ID3, null as ID4, null as ID5  from dualunion allselect null as ID, null as ID2, null as ID3, null as ID4, null as ID5  from dualunion allselect null as ID, null as ID2, null as ID3, null as ID4, null as ID5  from dual]]>        </queryString>        <field name="ID" class="java.lang.String"/>        <field name="ID2" class="java.lang.String"/>        <field name="ID3" class="java.lang.String"/>        <field name="ID4" class="java.lang.String"/>        <field name="ID5" class="java.lang.String"/>    </subDataset>    <queryString>        <![CDATA[select * From dual]]>    </queryString>    <field name="DUMMY" class="java.lang.String"/>    <background>        <band splitType="Stretch"/>    </background>    <detail>        <band height="30" splitType="Stretch">            <textField>                <reportElement x="0" y="0" width="100" height="30" uuid="b5a9e850-df88-4c6b-9ecd-bec44fb49a01"/>                <textFieldExpression><![CDATA[$F{DUMMY}]]></textFieldExpression>            </textField>        </band>    </detail>    <summary>        <band height="40" splitType="Stretch">            <componentElement>                <reportElement x="0" y="0" width="500" height="40" uuid="f2ee7347-c554-4add-9b8b-6f47292eb756">                    <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/>                </reportElement>                <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd">                    <datasetRun subDataset="null" uuid="7d8d7b3d-f6dd-4d7f-a4b2-82a80a132c88">                        <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>                    </datasetRun>                    <jr:column width="100" uuid="8169a126-a84b-40b3-bc3a-df116bd8f27f">                        <property name="com.jaspersoft.studio.unit.width" value="pixel"/>                        <property name="com.jaspersoft.studio.unit.height" value="pixel"/>                        <jr:columnHeader style="Table_CH" height="20">                            <property name="com.jaspersoft.studio.unit.height" value="px"/>                        </jr:columnHeader>                        <jr:detailCell style="Table_TD" height="20">                            <property name="com.jaspersoft.studio.unit.width" value="px"/>                            <property name="com.jaspersoft.studio.unit.height" value="px"/>                            <textField isBlankWhenNull="true">                                <reportElement x="0" y="0" width="100" height="20" uuid="90bfc973-fad6-442a-be2d-cbdcc9922a24"/>                                <textFieldExpression><![CDATA[$F{ID}]]></textFieldExpression>                            </textField>                        </jr:detailCell>                    </jr:column>                    <jr:column width="100" uuid="bf4bafeb-e404-4f9e-aa48-11cba71657c0">                        <jr:columnHeader style="Table_CH" height="20">                            <property name="com.jaspersoft.studio.unit.height" value="px"/>                        </jr:columnHeader>                        <jr:detailCell style="Table_TD" height="20">                            <property name="com.jaspersoft.studio.unit.width" value="px"/>                            <property name="com.jaspersoft.studio.unit.height" value="px"/>                            <textField isBlankWhenNull="true">                                <reportElement x="0" y="0" width="100" height="20" uuid="11506e05-c8fa-46df-b4fc-7423403f27e5"/>                                <textFieldExpression><![CDATA[$F{ID2}]]></textFieldExpression>                            </textField>                        </jr:detailCell>                    </jr:column>                    <jr:column width="100" uuid="97b80891-a47c-43e8-8b0d-83e3499648b0">                        <jr:columnHeader style="Table_CH" height="20">                            <property name="com.jaspersoft.studio.unit.height" value="px"/>                        </jr:columnHeader>                        <jr:detailCell style="Table_TD" height="20">                            <property name="com.jaspersoft.studio.unit.width" value="px"/>                            <property name="com.jaspersoft.studio.unit.height" value="px"/>                            <textField isBlankWhenNull="true">                                <reportElement x="0" y="0" width="100" height="20" uuid="c8572e3a-1ee6-4381-915a-91eb32a0ca1e"/>                                <textFieldExpression><![CDATA[$F{ID3}]]></textFieldExpression>                            </textField>                        </jr:detailCell>                    </jr:column>                    <jr:column width="100" uuid="ec98c14f-6291-458f-87f0-9fcd8173ea4d">                        <jr:columnHeader style="Table_CH" height="20">                            <property name="com.jaspersoft.studio.unit.height" value="px"/>                        </jr:columnHeader>                        <jr:detailCell style="Table_TD" height="20">                            <property name="com.jaspersoft.studio.unit.width" value="px"/>                            <property name="com.jaspersoft.studio.unit.height" value="px"/>                            <textField isBlankWhenNull="true">                                <reportElement x="0" y="0" width="100" height="20" uuid="5539cd6a-e354-4b47-b3d0-662daf49a000"/>                                <textFieldExpression><![CDATA[$F{ID4}]]></textFieldExpression>                            </textField>                        </jr:detailCell>                    </jr:column>                    <jr:column width="100" uuid="6824bd57-c6dc-4e60-9f9f-ab499cec0e43">                        <jr:columnHeader style="Table_CH" height="20">                            <property name="com.jaspersoft.studio.unit.height" value="px"/>                        </jr:columnHeader>                        <jr:detailCell style="Table_TD" height="20">                            <property name="com.jaspersoft.studio.unit.width" value="px"/>                            <property name="com.jaspersoft.studio.unit.height" value="px"/>                            <textField isBlankWhenNull="true">                                <reportElement x="0" y="0" width="100" height="20" uuid="e84363a1-eb3f-4fb9-92ce-747444e9f5e6"/>                                <textFieldExpression><![CDATA[$F{ID5}]]></textFieldExpression>                            </textField>                        </jr:detailCell>                    </jr:column>                </jr:table>            </componentElement>        </band>    </summary></jasperReport>[/code]