oilhands

Bueller?

Bueller?

I have a multiple page crosstab report. Everything works great except for the printing of the page footer band. The page footer band shows up great on the first page but does not appear on any subsequent pages. I tried using the Last Page Footer band but it didn't work. I am using iReport 3.0.0 with the JasperReport 3.0.1 JAR file. Thanks.

Indeed it is fixed in 3.01. I downloaded the new jar, renamed the old jar file to a .OLD extension, and copied it into the iReports lib directory. I was then able to execute the report using the active connection and also compile using the massive compiler. Thanks a bunch.

Version 3.0.0 of iReports. Interestingly enough I was able to get the report to work yesterday by first using the {Build}|{Execute (with empty datasource)} menu item. I generally use the massive compiler for compiling reports, but until I used the empty datasource option the massive compiler was giving a compiler error. So, I found a work around for version 3.0.0 and I'll go ahead and take a look at 3.0.1. Thanks.

Here is some data which the Oracle SQL query returns. If you replace the current query with a simple query of this data then you will be able to reproduce the exact circumstances. P.S. I am using iReport 3.0.0 and I am using the correct JAR file when running the report outside of the IDE. SET DEFINE OFF; Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('08/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '4Clinically Complex', '432Clinically Complex / ADL 4 - 5 / IADL 0', 1); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('08/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '1Rehabilitation', '122Rehabilitation Low / ADL 4 -10 / IADL 0-1', 1); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('08/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '1Rehabilitation', '111Rehabilitation High / ADL 11 - 18', 1); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('08/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '7Physical Function', '741Physical Function / ADL 4 - 5 / IADL 1-3', 1); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('08/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '4Clinically Complex', '411Clinically Complex / ADL 11 - 18', 1); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('08/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '1Rehabilitation', '121Rehabilitation Low / ADL 4 - 10 / IADL 2-3', 1); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('08/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '7Physical Function', '710Physical Function / ADL 11 - 15', 1); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('08/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '2Extensive Special Care', '230Extensive Special Care 1 / ADL > 6', 1); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('08/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '7Physical Function', '742Physical Function / ADL 4 - 5 / IADL 0', 1); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('08/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '2Extensive Special Care', '220Extensive Special Care 2 / ADL > 6', 1); Insert into DATA (REPORT_MONTH, CLIENT_COUNT) Values (TO_DATE('09/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('09/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '5Cognitive Impairment', '522Cognitive Impairment / ADL 4 - 5 / IADL 0', 1); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('09/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '4Clinically Complex', '432Clinically Complex / ADL 4 - 5 / IADL 0', 1); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('09/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '4Clinically Complex', '421Clinically Complex / ADL 6 - 10', 1); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('09/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '1Rehabilitation', '122Rehabilitation Low / ADL 4 -10 / IADL 0-1', 1); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('09/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '7Physical Function', '720Physical Function / ADL 9 - 10', 1); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('09/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '1Rehabilitation', '111Rehabilitation High / ADL 11 - 18', 1); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('09/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '7Physical Function', '741Physical Function / ADL 4 - 5 / IADL 1-3', 1); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('09/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '7Physical Function', '730Physical Function / ADL 6 - 8', 1); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('09/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '4Clinically Complex', '411Clinically Complex / ADL 11 - 18', 1); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('09/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '4Clinically Complex', '431Clinically Complex / ADL 4 - 5 / IADL 1-3', 1); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('09/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '6Behavior Problem', '610Behavior Problem / ADL 6 - 10', 1); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('09/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '1Rehabilitation', '121Rehabilitation Low / ADL 4 - 10 / IADL 2-3', 1); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('09/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '7Physical Function', '710Physical Function / ADL 11 - 15', 1); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('09/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '6Behavior Problem', '621Behavior Problem / ADL 4 - 5 / IADL 1-3', 1); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('09/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '5Cognitive Impairment', '510Cognitive Impairment / ADL 6 - 10', 1); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('09/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '6Behavior Problem', '622Behavior Problem / ADL 4 - 5 / IADL 0', 1); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('09/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '2Extensive Special Care', '230Extensive Special Care 1 / ADL > 6', 1); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('09/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '7Physical Function', '742Physical Function / ADL 4 - 5 / IADL 0', 1); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('09/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '3Special Care', '320Special Care / ADL 4 - 13', 1); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('09/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '2Extensive Special Care', '210Extensive Special Care 3 / ADL > 6', 1); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('09/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '2Extensive Special Care', '220Extensive Special Care 2 / ADL > 6', 1); Insert into DATA (REPORT_MONTH, RUGS_CATEGORY, RUGS_GROUP, CLIENT_COUNT) Values (TO_DATE('09/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '5Cognitive Impairment', '521Cognitive Impairment / ADL 4 - 5 / IADL 1-3', 1); COMMIT;

Yeah, after confirming in the other forum that it is using version 3.0 of JasperReports I still have the exact same error as descibed above. Right down to the same line number. Any ideas folks?

svenn Wrote: One of the option should be "Lastest Available Version". In version 3.0 this would be 3.0. You should no need to change this value unless you want the report to be compatible with an earlier version on JasperReports. So, the bug fix must not have worked for my other error. OK. Thanks.

I have downloaded and installed version 3.0 of iReport. When I go to {Options}{Compatability} menu item and bring up the dialog for Compatability Options I do not see version 3.0 of JasperReports listed. The last version listed in 2.0.5. I thought I would see version 3 listed. I am having trouble with a bug in crosstabs which should be fix in the latest JasperReports release according to this thread here: http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=40996&res=41 Does anyone have any idea what I'm doing wrong or what I am failing to understand?

I am getting the same exact error with my crosstab report. I downloaded the new iReport 3.0 which apparently has JasperReports-3.0.jar and the error still occurs. When I went to the iReport Version Compatability dialog the list of jasper reports versions ended with version 2.0.5. Any idea on how to get this working?

I also would like to set the height of a band or make the band grow/stretch to accommodate fields within it. We are switching to JasperReports from Crystal Reports. This might be a deal breaker. I have dynamic parameters which are listed in the report title band. When the user selects lots of parameters the title band should grow to the height of the stretching field or the total of all the fields or something. Likewise, dividing the band up so that I can place a single field that will grow would be nice.