watsocd

But what if I need to put tables and charts into the detail band? My main top level report has multiple pages for each record in the main report query. Device id 1 - 6 pages of multiple charts, sub-reports, and tables in multiple detail bands Device id 2 - 6 pages of charts, sub-reports, and tables ... ... for a hundred or more devices with total page counts of over 600 pages. Once the first device pages are done, there is no need to go back and process the data again for its components before doing device 2/record two. As I said, my report is working great and looks great. However, it is slow and has a Processed Records Count of well over 100,000,000 when this number should be in the range of maybe 100,000. When I say slow, I mean five minutes in Jasper Studio to generate the report. Is there a better way of structuring my report to reduce the records count?

I was having a problem with slow report generation. I am using Jasper Studio 6.3.1. My main working report generates one page per main query record. Each page has fields, tables, and charts. The report is working ok with the exception of speed and the Processed Records Count being VERY HIGH. With Google, I found suggestions not to put tables and charts into the detail bands but what if this is needed? I created a simple test report to demonstrate the issue of high Processed Records Counts. All queries, including table data sources, are simple and just return one record in this test. Test 1: Run the report with no tables. Processed Records Count = 1 as expected. Test 2: Run the report with one one record table. Processed Records Count = 3?? I think this should be two. One for the main data record and one for the table query. Test 3: Run the report with two identical tables with the same query/data source. Processed Records Count = 6?? Test 4: Run the report with three identical tables with the same query. Processed Records Count = 10?? The records count appears to be increasing rapidly. If I did this test one more time, the count would be 15 records. Any ideas?

That is what it looks like to me too. I have complete control of thte server so if you could get me that dump of an initialized JasperServer DB, I rthink that would do the trick.

More research done. It apears that the jasperserver DB is being created OK even though it crashes.If I do a re-run the install with ./js-install-ce.sh and tell it not to delete the existing jasperserver DB, the install continues to install the foodmart and sugarcrm DBs. It looks as if the install is failing at installing the contents of js-catalog-minimal-ce.zip file. This file loads all rthe default values into the tabels for Jasper Server to initially operate. All the jasperserver DB tables are empty except for qrtz_locks which has five records. The app is deployed to Tomcat but it will not start.

I am trying to install the WAR in an EC2 instance. All has going well with the Install Guide instructions. I have run the ./js-install-ce.sh test command and all looks good after a few adjustments. However, when I run the final install command ./js-install-ce.sh to actually do the install I am getting the error below. Any help would be appreciated. Linux: 2.6.35.14-106.49.amzn1.i686 java version "1.6.0_30" Java SE Runtime Environment (build 1.6.0_30-b12) Java HotSpot Client VM (build 20.5-b03, mixed mode, sharing) Apache Tomcat/6.0.33 PostgreSQL 8.4.9 on i386-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.4.5 2011 0214 (Red Hat 4.4.5-6), 32-bit ************************************ **Bunch if successful inserts to the DB and then... (advanced-sql) 121 of 121 SQL statements executed successfully (echo) Filtering properties (cleaning out blank spaces) import-minimal-ce: (echo) (echo) Property values (in install.xml): (echo) archiveArg = --input-zip=/var/ftp/pub/buildomatic/install_resources/export/js-catalog-minimal-ce.zip (echo) dbType = postgresql (echo) jdbcJar = postgresql-9.0-801.jdbc3.jar (echo) currentConf = /var/ftp/pub/buildomatic/build_conf/default (echo) importExportConfig = /var/ftp/pub/buildomatic/conf_source/ieCe (echo) (echo) Validating JasperServer database connection at jdbc:postgresql://localhost:5432/jasperserver. Phase: [import-export-test] (echo) For JDBC driver the artifactId and version properties are set: (echo) maven.jdbc.artifactId=postgresql (echo) maven.jdbc.version=9.0-801.jdbc3 (echo) Specified JDBC driver jar exists (advanced-sql) Executing commands (advanced-sql) 1 of 1 SQL statements executed successfully (echo) Connection OK (java) Exception in thread "main" java.lang.NoClassDefFoundError: com/jaspersoft/jasperserver/api/JSException (java) Caused by: java.lang.ClassNotFoundException: com.jaspersoft.jasperserver.api.JSException (java) at java.net.URLClassLoader$1.run(URLClassLoader.java:202) (java) at java.security.AccessController.doPrivileged(Native Method) (java) at java.net.URLClassLoader.findClass(URLClassLoader.java:190) (java) at java.lang.ClassLoader.loadClass(ClassLoader.java:306) (java) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301) (java) at java.lang.ClassLoader.loadClass(ClassLoader.java:247) (java) Could not find the main class: com.jaspersoft.jasperserver.export.ImportCommand. Program will exit. BUILD FAILED /var/ftp/pub/buildomatic/bin/db-common.xml:878: The following error occurred while executing this line: /var/ftp/pub/buildomatic/bin/import-export.xml:267: The following error occurred while executing this line: /var/ftp/pub/buildomatic/bin/import-export.xml:158: Java returned: 1 Post Edited by watsocd at 12/13/2011 23:57 Post Edited by watsocd at 12/14/2011 15:07

I have some data that takes considerable time to generate. At this time, it is in the following format. I can modify the query to provide the data in a different format. Code: Timestamp A B status 1:00PM 1 0 1 1:01PM 2 null 2 1:02PM 3 null 2 1:03PM 4 5 1 1:04PM 5 null 2 1:05PM 6 null 2 1:06PM 7 10 1 1:07PM 8 null 2 1:08PM 9 null 2 1:09PM 10 15 1 I want to plot both column A and B on the same chart with time along the X axis. The status column is used to indicate if B has a valid value. I am plotting column A OK because it does not have any nulls. Column B is causing me problems because of the nulls. Any suggestions on how to implement. Chuck EnergyChaser.com

Thank you. Here is my completed code for others. Code:import java.awt.BasicStroke; import net.sf.jasperreports.engine.JRAbstractChartCustomizer; import net.sf.jasperreports.engine.JRChart; import net.sf.jasperreports.engine.JRChartCustomizer; import org.jfree.chart.renderer.xy.XYLineAndShapeRenderer; import org.jfree.chart.JFreeChart; public class TSChartCustomizer extends JRAbstractChartCustomizer { public void customize(JFreeChart chart, JRChart jasperChart) { XYLineAndShapeRenderer renderer = (XYLineAndShapeRenderer) chart.getXYPlot().getRenderer(); BasicStroke stroke = new BasicStroke(3f); renderer.setSeriesStroke(1, stroke); } } Chuck EnergyChaser.com

How can I change the line/pen width of the pens on a time series chart? Chuck EnergyChaser.com