contentengineer

This is the code we use for piping in a list of document references as a parameter in SQL: 1. $P{list} - this is the original field i.e. "INV100000,INV100001,INV100123" 2. $P{listparsed} - the parsed list with default value expression: $P{list}.replace(",","','") 3. In query: select * from <table> where docid in ('$P!{listparsed}') Works a dream on about seven reports we run thro' Jasperserver and iReport

In iReport, when exporting as CSV file; empty spacer columns are not shown in the raw file output If run in Java using JasperReports, additional commas appear presumably from the spacer columns In JRXlsAbstractExporter there is the capability to set IS_REMOVE_EMPTY_SPACE_BETWEEN_COLUMNS property There does not appear the same in JRCsvExporter method -- I have removed pagination prior to running fillManager, but additional spaces still appear. Is there an undocumented property that can remove spaces in CSV? Does iReport use the JRXls rather than JRCsv exporter? --

We have created a report (designed for CSV) that will then be used as basis for EDI messaging. When designed in iReport 2.0.2 and run-out we get the correct comma separated file. When we run the report through Java, using Jasper Reports library; additional comma's appear between fields that do not appear in IDE version. - iReport 2.0.2 -> CSV Builder with "notepad.exe" as viewer to see raw file CORRECT - Jasperreports JRCsvExporter - No pixel gaps between fields --- Code snippet from Java: JasperPrint jprint=JasperFillManager.fillReport(report,parameters,con); /* Need to catch blank reports! */ if (!jprint.getPages().isEmpty()) { JRCsvExporter exporter = new JRCsvExporter(); File destFile = new File(reportfilename); exporter.setParameter(JRExporterParameter.JASPER_PRINT,jprint); exporter.setParameter(JRCsvExporterParameter.OUTPUT_FILE_NAME,destFile.toString()); exporter.exportReport();

We are finding that on IE7 browsers, PDF documents are incomplete - i.e. in our example the graph components are missing the data (legends/axes are OK); but there are no errors on Jasperserver, the browser or other logs. (1) Reports are OK on IE6, Firefox and Safari (2) Errors are repeatable across machines (3) PDF files appear complete when saved from browser... correct PDF header/footer Any views? Guess this is either a bug in IE7 ActiveX (Mshtml.dll, shdocvw.dll) or something else [cookies]? Anybody else experiencing the issue?

Forget that approach.... this is far simpler: SELECT a FROM b where c in ('$P!{paramName}'); Then setup two parameters: name: paramInput type: String default to: "X,Y,Z" name: paramName type: String default to: $P{paramInput}.replace(",","','") produces a beautifully parsed query when paramInput is set as a single entry value (type: String)... Forget $X !!!

We have created a report using the $X{IN,colName,paramName} notation. (1) iReport does not parse this notation correctly; "Unrecognized SQL escape 'IN' " AND (2) Non of the input controls enable a user to enter a comma separated list of variables. We get Java exceptions if we choose "single value" before the parameters is displayed in the workflow. iReport2.0.2 JasperServer2.0

I'd recommend using VNC as a remoting tool, thus gaining access to your favourite windowing environment on Linux... clients available for windoze, mac etc

To solve this we've coded some Java using the Jasperreports classes, with some additional tables to run reports as batches in a two stage process: (1) generate reports and hold in repository; (2) email reports held in repository; (3) option to resend reports held in repository.

Lucian Excellent lateral thinking! I'm thinking as a short term fix to write a script in PHP/Java, to call the webservice, create a report PDF, and email using SMTP. Since we might be adding 1000 jobs in the future, I need some way of creating a "batch/sequential" type function... rather than overloading Quartz. It may be that I need a generic job in Quartz, that calls a "master job" which runs all the individual report units. Thoughts? Rob

We're looking for methods to add 100+ jobs to scheduler based on a csv file. For example we want to send a bespoke report to 100+ customers by email based on existing data; and are trying to avoid having to go through the traditional web interface to execute. It does not appear easy (nor practical) to add the raw data to the Quartz tables in a coordinated fashion using a MySQL import; due to the binary JOB_DATA (Map); plus TRIGGER_NAME and JOB_NAME. Tables: qrtz_cron_triggers, qrtz_job_details, qrtz_simple_triggers, qrtz_triggers Are there any other APIs to achieve this? It is not possible to drive a report generation from an existing table; as the email address has to come from Quartz.

Edit jasperserver-servlet.xml and change property "allowUserPasswordChange" to "true; in js common controller bean property settings.

Can you connect to the mail server using telnet, for example: telnet smtp.gmail.com 465 You should get a EHLO or HELO on the screen. If not, then you need to check your mail settings including FQDN and port number.

IMHO Upgrade process from 1.2.0 -> 2.0.0 requires further testing before being used in anger. Have had to backout from upgrade, even after running 2.0.0 in development for a while. - Have to modify all report entries [input controls] - Have to manually hack db if space character at end of label or name; otherwise export/import fails - Parameter passing - Extraneous errors in log files

Contrary to feature understanding, a mandatory input control set on an input control; does NOT force the input control dialog pop-up or page to appear. Exported existing data Upgrade JS 1.2.0 -> 2.0.0 Imported new reports Infact no input control data is passed to the report, so treats as null???

Additional notes: When updating report to always prompt, receive the following message: WARN ProxyWarnLog,http-8080-Processor24:581 - Narrowing proxy to class com.jaspersoft.jasperserver.api.metadata.jasperreports.domain.impl.datasource.RepoJdbcDataSource - this operation breaks