• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Problem in generating Charts with iReport2.0.0

 
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Friends,

I'm facing this problem while using Charts of iReport2.0.0. After the usual reports I needed to make Charts and I chose the option of Bar 3-D charts and drew the chart in LastPageFooter.The chart gets its data from the query which fetches the desired fields.I am using MySql3.0 for the database.

The output was that the bars are very very thin and I need to increase the thickness of these Bars and increase or decrease the distance between two consecutive bars as per requirements. What do I do that changes the thickness of the bars and also the distance between the bars?

Following is the code in case you would need it.

------------------------------------------------------------------------------------------------------------------------------------------------------

<?xml version="1.0" encoding="UTF-8" ?>
<!-- Created with iReport - A designer for JasperReports -->
<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
<jasperReport
name="ActiveContact"
columnCount="1"
printOrder="Vertical"
orientation="Portrait"
pageWidth="520"
pageHeight="842"
columnWidth="460"
columnSpacing="0"
leftMargin="30"
rightMargin="30"
topMargin="20"
bottomMargin="20"
whenNoDataType="NoPages"
isTitleNewPage="false"
isSummaryNewPage="false">
<property name="ireport.scriptlethandling" value="0" />
<property name="ireport.encoding" value="UTF-8" />
<import value="java.util.*" />
<import value="net.sf.jasperreports.engine.*" />
<import value="net.sf.jasperreports.engine.data.*" />

<parameter name="companyid" isForPrompting="true" class="java.lang.Integer"/>
<queryString><![CDATA[SELECT account.AccountName,count(contact.Id)
FROM CONTACT contact
LEFT OUTER JOIN ACCOUNT account on contact.AccountId=account.id
WHERE
contact.active=1
AND contact.companyid=4
GROUP BY account.AccountName
ORDER BY account.AccountName]]></queryString>

<field name="AccountName" class="java.lang.String"/>
<field name="count(contact.Id)" class="java.lang.Long"/>

<variable name="AccName" class="java.lang.String" resetType="Report" calculation="Count">
<variableExpression><![CDATA[$F{AccountName}==null ? "blank":$F{AccountName}]]></variableExpression>
</variable>
<background>
<band height="0" isSplitAllowed="true" >
</band>
</background>
<title>
<band height="0" isSplitAllowed="true" >
</band>
</title>
<pageHeader>
<band height="0" isSplitAllowed="true" >
</band>
</pageHeader>
<columnHeader>
<band height="0" isSplitAllowed="true" >
</band>
</columnHeader>
<detail>
<band height="0" isSplitAllowed="true" >
</band>
</detail>
<columnFooter>
<band height="0" isSplitAllowed="true" >
</band>
</columnFooter>
<pageFooter>
<band height="0" isSplitAllowed="true" >
</band>
</pageFooter>
<lastPageFooter>
<band height="171" isSplitAllowed="true" >
<bar3DChart>
<chart isShowLegend="false" hyperlinkTarget="Self" >
<reportElement
mode="Opaque"
x="69"
y="0"
width="308"
height="171"
key="element-1"/>
<box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000"/>
<chartTitle color="#000000" >
<titleExpression><![CDATA["Active Contact"]]></titleExpression>
</chartTitle>
</chart>
<categoryDataset>
<dataset >
</dataset>
<categorySeries>
<seriesExpression><![CDATA[$V{AccName}]]></seriesExpression>
<categoryExpression><![CDATA[$V{AccName}]]></categoryExpression>
<valueExpression><![CDATA[$F{count(contact.Id)}]]></valueExpression>
<itemHyperlink >
</itemHyperlink>
</categorySeries>
</categoryDataset>
<bar3DPlot xOffset="20.0" >
<plot backcolor="#FFFFFF" orientation="Horizontal" labelRotation="325.0" >
<seriesColor seriesOrder="0" color="#FF0000"/>
<seriesColor seriesOrder="1" color="#FF0000"/>
<seriesColor seriesOrder="2" color="#FF0000"/>
</plot>
<categoryAxisFormat>
<axisFormat tickLabelColor="#000000" axisLineColor="#FFFFFF" >
</axisFormat>
</categoryAxisFormat>
<valueAxisFormat>
<axisFormat axisLineColor="#000000" >
</axisFormat>
</valueAxisFormat>
</bar3DPlot>
</bar3DChart>
</band>
</lastPageFooter>
<summary>
<band height="0" isSplitAllowed="true" >
</band>
</summary>
</jasperReport>
---------------------------------------------------------------------------


Kindly Help.
 
reply
    Bookmark Topic Watch Topic
  • New Topic