Display rows Side By Side

[naikniket.31]

Please check following dataset 

 

Now I want to display these results as below

 

 

How can I achieve this. I am using Jasper Studio

[jgust]

It looks like what you want is to split the page into multiple columns with a print order of horizontal.

 

[naikniket.31]

@jgust, No, it is not what I want. Using this approach, it surly displays two columns but not all present on one side, and all absent on another side. 

[jgust]

Below is a screenshot of a sample report where each group has 3-4 records.  The last column is a record counting.  Record 1 is on the left while record 2 on the right...

Attached is my report.  Hopefully, you find it useful.

[jgust]

OK, It's clear I didn't understand your initial question. 

You want one set of data side by side with another set of data.  To do that you can display two table elements, two list elements,  or two sub-reports side by side.

[Tom C]

Here is the sample report to display your data side by side using two list elements.

 

<?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 7.9.0.final using JasperReports Library version 6.16.0-48579d909b7943b64690c65c71e07e0b80981928  --><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="report4naikniket.31" pageWidth="612" pageHeight="792" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="e49e5f44-5f51-4b62-90be-ab372edf1c20">    <property name="com.jaspersoft.studio.data.sql.tables" value=""/>    <property name="com.jaspersoft.studio.data.defaultdataadapter" value="JRSrepo"/>    <subDataset name="Dataset1" uuid="8b2b0ca9-3e67-4038-a73c-49958400598b">        <property name="com.jaspersoft.studio.data.sql.tables" value=""/>        <property name="com.jaspersoft.studio.data.defaultdataadapter" value="JRSrepo"/>        <parameter name="Status" class="java.lang.String">            <defaultValueExpression><![CDATA[]]></defaultValueExpression>        </parameter>        <queryString language="SQL">            <![CDATA[select 'Mak' as employee, 'Present' as status, 30 as daysunion allselect 'Jezz' as employee, 'Present' as status, 20 as daysunion allselect 'Rick' as employee, 'Absent' as status, 30 as daysunion allselect 'Jerry' as employee, 'Absent' as status, 10 as days]]>        </queryString>        <field name="employee" class="java.lang.String">            <property name="com.jaspersoft.studio.field.name" value="employee"/>            <property name="com.jaspersoft.studio.field.label" value="employee"/>        </field>        <field name="status" class="java.lang.String">            <property name="com.jaspersoft.studio.field.name" value="status"/>            <property name="com.jaspersoft.studio.field.label" value="status"/>        </field>        <field name="days" class="java.lang.Integer">            <property name="com.jaspersoft.studio.field.name" value="days"/>            <property name="com.jaspersoft.studio.field.label" value="days"/>        </field>        <filterExpression><![CDATA[$F{status}.equals( $P{Status} )]]></filterExpression>    </subDataset>    <queryString language="SQL">        <![CDATA[select 1 as n]]>    </queryString>    <field name="n" class="java.lang.Integer">        <property name="com.jaspersoft.studio.field.name" value="n"/>        <property name="com.jaspersoft.studio.field.label" value="n"/>    </field>    <columnHeader>        <band height="35" splitType="Stretch">            <property name="com.jaspersoft.studio.unit.height" value="px"/>            <staticText>                <reportElement x="0" y="0" width="100" height="30" uuid="6d09a442-2ba3-49a8-85b0-cea73062f692">                    <property name="com.jaspersoft.studio.unit.y" value="px"/>                </reportElement>                <text><![CDATA[PRESENT EMPLOYEES]]></text>            </staticText>            <staticText>                <reportElement x="100" y="0" width="50" height="30" uuid="01ba8f59-2fd8-4267-9421-f7ab8d6da0db">                    <property name="com.jaspersoft.studio.unit.y" value="px"/>                </reportElement>                <text><![CDATA[DAYS]]></text>            </staticText>            <staticText>                <reportElement x="170" y="0" width="100" height="30" uuid="88cb6fdc-1765-436a-be3b-41e19484102d">                    <property name="com.jaspersoft.studio.unit.y" value="px"/>                </reportElement>                <text><![CDATA[ABSENT EMPLOYEES]]></text>            </staticText>            <staticText>                <reportElement x="270" y="0" width="50" height="30" uuid="52741da0-5f28-489b-abe0-0e5a278d4a13">                    <property name="com.jaspersoft.studio.unit.y" value="px"/>                </reportElement>                <text><![CDATA[DAYS]]></text>            </staticText>        </band>    </columnHeader>    <detail>        <band height="30" splitType="Stretch">            <property name="com.jaspersoft.studio.unit.height" value="px"/>            <componentElement>                <reportElement x="0" y="0" width="150" height="30" uuid="62c235fd-9d37-4458-b18e-7f1463146b03"/>                <jr:list 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="Dataset1" uuid="74549617-0354-4fff-b02d-08053fa18d1c">                        <datasetParameter name="Status">                            <datasetParameterExpression><![CDATA["Present"]]></datasetParameterExpression>                        </datasetParameter>                        <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>                    </datasetRun>                    <jr:listContents height="30" width="150">                        <textField>                            <reportElement x="0" y="0" width="100" height="30" uuid="9fcb691f-5c3d-449a-afb3-8ddfbb54a50b"/>                            <textFieldExpression><![CDATA[$F{employee}]]></textFieldExpression>                        </textField>                        <textField>                            <reportElement x="100" y="0" width="50" height="30" uuid="1edfaefc-11fa-42f7-96aa-7b4e7418042e"/>                            <textFieldExpression><![CDATA[$F{days}]]></textFieldExpression>                        </textField>                    </jr:listContents>                </jr:list>            </componentElement>            <componentElement>                <reportElement x="170" y="0" width="150" height="30" uuid="70ba789d-914c-44b1-afe9-5ebcbbd9a20e">                    <property name="com.jaspersoft.studio.unit.y" value="px"/>                </reportElement>                <jr:list 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="Dataset1" uuid="18329d32-c389-4291-932e-d77faeea7afd">                        <datasetParameter name="Status">                            <datasetParameterExpression><![CDATA["Absent"]]></datasetParameterExpression>                        </datasetParameter>                        <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>                    </datasetRun>                    <jr:listContents height="30" width="150">                        <textField>                            <reportElement x="0" y="0" width="100" height="30" uuid="76af5763-4dc9-42fd-bf70-5cd03ba56cf6"/>                            <textFieldExpression><![CDATA[$F{employee}]]></textFieldExpression>                        </textField>                        <textField>                            <reportElement x="100" y="0" width="50" height="30" uuid="7a3a1c0c-0088-42bd-9a4f-fbf8c9b8deb8"/>                            <textFieldExpression><![CDATA[$F{days}]]></textFieldExpression>                        </textField>                    </jr:listContents>                </jr:list>            </componentElement>        </band>    </detail></jasperReport>

You can test run this report in Jaspersoft Studio (JSS) 7.9 using any PosgreSQL data source.

report data:

report output: