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

sarah.brock

Members
  • Posts

    1
  • 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

Everything posted by sarah.brock

  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...