scottward

Thanks. I'll post there.

Hello, My company is in need of a JasperReport designer. We have a large database of sales data and will periodically need specialized reports designed. Is there a JasperReports job board where I can post the job? Do you have any recommendations? Sincerely, Scott Ward The Shefield Group

Thanks for the info Sherman. Here are the details of my setup and what's going on: Server side: - JS 1.2 - Tomcat 5.5.17 - HTTP (not HTTPS) Client side: - Internet Explorer version: 6.0.2900.2180.xpsp_sp2_gdr.061219-0316 - Also, IE version: 7.0.5730.11 - Both on Windows XP, SP 2 Report setup: - Nightly schedule creates PDF reports - These reports contain drill down links to a second PDF report that is generated on the spot and accessed via a URL as per the previous post Process to reproduce bug: - Login without a problem - Navigate to previously generated PDF report no problem - Click on the link to the second PDF report - IE 6: "The file you are downloading cannot be opened by the default program. It is either corrupted or has an incorrect file type." with option to Save or Close (no option to Open). - IE 7: see previous post I think it has to do with the fact that the file type of flow.html doesn't match with the PDF report. IE "protects" the user from this in case someone is trying to trick them into loading a harmless HTML page and actually sending a malicious file. What do you think? Sherman, I think that the fact that I can login without a problem means that cookies are being set. Am I right? Given the setup and process I've described above, do you think I can resolve the problem by setting the P3P header in Tomcat? If so, can you point me in that right direction as far as how to do that (either directions or a link to a resource)? Thanks! Scott

IE 7 is even worse: - Click on a link within a PDF report to a dynamically generated drill down report (also a PDF) and the download is intercepted for "security reasons" - Choose download and you get sent back to the original PDF report instead of the new one - Basically, with IE 7 there is no way to link one PDF to another if the target PDF is dynamically generated using a URL as in my previous post. Unfortunately, I can't just abandon IE users. Has anyone else experienced this issue? Solved it? Thanks, Scott

I load a PDF report with this link: http://myserver:8080/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/reports/ItemSales&output=pdf&StartDate=20070103000000&EndDate=20070103000000&StoreNumber=861 With Firefox, it loads no problem. With Internet Explorer 6, I get a dialog that says: "The file you are downloading cannot be opened by the default program. It is either corrupted or has an incorrect file type." Same issue as here: http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&id=5449&catid=8 Except that I don't even have the option to Open. Just save or Close. There are other posts about setting a header to "attachment" instead of "inline", but a) I'm not sure how to do that with JS and b) I'd rather it work properly and open in IE. Why does this work on Firefox but not IE? How can I fix it? Thanks, Scotty Post edited by: scottward, at: 2007/03/19 23:14

Thanks for the response Lucian. I figured out that the problem had to do with the the fact that whenever the measure was null, so was the variable I was passing to DateFormatUtils. The text field had an expression set to a measure and a hypertextReference that utilized a parameter to construct the link. When the measure was null, the paramater was too for some reason. I just made the expression for the link conditional so it only constructed the link (and referenced DateFormatUtils) if the measure was not null. Scotty

Hello, When I place a text field with the following expression in the main report, everything works fine: "test " + org.apache.commons.lang.time.DateFormatUtils.format($V{StartDate}, "yyyy") When I place the same expression in a textfield in the detail field of a crosstab, I get the following error: Error evaluating expression : Source text : "test " + org.apache.commons.lang.time.DateFormatUtils.format($V{StartDate}, "yyyy") groovy.lang.GroovyRuntimeException: Ambiguous method overloading for method: format. Cannot resolve which method to invoke due to overlapping prototypes between: [long, class java.lang.String] and: [class java.util.Date, class java.lang.String] at groovy.lang.MetaClass.checkForInvalidOverloading(MetaClass.java:1770) The StartDate measure is set as a Date with an expression that references the StartDate parameter, which is a Date. This is interesting: when I replace $V{StartDate} with "new Date()" it works fine! Also, if I type in numbers (to pretend that I want to enter a Long) it compiles. Its like the compiler can't tell if $V{StartDate} is a Date or a Long. But again I've triple checked that indeed it is a Date! What am I missing here? It may be something simple that my non-Java-experiened-eyes can't see. You're input is greatly appreciated. Scotty

I have not scheduled report jobs via SOAP, but I have managed to setup a workable system to programmatically create schedules. I did an export and took the generated xml file as a template. The script merges the data for each job with the template and creates individual xml files for each schedule. Once the files are created, I execute an import that sucks them into JS. A bit clunky, but it works well enough. Scotty

I wonder if it has to do with this: http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&catid=10&id=21159#21159

Please, supply more information. Are you getting an error? If so, what is it? Is the report displaying but not respecting the parameter you enter? Does the Input Control name in JI match exactly with the parameter in the report? Scott

