mtassinari

Ok, I'll try it, thank you!

Hi everybody! As the topic title suggests, I'd like to know if there is a way to print an image into a report if that image is stored into a BLOB field on a database. Is this possible? If so, how? thanks in advance for your help.

I do not understand it too. And this is really frustrating for me... Well, personal feelings aside, I guess we'll just need to tell our customers to avoid the "&" symbol in that field, and this will solve the problem (sort of). Post Edited by mtassinari at 12/14/2009 07:53

I'm sorry, but we have no test case to try to reproduce the issue in a controlled environment, nor I have the time to prepare one. One thing I can say, is that we do not fill that parameter using the hashmap, in fact in the report that field is not a "parameter" (those which you call with $P{param_name}) but a database field (which is accessed with $F{field_name}) and it seems that the moment in which the data is loaded in the report and thereby accessible using $F{field_name} is too late to make the character substitution. That is, it is still performed, but the desired effect is not achieved. What you could do to try and reproduce it as close as our case as possible, is to put the string "Centro Trasformazione Rottami Sud di Maione Rosa & C. s.n.c." into a database table field and prepare a small report to fetch that string while applying the substitution. Post Edited by mtassinari at 12/10/2009 15:44 EDIT: I also tried to anticipate the substitution in the database query itself by using REPLACE(ragione_sociale_azienda,'&','&') but it would still print the style tag as is, without correctly parsing it Post Edited by mtassinari at 12/10/2009 15:55

I think that this works because it is directly in the XML template, while my data with the '&' character is stored in the database and retrieved at "compile time" when the template is filled. in one of my subreports I have a text field defined as (1) and "ragione_sociale_azienda" sometime may contain an '&' character. The problem here is that the character would appear within the style tag, and this completely screws it, so what I obtain is somethink like (2) with the "&" explicitly written and the style not parsed correctly. I hope this helps in showing what my problem is. Code:(1) "<style isBold="true">"+$F{ragione_sociale_azienda}.replaceAll("&","&")+"</style>n<style size="8">"+$F{ragione_sociale_sede}+"</style>"(2) <style isBold="true">Centro Trasformazione Rottami Sud di Maione Rosa & C. s.n.c.</style> Post Edited by mtassinari at 12/03/2009 08:49

Bumping the thread to ask again if anyone has a solution not requiring to modify how data is stored on the DB, 'cause that cannot be changed.

Yes, and I set it to use the "style" tag. Would it make any difference if I set it to use html tags? I cannot modify the database nor the way data is inserted into it.

Yes, I guessed it. But when is the substitution needed to be done? I've tried to do it directly in the report by doing something like $F{param}.replaceAll("&","&") but it is not working and just prints plain "&"

Hi everybody! I've noticed a problem while using JasperReports to make printed reports for our application. The problem is, if you have a styled text field or label, and the text between the style tags contains special characters like for example the character '&' , the style tag is not interpreted correctly but rather printed "as is". Is there a way to solve this problem? 'Cause it's quite an issue for us.

Could you please tell us how you solved the problem? We're facing it right now and have no idea of how to solve it.

SOLVED! I forgot to check if the field is empty or not.

Hi everybody. I'm trying to create a field with a string content based on multiple conditions. This is the code: (Double.parseDouble($F{ISRFI_spinta})<=0.75 ? "<style forecolor=\"green\">" : (Double.parseDouble($F{ISRFI_spinta})<=1.0 ? "<style forecolor=\"orange\">" : (Double.parseDouble($F{ISRFI_spinta})<=3.0 ? "<style forecolor=\"red\">" : (Double.parseDouble($F{ISRFI_spinta})>3.0 ? "<style forecolor=\"violet\">" : "<style forecolor=\"black\">"))))+$F{ISRFI_spinta}+"</style>" But I keep getting this exception: javax.servlet.ServletException: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : (Double.parseDouble($F{ISRFI_spinta})<=0.75 ? " " even if the condition seems correct to me. What am I mistaking? I've already lost an hour on this! EDIT: using JasperReports 3.5.3 and IReport 3.5.3 Post Edited by mtassinari at 08/24/2009 11:45

Sorry if I answer only now. I'm sorry but we cannot test it 'cause we use it here at the company I work for, and we have no time for testing =(

thanks for the announce :) I'll try that ASAP

Yeah, we also thought it could just be due to the italian version we are using at our company, that's why we decided to try also with the english version, but we got the same result. Anyway, I'd say it'll do no harm to try again perhaps reinstalling it from scratch :) But even if we get this to work correctly, we'd still need to have the native .docx support, 'cause we really need it (because of our customers' demands)

That's what we thought too. But even after a complete uninstall and reinstall of Office 2007 plus all of its SPs we are still unable to open it, and the same happens to each and every of our customers with their own Office 2007 installation. I know this is very strange, but we cannot understand what's going on so that the document won't open... EDIT: as a side note, I'd like to point out that when trying to open it, the document seems almost to open correctly but then the program crashes after a few seconds. Perhaps it is really a Word issue after all, and not one due to JasperReports... Post Edited by mtassinari at 07/08/2009 11:07

The possibility to export reports in .docx format would be exactly what we are looking for! I hope that a new version with that feature will be released soon! I have attached a .rtf document generated using JasperReports which we cannot open on Word 2007 but works fine with Word 2003 (both business, or professiona, english edition)

The problem is that we are unable to open any .rtf document made with JasperReports inside Word 2007, because the document makes the program crash. We do not actually know if this issue is related with the report or with Word, but we noticed that crashes happen ONLY when trying to open a document made with JasperReports. Also, we need the possibility to natively create .doc and .docx documents, which is currently impossible using JasperReports alone, if I'm not mistaking.

Hi everybody, Perhaps this is not the best place where to ask, but I'd like to give it a try anyway. At my company we decided we have to move to a new report generator program because we are having compatibility problems with new office version. So, my question is: is there any automated conversion tool that can convert our .jrxml report templates to, let's say, Crystal Report's .rpt format, so that we do not need to rewrite a hundred report templates from scratch? Thanks in advance for the help you'll be willing to give me :)

Is there any new idea of what could be making it malfunction on our computers? We REALLY need to get it work, but up to now, all our ideas did not work...

We have just installed SP2 for Office 2007, but we keep getting errors. See attached screenshot for details. No error with Word 2003, though.

Here is a screenshot of our current Word 2007 version, which seems to be the same you have :S How is it possible that we keep having crashes? Could it be due to the fact that we use the Italian version of it?

Well, every time we try to open that document under Word 2007, it crashes. This also happens to our customers, not only to us. As a side note, we create our reports using JasperReports 3.0.0, but even after trying to upgrade to last version, the error still occurred. Attached you can find a screenshot of the error (still in italian, I know, but the important parts should be understandable). EDIT: we work using JasperReports 3.1.2 and all dependencies it requires, and not 3.0.0 as previously stated. Also, we work via tomcat 5.5.17 and java servlets, with JDK 1.5.0_12-build04 Post Edited by mtassinari at 05/14/2009 07:48

Hi! I'm opening this thread to require assistance as per the topic title. I'm currently working for a software development house which uses JasperReports to create printed reports of the program's output. The program itself is a PHP web-based application. The fact is, we would really need to have it compatible also with Word 2007. Is this possible? Here attached is an example of the kind of document we create, which works correctly with Word XP or 2003, but not with 2007. It is written in Italian, so do not marvel if you can't understand a single word ;)