mdahlman

I agree, it's an issue with the Hibernate dialect. It should be possible to modify the dialect to get the correct mapping, but I have not looked into this yet. I think the correct data type for the event_data column in DB2 v9 should be "long varchar for bit data". Like this: Code:create table JILogEvent ( id integer generated by default as identity, occurrence_date timestamp not null, event_type smallint not null, username varchar(100), component varchar(100), message varchar(250) not null, resource_uri varchar(250), event_text clob(4000), event_data long varchar for bit data, event_state smallint, primary key (id) ); I noticed that sschaub was using DB2 8.x and got varchar(4000) where I got clob(4000). I'm not sure what the significance of the difference will be. Both store characters... but sometimes clob is less flexible. -Matt

Hi Fek, It looks possible that it's just related to the ordering of the result set. JR will simply read the values in order until it finds a different value to determine groups. Try adding an order by clause to see if it fixes things. Regards, Matt

Hi Thomas, You are right. It seems that I read your question too quickly. JR supports only a limited set of HTML tags. When it encouters a tag that it doesn't understand the content is just rendered as text. So there is no simple way to get unsupported HTML code (like style="border-bottom:dotted") into a report. In fact, I don't see much a short-term workaround for this. I discussed with the development team, and there are some ideas about how in the long term we might add support for arbitrary HTML. But plans aren't definite yet. In general JR is focused on providing identical output across all channels. So adding HTML features that would not be supported in other channels would be a bit of a departure from this philosophy. You could try reposting to the JR forum, since it's really more of a JR issue than an iReport issue. Perhaps someone else has come up with a sort of workaround to this. But I suspect that there is no simple solution today. Regards, Matt JasperSoft

Hi Ciryll, It looks like it was a known bug. (And it looks like you've seen that response on the talend forums now.) For anyone else encountering this issue, please take a look at this issue on the Talend forums. Regards, Matt JasperSoft

Hi Pegah, Thanks for posting your solution to the issue. I hope in the next version of IReport the problem is being solved.Please be sure to submit a bug or feature request including the steps needed to reproduce the problem if you want to see the issue addressed. Regards, Matt JasperSoft

Hi Pilous, This is a pretty common question. You need to use the property "Is styled text". You'll find other threads addressing it here and here. Probably your best starting place is to follow the link provided by Teodor in the JR thread "READ THIS before creating a NEW TOPIC". Download jasperreports-1.3.3-project.zip and you'll find jasperreports-1.3.3-demo-samples-styledtext-StyledTextReport.jrxml. This should be exactly the example you need. Regards, Matt JasperSoft Post edited by: mdahlman, at: 2007/06/10 16:29 Post edited by: mdahlman, at: 2007/06/10 16:31

Hi Raulsaavedrax, I'm not sure how iReport "decides" what language to run in. But it will render the report in whatever language Java is using. For example, my operating system is using English, therefore Java starts by default in English. Therefore in a text field with the expression "new java.util.Date()" and the Pattern "EEEEE dd MMMMM yyyy" I get this: Friday 08 June 2007 But if I modify iReport's startup.bat to launch in Spanish, then I get this in my report (without making any changes to the report): viernes 08 junio 2007 To run iReport in Spanish I added this parameter in startup.bat: -Duser.language=es Note: What language iReport runs in is a different question. When I changed the Java language to "es" my iReport still ran in English. But you can change this with the menu choice Options -> Settings -> Language. Regards, Matt JasperSoft

Hi Bernt, It smells like a bug... but I'm not sure yet. I'll take a look. In the meantime, please enter a bug in the JasperETL Project. Regards, Matt JasperSoft

Hi Ciryll, What versions of Oracle and of JasperETL are you using? With JasperETL v2.0.2 I'm able to make connections to Oracle 10.2.0.1.0 without problems using either Thin or OCI. 1. When you make a database connection you have a choice for the "DB Type". You have the choices "Oracle with SID" and "Oracle with service name" among others. These should be exactly what you need (despite being really terrible names). They correspond to Oracle Thin and Oracle OCI respectively (you can tell this by looking at the connection string). 2. For this question it's unclear what's going wrong for you. Obviously you are getting connected because you're able to get a table list. Normally on the next step you'll see the list of tables on the left in the box that's labeled "Schema" (it ought to be labeled "Tables"). On the right you see the details for the table that you've selected in the other box labeled "Schema" (it ought to be labeled "Columns"). Can you give any additional details (beyond the version numbers) about your situation? Regards, Matt JasperSoft

Hi Falcon, If you have already been through the 12 tutorials and taken a look at the documentation, there aren't other resources today. Are there particular pieces that you would like to see added to the documentation or to the tutorials? Documenation is an ongoing process for us, so your suggestions can impact the next round of documentation. Also, don't hesitate to post specific technical questions here. Regards, Matt JasperSoft

Hi Falcon, Your best starting point for working with JasperETL is probably the documentation. It's located here. It could also be interesting for you to take a look at these tutorials.

Hi heprox, Yes, it's easy to output to CSV (and other file formats). The tool of interest is tFileOutputDelimited, and it's located in the File section of the tool Palette. The tutorials on talend.com may be a good starting point. Regards, Matt

I think this thread has the information you need: http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=9&id=23632#23632 Regards, Matt

Hi Bryan, The iReport GUI is too complex to be fully ported to a web interface. It will remain a thick client (oops, I mean "rich client interface"). From what you described, it sounds like you may be interested in the ad hoc reporting that is included with JasperServer Professional. That is targeted at letting less technical business users design their own reports from a thin client (browser only) GUI. JasperServer Professional isn't Free, but there's a free evaluation you can download from jaspersoft.com. You might want to take a look and see if it's interesting for your needs. Regards, Matt

The instructions included in "howto.txt" that ships with the plugin (jasperserver-ireport-plugin-1.2.0.zip) are relatively clear. Was there a particular part that you found confusing or missing? It indicates to copy this file: jasperserver-ireport-plugin/jasperserver-ireport-plugin-<ver>.jar And copy these files: jasperserver-ireport-plugin/lib/*.jar They should be copied into the ireport lib directory: <ireport-install-dir>/lib The location to download the plugin is probably the most confusing piece. Some people expect to find it included with iReport (and there's some logic to this...) but really it's included with JasperServer. To make this slightly more confusing, the plugin is not included with the current JasperServer 1.2.1 download. You need to go to the downloads for JasperServer 1.2.0: http://sourceforge.net/project/showfiles.php?group_id=162962&package_id=195243&release_id=483124 Regards, Matt