It would be very helpful if JS could provide for additional criteria when deciding that its time to run a report job. Currently, its based on time only. However, I have numerous report jobs that need to run whenever there is new data in the database. However, the addition of new data is sporadic, not consistent. Currently, my only choice to keep the reports current is to run all the report jobs every night even though 90% of the time there is no change in output. Since these are complicated reports and take significant resources to run, that's not ideal. It would be perfect if I could: a) specify a query that returns a single value TRUE if new data is present and FALSE if not b) schedule the report job to run every night BUT it will only execute if (a) is TRUE So for example, I would write a query that compared the datetime the report was last fired and the latest modified date attached to the report data. It would be really cool if the "last fired" value could be exposed in some kind of environment variable, but I could either grab it from the jasper database or create something of my own if I had to. Does this make sense? Is there an existing way to accomplish this? Based on your feedback, I'll request the feature or not. Scotty

So I'm not crazy? THAT's a relief... ;) You're right: it works fine if you put a start date which is no big deal since you can put a date in the past. That's what I'll do for now. Bug is logged. Scotty

You can create an Input Control and choose "Single Select Query". That will allow you to create a list of values from a query that can be used as an input parameter. Does that make sense? Scott

I've submitted it now. Scott Post edited by: scottward, at: 2007/02/12 21:46

Thanks Lucian. Works like a charm. Scott

System info: Fedora Core 6 java version "1.5.0_09" Java 2 Runtime Environment, Standard Edition (build 1.5.0_09-b03) Java HotSpot Client VM (build 1.5.0_09-b03, mixed mode, sharing) I've attached the exported report jobs in case the problem is in the export routine instead of the import. I can't see any malformed XML in the vicinity of the date parameter, but who knows. Is the version of Java I'm using the problem? Scott [file name=myExport3.zip size=1467]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/myExport3.zip[/file]

castor-1.0.jar confirmed. OK here are the steps to replicate: - create report job for SalesByMonth (I don't think the paramaters matter, but if you want you can see the exact parameter values from the attached xml file) - export the job: ./ji-export.sh --report-jobs /reports/samples/SalesByMonth --output-dir myExport3 - import the job: ./ji-import.sh --input-dir myExport3 - edit the newly added report job and click through till you get to parameters. They are all fine except for the date. Let me know if there's anything else I can do. Scotty

Just testing the new import/export functionality. By and large it looks great. However, I did have one problem. I exported all my report jobs. Then edited one by hand as a test. Then I imported it. Worked fine. However, when I viewed the report job on the web, the date paramaters (StartDate and EndDate) were messed up. Here's the HTML source of the input on the form: Code: <input type="text" name="StartDate" id="StartDate" class="fnormal" value="<?xml version="1.0" encoding="UTF-8"?> <value type="date" xmlns:«»xsi="http://www.w3.org/2001/XMLSchema-instance">2007-02-28T00:00:00.000-08:00</value>"/> As you can see, the import procedure wrote: "<?xml version="1.0" encoding="UTF-8"?> <value type="date" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">2007-02-28T00:00:00.000-08:00</value>" as the value of the parameters instead of just: "2007-02-28T00:00:00.000-08:00". The snippet of the exported catalog file is here: Code:[code] <parameter> <key xmlns:«»xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="java:java.lang.String">EndDate</key> <value xmlns:«»xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="date">2007-02-01T00:00:00.000-08:00</value> </parameter> <parameter> <key xmlns:«»xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="java:java.lang.String">StartDate</key> <value xmlns:«»xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="date">2007-02-28T00:00:00.000-08:00</value> </parameter> <parameter> <key xmlns:«»xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="java:java.lang.String">StoreNumber</key> <value xmlns:«»xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="java:java.lang.Integer">1411</value> </parameter> Is this a glitch in the import program? THanks, Scotty

BTW, I'm using: JS 1.2 iReport 1.2.7

The new plugin works great until I try to double click on a report unit. I get the attached error dialog. jasperserver.log says: Code: Any ideas what's wrong? Thanks, Scotty size=297]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/irplugin_error.JPG Post edited by: scottward, at: 2007/02/08 18:26

If have a bunch of schedules set up that run each night. If something goes wrong overnight and the reports aren't created, it would be great to be able to run them manually. Perhaps a button under "Remove" that says "Run Selected". What do you think? Scott

> Until the next release is out, you can > either continue to use the workaround you > found or, if you're interested, I could post > some instructions on how to patch JI to fix the bug. Sure, that'd be great. Scotty

In JI 1.1: If you change the hours and minutes on a previously saved schedule and hit "Save" everything goes through fine except that the Next Fire Time is not updated. You have to click "No Re-occurance" then click back to "Calendar". The hours and minutes will be reset to 0, but if you fill in the new hour and minutes and save the schedule, the Fire Time will update. Not a huge issue, but a bit tedious if you have to change a few. Or am I missing something? Scotty

> create a view on the SQL server side to append > empty records at the beginning of the result. Not sure if its the BEST way, but this was my first thought as I read your question. Probably don't need a view though. You could just do something like the following (not sure if you use iReport or now). Set your query to: SELECT null records LIMIT $P{NumberOfLabelsToSkip} UNION ALL SELECT real records Make the labels print blank when null. Scotty

Lucian, thanks very much for the clarification. In your mind, is writing a script that generates the XML for the 200+ schedules (mimicking an exported file) then importing them using ji-import the best way to handle a large number of schedules quickly? Thanks, Scott