[Displaying Percentage Sign in Crosstab]

I have the below data in an excel file.

Sites	Infections	Count
LEO	# Infections	1
MGH	# Infections	2
VIH	# Infections	8
LEO	Total Treatment	12
MGH	Total Treatment	45
VIH	Total Treatment	515
LEO	% Infections	833%
MGH	% Infections	444%
VIH	% Infections	155%

 

When I want to display this in Crosstab, it get displayed as below.

                                                       LEO                MGH                     VIH

 # Infection                                        1                       2                          8

 Total Treatment                                12                     45                        515

 % Infections                                      8,33                 4,44                     1,55

 

I am satisfied with the results but I can not display % sign in %Infection row of the crosstab.

NOTE: I am doing sum calculation in crosstab.

If anyone of you has any solution then please share that here..

[Data Source Error]

The selected Data Adapter is "chart".

 

But in a source, the below below querystring tag seems a cause of problem. The bold charaters shown below are red in the source.

<queryString language="XLS">
            <![CDATA[ ]]>
        </queryString>

 

 

<queryString language="XLS">
        <![CDATA[ ]]>
    </queryString>

 

[Data Source Error]

I checked, data adapters for both "chart" and "crosstab" are there. I can even get a preiview of my data in a Data Preview option of "Data Set & Query Dialog".

[Data Source Error]

<?xml version="1.0" encoding="UTF-8"?>

<?xml version="1.0" encoding="UTF-8"?>

<!-- Created with Jaspersoft Studio version 6.3.1.final using JasperReports Library version 6.3.1  -->

<!-- 2017-09-26T16:03:22 -->

<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="TEST_014" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="842" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="fc398cc5-1420-4d68-ba36-1088f0cff748">

    <property name="com.jaspersoft.studio.data.defaultdataadapter" value="chart"/>

    <property name="com.jaspersoft.studio.unit." value="pixel"/>

    <property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/>

    <property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/>

    <property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/>

    <property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/>

    <property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/>

    <property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/>

    <property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/>

    <property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/>

    <style name="Crosstab_CH" 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="Crosstab_CG" 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="Crosstab_CT" 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="Crosstab_CD" 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="CROSSTAB" uuid="89bd39c8-839e-49fd-aa39-fe5bf6334b55">

        <property name="com.jaspersoft.studio.data.defaultdataadapter" value="crosstab"/>

        <queryString language="XLS">

            <![CDATA[]]>

        </queryString>

        <field name="Source Network Group" class="java.lang.String"/>

        <field name="ICSs" class="java.lang.String"/>

        <field name="Values" class="java.lang.Integer"/>

    </subDataset>

    <queryString language="XLS">

        <![CDATA[]]>

    </queryString>

    <field name="Source Network" class="java.lang.String"/>

    <field name="Prcnt. of ISCs Phishing" class="java.lang.Integer"/>

    <field name="# of ISCs Phishing" class="java.lang.Integer"/>

    <field name="Total ISCs" class="java.lang.Integer"/>

    <background>

        <band splitType="Stretch"/>

    </background>

    <pageHeader>

        <band height="367" splitType="Stretch">

            <barChart>

                <chart evaluationTime="Report">

                    <reportElement x="0" y="0" width="842" height="367" uuid="815da873-f36b-4c75-aab4-3c44f7190b2e"/>

                    <chartTitle/>

                    <chartSubtitle/>

                    <chartLegend/>

                </chart>

                <categoryDataset>

                    <categorySeries>

                        <seriesExpression><![CDATA[$F{Prcnt. of ISCs Phishing}]]></seriesExpression>

                        <categoryExpression><![CDATA[$F{Source Network}]]></categoryExpression>

                        <valueExpression><![CDATA[$F{Prcnt. of ISCs Phishing}]]></valueExpression>

                        <labelExpression><![CDATA[$F{Source Network}]]></labelExpression>

                    </categorySeries>

                </categoryDataset>

                <barPlot>

                    <plot/>

                    <itemLabel/>

                    <categoryAxisFormat>

                        <axisFormat labelColor="#000000" tickLabelColor="#000000" axisLineColor="#000000"/>

                    </categoryAxisFormat>

                    <valueAxisFormat>

                        <axisFormat labelColor="#000000" tickLabelColor="#000000" axisLineColor="#000000"/>

                    </valueAxisFormat>

                </barPlot>

            </barChart>

        </band>

    </pageHeader>

    <summary>

        <band height="60" splitType="Stretch">

            <crosstab>

                <reportElement x="10" y="0" width="822" height="60" uuid="d5c523a8-0380-40b9-be03-1bc337c016fa">

                    <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/>

                    <property name="com.jaspersoft.studio.crosstab.style.header" value="Crosstab_CH"/>

                    <property name="com.jaspersoft.studio.crosstab.style.group" value="Crosstab_CG"/>

                    <property name="com.jaspersoft.studio.crosstab.style.total" value="Crosstab_CT"/>

                    <property name="com.jaspersoft.studio.crosstab.style.detail" value="Crosstab_CD"/>

                </reportElement>

                <crosstabDataset>

                    <dataset>

                        <datasetRun subDataset="CROSSTAB" uuid="4003cbe2-b878-411c-8f9b-23f0dcbf9fa9"/>

                    </dataset>

                </crosstabDataset>

                <rowGroup name="ICSs" width="60" totalPosition="End">

                    <bucket class="java.lang.String">

                        <bucketExpression><![CDATA[$F{ICSs}]]></bucketExpression>

                    </bucket>

                    <crosstabRowHeader>

                        <cellContents mode="Opaque" style="Crosstab_CH">

                            <textField>

                                <reportElement x="0" y="0" width="60" height="20" uuid="6ffb4233-e596-4334-bfb0-1495544fd8a9"/>

                                <textFieldExpression><![CDATA[$V{ICSs}]]></textFieldExpression>

                            </textField>

                        </cellContents>

                    </crosstabRowHeader>

                    <crosstabTotalRowHeader>

                        <cellContents mode="Opaque" style="Crosstab_CT">

                            <staticText>

                                <reportElement x="0" y="0" width="60" height="20" uuid="18a09636-17bc-4bd9-9064-7d5c55f90b39"/>

                                <text><![CDATA[Total ICSs]]></text>

                            </staticText>

                        </cellContents>

                    </crosstabTotalRowHeader>

                </rowGroup>

                <columnGroup name="Source Network Group" height="20" totalPosition="End">

                    <bucket class="java.lang.String">

                        <bucketExpression><![CDATA[$F{Source Network Group}]]></bucketExpression>

                    </bucket>

                    <crosstabColumnHeader>

                        <cellContents mode="Opaque" style="Crosstab_CH">

                            <textField>

                                <reportElement x="0" y="0" width="60" height="20" uuid="ad65d5c4-ac7a-4936-b9d9-aab7d1fa96d0"/>

                                <textFieldExpression><![CDATA[$V{Source Network Group}]]></textFieldExpression>

                            </textField>

                        </cellContents>

                    </crosstabColumnHeader>

                    <crosstabTotalColumnHeader>

                        <cellContents mode="Opaque" style="Crosstab_CT">

                            <staticText>

                                <reportElement x="0" y="0" width="60" height="20" uuid="884d18ab-4afd-424e-805a-ae7d964dddb6"/>

                                <text><![CDATA[Total Source Network Group]]></text>

                            </staticText>

                        </cellContents>

                    </crosstabTotalColumnHeader>

                </columnGroup>

                <measure name="Values_MEASURE" class="java.lang.Integer" calculation="Sum">

                    <measureExpression><![CDATA[$F{Values}]]></measureExpression>

                </measure>

                <crosstabCell width="60" height="20">

                    <cellContents mode="Opaque" style="Crosstab_CD">

                        <textField>

                            <reportElement x="0" y="0" width="60" height="20" uuid="6cdf5e28-2cb9-4e15-b065-256d2f8b2af2"/>

                            <textFieldExpression><![CDATA[$V{Values_MEASURE}]]></textFieldExpression>

                        </textField>

                    </cellContents>

                </crosstabCell>

                <crosstabCell width="60" height="20" columnTotalGroup="Source Network Group">

                    <cellContents mode="Opaque" style="Crosstab_CT">

                        <textField>

                            <reportElement x="0" y="0" width="60" height="20" uuid="4216d617-af20-476e-8221-b8010ba09e27"/>

                            <textFieldExpression><![CDATA[$V{Values_MEASURE}]]></textFieldExpression>

                        </textField>

                    </cellContents>

                </crosstabCell>

                <crosstabCell width="60" height="20" rowTotalGroup="ICSs">

                    <cellContents mode="Opaque" style="Crosstab_CT">

                        <textField>

                            <reportElement x="0" y="0" width="60" height="20" uuid="77238a5b-45d5-4f2e-b9b2-64c5f0e80575"/>

                            <textFieldExpression><![CDATA[$V{Values_MEASURE}]]></textFieldExpression>

                        </textField>

                    </cellContents>

                </crosstabCell>

                <crosstabCell width="60" height="20" rowTotalGroup="ICSs" columnTotalGroup="Source Network Group">

                    <cellContents mode="Opaque" style="Crosstab_CT">

                        <textField>

                            <reportElement x="0" y="0" width="60" height="20" uuid="881eb974-6290-4220-b561-69fc9dfa8eba"/>

                            <textFieldExpression><![CDATA[$V{Values_MEASURE}]]></textFieldExpression>

                        </textField>

                    </cellContents>

                </crosstabCell>

            </crosstab>

        </band>

    </summary>

