asfandyar.khalil
-
Posts
13 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Posts posted by asfandyar.khalil
-
-
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> -
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".
-
<?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.()
-
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.
-
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.
-
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?
-
Hi,
How to display values in percentage format in tables and charts?
-
I resolve the issue by selecting "Clean..." option first and after that I go for " Build All" option.
-
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.
-
It worked. Thank you so much
-
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.
-
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.
Displaying Percentage Sign in Crosstab
in Products
Posted
I have the below data in an excel file.
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..