Page Comparison

...

• Pentaho Pre-Configured Install, version 1.1.6 or later
• Pentaho Getting Started Guide, version 1.1.6 or later
• Pentaho Report Design Wizard, version 1.1.6 or later
• Pentaho Report Design Wizard User's Guide, version 1.1.6 or later  
  
  

  Warning
  title NOTE!!
  In order for Report Design Wizard 1.1.6 to properly render the chart, you MUST PERFORM THE FOLLOWING SIMPLE STEPS! This bug has been fixed as of the 1.1.7 release. Open the reportwizard.bat (or reportwizard_*.sh file, if your *nix based) Add ./lib/jfreechart-1.0.1.jar to the end of the classpath. Save and close the file. My reportwizard.bat looks like this now: Panel set PATH=%path%;./lib/swt-win32 java -Djava.endorsed.dirs="./lib/jdbc" -cp ./resources;./bin;./classes;./lib/pentaho-reporting.jar;./lib/activation.jar;./lib/asm-attrs.jar;./lib/bsf-2.3.0.jar;./lib/bsh-1.3.0.jar;./lib/castor-0.9.9.jar;./lib/commons-collections-3.1.jar;./lib/commons-dbcp-1.2.1.jar;./lib/commons-pool-1.2.jar;./lib/dom4j-1.6.1.jar;./lib/eigenbase-properties.jar;./lib/eigenbase-resgen.jar;./lib/eigenbase-xom.jar;./lib/itext-1.4.jar;./lib/javacup.jar;./lib/jaxen.jar;./lib/jcommon-logginglog4jlog-1.0.2.jar;./lib/jcommon-1.0.4.jar;./lib/jcommon-xml-1.0.4.jar;./lib/jfreereport-0.8.7-3.jar;./lib/js.jar;./lib/jug-lgpl-2.0.0.jar;./lib/libfonts-0.1.7.jar;./lib/log4j-1.2.8.jar;./lib/mondrian.jar;./lib/pentaho.jar;./lib/pixie-0.8.5.jar;./lib/poi-3.0-alpha1-20050704.jar;./lib/libloader-0.1.1.jar;./lib/saxon8.jar;./lib/saxon8-dom.jar;./lib/saxon8-jdom.jar;./lib/saxon8-sql.jar;./lib/saxon8-xom.jar;./lib/saxon8-xpath.jar;./lib/simple-jndi-0.11.1.jar;./lib/swt-win32/swt.jar;./lib/xercesImpl.jar;./lib/xml-apis.jar;./lib/nicky.jar;./lib/jfreechart-1.0.1.jar org.pentaho.jfreereport.wizard.ReportWizard

  
  

Build Your Report

1. Unzip the Pentaho PCI and run through some of the samples, using the Pentaho Getting Started Guide to guide you. The sample databases will be started as part of the PCI startup process.   For this exercise, you only need the PCI sample data, which can be downloaded separately. I recommend you use the PCI because a natural next step after following this exercise will be to publish your report, and the PCI is the easiest place to publish your report to.
2. Unzip the Report Design Wizard, using the Pentaho Report Design Wizard Guide as your guide.
3. Run the Report Design Wizard ( execute the reportwizard.bat|.sh file).
4. Choose "Blank Template", then click the Next button.
5. On the Data Source and Query tab, I chose JNDI, and selected the SampleData dataset.
6. On the same step in the wizard, I defined the following query in the Query Details box:

   Code Block
   SELECT REGION, DEPARTMENT, ACTUAL, BUDGET FROM QUADRANT_ACTUALS

7. Click Next. The next step defines the report layout. Move Region and Department to the Group By box, and Actual and Budget to the Selected Items box.  
8. Click Next twice, skipping steps 5 and 6. These steps require no changes for this exercise.
9. Step 7 is where we have been wanting to go all along. It is here that you can define a report level chart.  Under the Options section, check the Use Chart checkbox.
10. Click the Configure Chart... button, which should give you the Chart configuration dialog.

...