</jasperReport>

 

Above is my source code. I assign main dataset to a chart while a subset to a crosstab. But I am getting the error below

 

NoSuchMethodException: net.sf.jasperreports.engine.data.ExcelDataSource.()

[Columns and Rows in Crosstab]

I have 4 columns in excel sheet. I want one column of excel sheet in a column of a crosstab while the other 2 columns of excel sheet in 3 distinct rows of the crosstab. 

If anyone has any solution please share with me.

["Query Language not Set" Error]

I assign one excel dataset to the main report while assign another excel dataset to the chart. But gets the "Query Language not Set Error". 

I even changed the language to XLS in QueryDialog.But still the error is there.

Please help me.

[Displaying two distinct row in crosstab]

Hello,

I have 3 coloumns of different dats in an excel sheet. I want to display each column as a distinct row in cross tab. How can I do this?

[Percentage]

Hi, 

How to display values in percentage format in tables and charts? 

[Cannot "Build All" subreports in Jaspersoft Studio]

I resolve the issue by selecting "Clean..." option first and after that I go for " Build All" option.

[Chart and Crosstab on the same report]

I want to print a Bar Chart and a Crosstab on the same page of a report. Both, bar chart and crosstab, have different datasources. How can that be happen? When I assign different data sources to each, I get Query Selection error. Please help.

[Crosstab and Subreport in Summary Band]

It worked. Thank you so much

[Crosstab and Subreport in Summary Band]

I have a report comprising two pages. On first page I had to print a crosstab, that I had to put in a summary band and it worked perfectly. But to add the second page I needed to put a subreport in summary also. 

How to put crosstab and subreport together in a single summary band? As I do so half part of the second page also get printed on the first page and overlab the crosstab.

[ERROR: "category series name is null"]

When I put a stacked bar chart in a single report it works fine without any error but when I put the same report as a sub report then I get "category series name is null"error. I don't know how to solve this.