How to generate table with 3 nested list in java beans using jasper report?

0

I am creating a table in jasper report with 3 nested lists and I successfully created the table till the 2nd list but for the 3rd list, it is not working. is there any way to do this? I am using sub-report for 2nd list.

// Java code    

public static void main(String[] args) {
        String outFile = "Report.pdf";
 
        Util util = new Util();
 
        /* Create Vscs */
 
 
        /* Create Categories */
 
        List<Category> catogeries = new ArrayList<Category>();
        int randomLength = util.getNewRandomNumber();
        System.out.println("***************************");
        System.out.println("Total Categories Length "+randomLength);
        for (int i = 0; i < randomLength; i++) {
 
            List<Vsc> Vscs = new ArrayList<Vsc>();
 
            int vscLength = util.getNewRandomNumber();
 
            System.out.println("***************************");
            System.out.println("Total VSCs Length "+vscLength);
            for (int j = 0; j < vscLength; j++) {
                Integer id = util.getNewRandomNumber();
                String temp = util.getNewRandomString();
                Vscs.add(new Vsc(id, temp, temp, temp, id.toString(), id.toString(), id.toString()));
            }
            System.out.println(Vscs);
            String temp = util.getNewRandomString();
            catogeries.add(new Category(temp, Vscs));
        }
 
        System.out.println(catogeries);
        /* Convert List to JRBeanCollectionDataSource */
        JRBeanCollectionDataSource CategoriesJRBean = new JRBeanCollectionDataSource(
                catogeries);
 
        /* Map to hold Jasper report Parameters */
        Map<String, Object> parameters = new HashMap<String, Object>();
        parameters.put("CategoryDataSource", CategoriesJRBean);
 
        /* Using compiled version(.jasper) of Jasper report to generate PDF */
 
        try {
 
            /* Using compiled version(.jasper) of Jasper report to generate PDF */
            JasperPrint jasperPrint = JasperFillManager.fillReport(
                    "template.jasper", parameters, CategoriesJRBean);
 
            /* outputStream to create PDF */
 
            OutputStream outStream = new FileOutputStream(new File(outFile));
 
            /* Write content to PDF file */
 
            JasperExportManager.exportReportToPdfStream(jasperPrint, outStream);
 
            System.out.println("File Generated");
 
        } catch (JRException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (FileNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
 
    }


// jasper report main file code

 <?xml version="1.0" encoding="UTF-8"?>
    <!-- Created with Jaspersoft Studio version 6.6.0.final using JasperReports Library version 6.6.0  -->
    <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="template" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="1e86ce9a-f7ec-493e-bb1c-193fda92340b">
        <property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
        <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>
        <style name="Table 1_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 1_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 1_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="CategoryDataset" uuid="3cc9e312-e929-4940-aff6-d8d83e24b723">
            <property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
            <queryString>
                <![CDATA[]]>
            </queryString>
            <field name="name" class="java.lang.String"/>
            <field name="vscs" class="java.util.List"/>
        </subDataset>
        <parameter name="CategoryDataSource" class="net.sf.jasperreports.engine.data.JRBeanCollectionDataSource"/>
        <queryString>
            <![CDATA[]]>
        </queryString>
        <field name="name" class="java.lang.String"/>
        <field name="vscs" class="java.util.List"/>
        <background>
            <band splitType="Stretch"/>
        </background>
        <detail>
            <band height="408">
                <componentElement>
                    <reportElement x="0" y="0" width="550" height="180" uuid="26266d16-7d14-4cee-9fbf-c9d1ae5f037c">
                        <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/>
                        <property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/>
                        <property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/>
                        <property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/>
                    </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="CategoryDataset" uuid="f21c7634-7f14-4267-97b7-517d83b2ca3a">
                            <dataSourceExpression><![CDATA[$P{CategoryDataSource}]]></dataSourceExpression>
                        </datasetRun>
                        <jr:column width="60" uuid="a34069ec-2184-4c0b-8b2d-f9276778ab61">
                            <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/>
                            <jr:tableHeader style="Table_TH" height="40" rowSpan="1">
                                <staticText>
                                    <reportElement x="0" y="0" width="60" height="40" uuid="e0d53137-91bf-4314-80be-726bc23897b5"/>
                                    <text><![CDATA[Category]]></text>
                                </staticText>
                            </jr:tableHeader>
                            <jr:detailCell style="Table_TD" height="50">
                                <textField>
                                    <reportElement x="0" y="0" width="60" height="50" uuid="4b3bef69-ea8f-43d9-b99d-a1360e280479"/>
                                    <textFieldExpression><![CDATA[$F{name}]]></textFieldExpression>
                                </textField>
                            </jr:detailCell>
                        </jr:column>
                        <jr:column width="50" uuid="2e1524b4-9536-482d-b62c-5754432a9637">
                            <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column2"/>
                            <jr:tableHeader style="Table_TH" height="40" rowSpan="1">
                                <staticText>
                                    <reportElement x="0" y="0" width="50" height="40" uuid="d4623cd9-e0d6-415f-ad25-8b7a64a96f36"/>
                                    <text><![CDATA[VSC Code]]></text>
                                </staticText>
                            </jr:tableHeader>
                            <jr:detailCell style="Table_TD" height="50">
                                <subreport>
                                    <reportElement x="0" y="0" width="50" height="50" uuid="f07c137e-f8dd-4ffd-94c7-f699d54ae171"/>
                                    <dataSourceExpression><![CDATA[new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($F{vscs})]]></dataSourceExpression>
                                    <subreportExpression><![CDATA["testreport.jasper"]]></subreportExpression>
                                </subreport>
                            </jr:detailCell>
                        </jr:column>
                        <jr:column width="80" uuid="5af871b9-e5dd-4339-b849-0d86f184ac44">
                            <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column3"/>
                            <jr:tableHeader style="Table_TH" height="40" rowSpan="1">
                                <staticText>
                                    <reportElement x="0" y="0" width="80" height="40" uuid="85742d12-174a-4cc8-9634-5da9a2562e52"/>
                                    <text><![CDATA[Item]]></text>
                                </staticText>
                            </jr:tableHeader>
                            <jr:detailCell style="Table_TD" height="50">
                                <subreport>
                                    <reportElement x="0" y="0" width="80" height="50" uuid="f3ae48d0-b447-4e53-97d3-3cec524e31b5"/>
                                    <dataSourceExpression><![CDATA[new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($F{vscs})]]></dataSourceExpression>
                                    <subreportExpression><![CDATA["VscItem.jasper"]]></subreportExpression>
                                </subreport>
                            </jr:detailCell>
                        </jr:column>
                        <jr:column width="70" uuid="47b5cc43-a32f-493f-9b84-35caf34c57fa">
                            <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column4"/>
                            <jr:tableHeader style="Table_TH" height="40" rowSpan="1">
                                <staticText>
                                    <reportElement x="0" y="0" width="70" height="40" uuid="fed179b7-c0e5-43e3-a789-54e125c3ed75"/>
                                    <text><![CDATA[Description]]></text>
                                </staticText>
                            </jr:tableHeader>
                            <jr:detailCell style="Table_TD" height="50">
                                <subreport>
                                    <reportElement x="0" y="0" width="70" height="50" uuid="0193c06f-fbf7-4428-9e40-109b8cdcc89c"/>
                                    <dataSourceExpression><![CDATA[new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($F{vscs})]]></dataSourceExpression>
                                    <subreportExpression><![CDATA["VscDesc.jasper"]]></subreportExpression>
                                </subreport>
                            </jr:detailCell>
                        </jr:column>
                        <jr:column width="80" uuid="9852409d-8381-401e-bc68-014b1ffb6803">
                            <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column5"/>
                            <jr:tableHeader style="Table_TH" height="40" rowSpan="1">
                                <staticText>
                                    <reportElement x="0" y="0" width="80" height="40" uuid="83b37e89-0ee3-41ed-bd06-4c60c5c7359b"/>
                                    <text><![CDATA[Unit]]></text>
                                </staticText>
                            </jr:tableHeader>
                            <jr:detailCell style="Table_TD" height="50">
                                <subreport>
                                    <reportElement x="0" y="0" width="80" height="50" uuid="0781127c-0fb4-4226-a688-9147eb37ba40"/>
                                    <dataSourceExpression><![CDATA[new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($F{vscs})]]></dataSourceExpression>
                                    <subreportExpression><![CDATA["VscUnit.jasper"]]></subreportExpression>
                                </subreport>
                            </jr:detailCell>
                        </jr:column>
                        <jr:column width="50" uuid="f794b140-1b69-43a3-9e35-8d96408193b8">
                            <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column6"/>
                            <jr:tableHeader style="Table_TH" height="40" rowSpan="1">
                                <staticText>
                                    <reportElement x="0" y="0" width="50" height="40" uuid="e88c6f68-4328-487a-892d-a1ded1d40c37"/>
                                    <text><![CDATA[Approx. Unit Cost (USD)]]></text>
                                </staticText>
                            </jr:tableHeader>
                            <jr:detailCell style="Table_TD" height="50">
                                <subreport>
                                    <reportElement x="0" y="0" width="50" height="50" uuid="7adf0000-1972-47cc-a1fa-1972ef237cac"/>
                                    <dataSourceExpression><![CDATA[new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($F{vscs})]]></dataSourceExpression>
                                    <subreportExpression><![CDATA["VscApproxUnitCost.jasper"]]></subreportExpression>
                                </subreport>
                            </jr:detailCell>
                        </jr:column>
                        <jr:column width="70" uuid="bfcb8fc6-07ac-4343-9ffd-637cd52d09c2">
                            <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column7"/>
                            <jr:tableHeader style="Table_TH" height="40" rowSpan="1">
                                <staticText>
                                    <reportElement x="0" y="0" width="70" height="40" uuid="3d49b022-0ab1-44b8-9276-8c1cf6df98b0"/>
                                    <text><![CDATA[PHY. INV.]]></text>
                                </staticText>
                            </jr:tableHeader>
                            <jr:detailCell style="Table_TD" height="50">
                                <subreport>
                                    <reportElement x="0" y="0" width="70" height="50" uuid="6c8a56b6-1c04-4651-9eb8-7b75e441a576"/>
                                    <dataSourceExpression><![CDATA[new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($F{vscs})]]></dataSourceExpression>
                                    <subreportExpression><![CDATA["VscPhyInv.jasper"]]></subreportExpression>
                                </subreport>
                            </jr:detailCell>
                        </jr:column>
                        <jr:column width="60" uuid="341a99c2-ff27-446d-a758-5a4bc3a1134c">
                            <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column8"/>
                            <jr:tableHeader style="Table_TH" height="40" rowSpan="1">
                                <staticText>
                                    <reportElement x="0" y="0" width="60" height="40" uuid="f83fb9c8-c6da-4e8b-b8ed-6c5021c64925"/>
                                    <text><![CDATA[REQ.QTY]]></text>
                                </staticText>
                            </jr:tableHeader>
                            <jr:detailCell style="Table_TD" height="50">
                                <subreport>
                                    <reportElement x="0" y="0" width="60" height="50" uuid="14363048-9a16-4be9-badf-d72af940c385"/>
                                    <dataSourceExpression><![CDATA[new net.sf.jasperreports.engine.data.JRBeanCollectionDataSource($F{vscs})]]></dataSourceExpression>
                                    <subreportExpression><![CDATA["VscReqQty.jasper"]]></subreportExpression>
                                </subreport>
                            </jr:detailCell>
                        </jr:column>
                    </jr:table>
                </componentElement>
            </band>
        </detail>
    </jasperReport>


The output which I am getting after running the code.

actual output

[![enter image description here][1]][1]

expected output

[![enter image description here][2]][2]

Thank you


[1]: https://i.stack.imgur.com/xHIJ2.jpg
[2]: https://i.stack.imgur.com/gae97.jpg

tcl44065's picture
Joined: Apr 30 2019 - 5:33am
Last seen: 3 months 3 weeks ago

0 Answers:

No answers yet
Feedback
randomness