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