Jump to content
We've recently updated our Privacy Statement, available here ×

sarah.brock

Members
  • Posts

    1
  • Joined

  • Last visited

sarah.brock's Achievements

Newbie

Newbie (1/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Conversation Starter Rare

Recent Badges

0

Reputation

  1. Hi all, I hope someone can help me with the following error because I've been working on it for hours. I'm trying to break a bar chart across several pages/charts, as I have too many values for it to still be readable in just one chart. I have used mainly the following page as instruction: http://stackoverflow.com/questions/14516654/how-to-split-chart-into-multiple-pages-like-cross-tab-in-jasperreports-server So what I did is for each of my values (taken from an sql source), I calculated a number "myNr" with the following formula: select ..., ((rownum -1) - mod( (rownum-1),5)) as myNr; I.e. I want to split the graph every five values. Part from jrxml file: <group name="Nr_Split" isStartNewPage="true"><groupExpression><![CDATA[$F{MYNR}]]></groupExpression><groupFooter><band height="315"><property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.HorizontalRowLayout"/><barChart><chart evaluationTime="Report"><reportElement x="0" y="0" width="802" height="315" uuid="7021535d-e31e-4bc8-bdde-c469cfb7894f"/><chartTitle/><chartSubtitle/><chartLegend/></chart><categoryDataset><dataset resetType="Group" resetGroup="Nr_Split"/><categorySeries><seriesExpression><![CDATA[$F{DATA_TYPE}]]></seriesExpression><categoryExpression><![CDATA[$F{USER_NAME}]]></categoryExpression><valueExpression><![CDATA[$F{DATA_VALUE}]]></valueExpression><labelExpression><![CDATA[$F{USER_NAME}]]></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></groupFooter></group> In one dataset for example, I have 39 lines, which leads to 8 groups (myNr=0, myNr=5, ... myNr=35). I do end up with 8 pages in the end, however, on each of the pages, I always only see the values from the first 5 lines, repeated over and over again. Am I missing something? Is there such a thing as a group break, which I might have to add in each group footer?Thanks in advance, Sarah
×
×
  • Create New...