carter_zhou

Thank you very much for your answer,but how can I do? net.sf.jasperreports.export.html.remove.emtpy.space.between.rows does not work when export HTML also.

net.sf.jasperreports.export.html.remove.empty.space.between.rows it does not work! <property name="net.sf.jasperreports.export.xls.remove.empty.space.between.columns" value="true"/> <property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value="true"/> <property name="net.sf.jasperreports.export.html.remove.empty.space.between.rows" value="true"/> It's good when export EXCEL,but <net.sf.jasperreports.export.html.remove.empty.space.between.rows> does not work when export HTML HTML: EXCEL:

net.sf.jasperreports.export.xls.sheet.names.{arbitrary_name} this property can define every sheet name,But I want rename use an variable .What should I do?

I want to export Excel with many sheets. How can I set name for each sheet use variable.

I have a problem when run <js-install-ce.bat> on win7 X64 this is log: Running install-normal-ce Ant task ---------------------------------------------------------------------- Buildfile: D:\Program Files\jasperreports-server-cp-4.7.0-bin\buildomatic\build.xml [echo] Filtering properties (cleaning out blank spaces) [echo] chkIfPackageManagedTomcat: check if package managed tomcat gen-config: [echo] Regen config files if they have already been cleaned: [echo] currentConf= D:/Program Files/jasperreports-server-cp-4.7.0-bin/buildomatic/build_conf/default test-ce-all-props: [echo] Checking properties: [echo] appServerType=tomcat7 [echo] appServerDir=D:/Program Files/apache-tomcat-7.0.29 [echo] dbType=mysql [echo] dbHost=localhost [echo] dbUsername=root [echo] dbPassword=********** [echo] dbPort=3306 [echo] js.dbName=jasperserver [echo] sugarcrm.dbName=sugarcrm [echo] foodmart.dbName=foodmart [echo] webAppNameCE=jasperserver check-dbtype-ce: test-appServerType-ce: do-install-upgrade-test: [echo] Checking DBMS host and port: [echo] About to validate host: localhost [echo] Host localhost is OK [echo] Done validating host: localhost [echo] About to validate port: localhost:3306 [echo] Port 3306 is OK [echo] Done validating port: localhost:3306 [echo] Validating administrative database connection at jdbc:mysql://localhost:3306/mysql. Phase: [test] [echo] About to validate JDBC jar existence [echo] Look in: D:/Program Files/jasperreports-server-cp-4.7.0-bin/buildomatic/conf_source/db/mysql/jdbc [echo] Found jar file: assuming OK BUILD FAILED D:\Program Files\jasperreports-server-cp-4.7.0-bin\buildomatic\bin\validation.xml:489: The following error occurred while executing this line: D:\Program Files\jasperreports-server-cp-4.7.0-bin\buildomatic\bin\validation.xml:370: The following error occurred while executing this line: D:\Program Files\jasperreports-server-cp-4.7.0-bin\buildomatic\conf_source\db\mysql\db.xml:29: The following error occurred while executing this line: D:\Program Files\jasperreports-server-cp-4.7.0-bin\buildomatic\bin\app-server.xml:60: Error invoking getDriver() method Total time: 2 seconds Checking Ant return code: OK

I'm a beginner ,How can I made the cell red when value is negative?