Groups + 3D pie charts

[jmoss]

Hey everybody,

I'm relatively new to iReport (& Jasper Reports in general), so I'm hoping this is just an issue of not fully understanding the platform.

I'm trying to report on a set of questions, answers and counts for those answers.  i.e. I'm trying to create a visual representation of the following (sample) SQL result:

QuestionId	AnswerId	Total
question 1	q1a1	14
question 1	q1a2	24
question 1	q1a3	4
question 2	q2a1	1
question 2	q2a2	12
question 3	q3a1	5
question 3	q3a2	3
question 3	q3a2	17

What I want to be able to do is create a 3D pie chart for each question, detailing a breakdown by answers.  So, for the above result, I would have 3 pie charts: question 1 with 3 slices (q1a1, q1a2, q1a3), question 2 with 2 slices (q2a1, q2a2) and question 3 with 3 slices (q3a1, q3a2, q3a3).

I've created a group, and am grouping on $F{QuestionID}.  In that group's detail I've added a 3D pie chart.  It resets on the question id group, and has an $F{AnswerId} Key Expression and a $F{Count} Value Expression.

This seems to work (mostly) as intended: I get a charts with a breakdown by answer for each of those 3 groups. 

However, it looks like it's populating a new page for each of the rows in the result set, rather than 1 chart for each unique question.  So, for the above data set, I get 8 pages of charts: 3 identical question 1 charts, 2 identical question 2 charts and 3 identical question 3 charts.

Any suggestions on how to fix this problem?

I've tried many combinations of options (like different increment types and group types, as well as chart options like printWhenGroupChanges), and nothing seems to do the trick.

Below is a sample jrxml, and many thanks in advance for your help.

Code:

<?xml version="1.0" encoding="UTF-8"?><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="QvA" pageWidth="792" pageHeight="612" orientation="Landscape" columnWidth="732" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20">	<property name="ireport.scriptlethandling" value="2"/>	<property name="ireport.encoding" value="UTF-8"/>	<import value="net.sf.jasperreports.engine.*"/>	<import value="java.util.*"/>	<import value="net.sf.jasperreports.engine.data.*"/>	<parameter name="SELECTOR" class="java.lang.String" isForPrompting="false">		<defaultValueExpression><![CDATA["some_selector"]]></defaultValueExpression>	</parameter>	<queryString>		<![CDATA[sELECT	QuestionId,	AnswerId,	COUNT(*) TotalFROM AnswerTableWHERE Selector = $P{SELECTOR}GROUP BY QuestionId, AnswerId]]>	</queryString>	<field name="QuestionId" class="java.lang.String">		<fieldDescription><![CDATA[]]></fieldDescription>	</field>	<field name="AnswerId" class="java.lang.String">		<fieldDescription><![CDATA[]]></fieldDescription>	</field>	<field name="Total" class="java.lang.Integer">		<fieldDescription><![CDATA[]]></fieldDescription>	</field>	<group name="QuestionGroup">		<groupExpression><![CDATA[$F{QuestionId}]]></groupExpression>	</group>	<detail>		<band height="490">			<pie3DChart>				<chart evaluationTime="Group" evaluationGroup="QuestionGroup">					<reportElement isPrintRepeatedValues="false" x="0" y="0" width="732" height="490" printWhenGroupChanges="QuestionGroup"/>					<chartTitle>						<font size="14" isBold="true"/>						<titleExpression><![CDATA[$F{QuestionId}]]></titleExpression>					</chartTitle>					<chartSubtitle/>					<chartLegend position="Left">						<font size="14"/>					</chartLegend>				</chart>				<pieDataset>					<dataset resetType="Group" resetGroup="QuestionGroup"/>					<keyExpression><![CDATA[$F{AnswerId}]]></keyExpression>					<valueExpression><![CDATA[$F{Total}]]></valueExpression>				</pieDataset>				<pie3DPlot isCircular="true" labelFormat="{2}" legendLabelFormat="{0} - {2}">					<plot orientation="Horizontal"/>					<itemLabel color="#000000" backgroundColor="#FFFFFF">						<font size="12"/>					</itemLabel>				</pie3DPlot>			</pie3DChart>		</band>	</detail></jasperReport>

[kchaudhry]

This is happening because you have placed the chart in the "Detail" band. Try placing it in group footer band.

[jmoss]

Brilliant: I knew it would be something simple like that.

 

Thanks much!