baggypants

At the risk of sounding facetious I'd use OpenOffice for lable printing. It supports the same JDBC connectors as iReport, has templates for standard Avery Lables and a nice wizard. If you really wanted to do it in iReport you can set the page to have columns and the detail band to have the same height as the lable, Adjustments would have to be made to margins and the column guttering. iReport would then distribute the data into a table style.

A cursory check on the MySQL page shows that both the DB and connector are still in development, is there a specific reason you need to use such cutting edge versions? Also what method do you use to disconnect the DB?

what DB is it?

You mention the tables have no PK/FK relationship. Do the tables share a common data column? are you trying to join them or are you trying to display the results of two totaly unrelated tables in the same report?

I'm reopening this because I noticed 3.6.0 is doing it as well. I'm almost sure it didn't used to and I'm trying to find out what has changed (If anything) Or whether I've just not done any reports that require footers since I got the new version

Here are the updated scripts with the admin fix from yeti96

Have a look in this thread for hints on getting Jasperserver tot run on Oracle http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=54994

I'm almost certain that it didn't use to do this but 3.6.0 has started to remove group footers when saving in compatibility mode. like 3.5.2 did. Any ideas? Is it happening to anyone else? The origianal bug is here http://jasperforge.org/projects/ireport/tracker/view.php?id=4021

I'm not sure what you mean by things printing at the end of the report as opposed to immediatly. However there is a "no Pagination" option in the report properties which prints the whole report as a single page. It keeps the page width but dosn't page break so you get a nicer crosstab break. Hope that is useful.

I did this by setting up a parameter in the Order By part of the SQL query and setting up a radio button control.

Have you seen this fabulous elegant walkthrough that may or may not have been written by me? http://therobinsonfamily.net/?p=30

First in windows set up an ODBC connection like this http://www.simongibson.com/intranet/odbc/ Then in iReport create a new JDBC connection using the JDBC-ODBC Bridge driver.

Even easier than that it to create a style in the Report Inspector, then create four conditional styles under it. Set all the cells to opaque and to use the style and off you go.

Thanks guys, this is great! I'm now merrily cascading things all over the place.

you can explicitly add it in the options. Tools > Options > Classpath tab > Add Jar works for me.

As iReport dosn't have a "Fit to Frame" property my best advice is to add a feature request to the tracker. If it is a property supported by Barbecue (Which is probable if you could select it for and pre NB iReport version) you might be able to write some customiser class for it in the same way you can customise properties for charts. I know nothing about writing customiser classes so I can't help you there.

Odd dev posts and rumors have version 3.6.x / 4.0 out in October / November ish. They tend to spring out with not much warning. In the meantime you can try by replacing the JasperReport jar files in %JasperInstallDir%/apache-tomcat/webapps/jasperserver/WEB-INF/lib It works with some versions . Have a search about and see if anyone else has tried it. Post Edited by baggypants at 09/07/2009 09:37 Post Edited by baggypants at 09/07/2009 09:37

The changelog says "- Updated to JasperReports 3.5.3 " JasperReports is the report engine packaged as jar files, JasperServer and iReport both use JasperReports to generate reports. iReport 3.5.3 has JasperReports 3.5.3 JasperServer has JasperReports 3.5.0 Now, all is not lost. because iReport from 3.5.2 has a compatibility save mode to save early versions of JasperReport files. It's in Tools > Options > General tab > Compatibility tab

If you do a search of the forum for "Dynamic Font" you will find a resonable number of posts with people asking exactly the same question. Lots have answers. Most arn't as facetious as this. You could even look here http://jasperforge.org/uploads/publish/jasperreportswebsite/trunk/faq.html?group_id=252#FAQ6

I've got an issue with Jasper analysis on Jasperserver Community 3.5 When I upload my schema to the server and create an analysis on it a vital space is missed out for some reason. I've poped the log output in the Code section and atttached the schema. To find the error your looking at the bit that says DAYFROM in the log. it should be DAY FROM It may be because I'm using the Oracle EXTRACT function. Code:20:27:13,056 DEBUG sql,http-8008-Processor23:108 - 2: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [select "DATETABLE"."YEAR" as "c0" from (SELECT TRANSACTIONS.ID AS TIME_TRANSACTIONS_ID, EXTRACT(YEAR FROM TRANSACTIONS.BOOKKEEPING_DATE) AS YEAR, EXTRACT(MONTH FROM TRANSACTIONS.BOOKKEEPING_DATE) AS MONTH, EXTRACT(DAY FROM TRANSACTIONS.BOOKKEEPING_DATE) AS DAYFROM LYONS4.TRANSACTIONS TRANSACTIONS) "DATETABLE" group by "DATETABLE"."YEAR" order by "DATETABLE"."YEAR" ASC]20:27:13,072 DEBUG sql,http-8008-Processor23:190 - 2: , exec+fetch 16 ms, 0 rows20:27:13,072 DEBUG sql,http-8008-Processor23:144 - 2: , failed (java.sql.SQLException: ORA-00923: FROM keyword not found where expected)

An interactive drill down could also be done with Jasper Analysis. However this seems to be mind bogglingly complicated for a layman to set up as far as I can see.

I think you could go with the second method and generate the table with a crosstab component. Have user and date as the rows and score as the columns with the some interger being the value.

Probably should be in the Jasperserver forum but there you go Assuming you added some Input controls for the report, make sure you select "Always prompt" on the page you added the controls. If you haven't added the controls have a good read of the Jasperserver user guide it's fairly indepth Post Edited by baggypants at 09/03/2009 08:10

Thank you!

It may be that the graph is a component have a read of the comments in this bug http://jasperforge.org/projects/ireport/tracker/view.php?id=4215