dnewsom

I've attached a report using the default database connection in the project. The report has a variable in the TableData dataset that is attempting to sum on the employeeid group.

What is happening with the issue? The variable looks like it could work depending on the values of the fields.

We've got some time to look into this and help out but we're not sure where to begin. If you could point us in the right direction we'd love to assist in getting this fixed.

I couldn't find any documentation and ended up just playing around with it. I did find it worked easier if I setup the dataset before I create the table. Over all it works similar to crosstabs with subtle differences. If you have any questions let me know and I'd be happy to help out as best I can.

I've seen this issue once before. Running iReport as administrator seemed to fix it.

Did you use the variable in a table or on the main report? Using it on the report works just fine, it only seems to be when I put it in a table that I have issues.

We're using a java.lang.Double but yes, it is set. It'll show the last field value, but it doesn't seem to want to sum.

I'm working on updating a bunch of our reports to use the new table elements. I've got my dataset setup and everything looks like it's correct. I have a group setup within it and I am trying to create a variable that will sum a price for that group. I've got it setup with calculation sum, reset on the group and no increments. When I put that variable in the group footer band of the table and all it reports is the value of the last row instead of the sum of that group. I've tried setting the evaluation time to auto, band, group and now but the result seems to be the same. Any advice would be appreciated.

You can set the markup of the text field to HTML so you could put a strong tag around the locations. Code:"This is one variable: <strong>" + $F{grp} + "</strong>. This is another one <strong>"+ $F{MtmRv} + "</strong>. An the last one : <strong>" + $F{MtmRa}+ "</strong> to check how it works depending on the length of each variable"

A method I've used in dealing with this is using a relative path. While I may not know exactly where the subreport will be located on a machine, I do know what it is in relation to the main report so I could set the path to something like: ../../reports/sub-report.jasper

No the cleanest way to do it but you could do something like: Code:(F{CSRIS_PRJ_M_ENDDT}.getMonth == 0 ? "Jan" : ($F{CSRIS_PRJ_M_ENDDT}.getMonth == 1 ? "Feb" : ($F{CSRIS_PRJ_M_ENDDT}.getMonth == 2 ? "Mar" : ($F{CSRIS_PRJ_M_ENDDT}.getMonth == 3 ? "Apr" : ($F{CSRIS_PRJ_M_ENDDT}.getMonth == 4 ? "May" : ($F{CSRIS_PRJ_M_ENDDT}.getMonth == 5 ? "Jun" : ($F{CSRIS_PRJ_M_ENDDT}.getMonth == 6 ? "Jul" : ($F{CSRIS_PRJ_M_ENDDT}.getMonth == 7 ? "Aug" : ($F{CSRIS_PRJ_M_ENDDT}.getMonth == 8 ? "Sep" : ($F{CSRIS_PRJ_M_ENDDT}.getMonth == 9 ? "Oct" : ($F{CSRIS_PRJ_M_ENDDT}.getMonth == 10 ? "Nov" : "Dec"))))))))))) Post Edited by dnewsom at 07/20/2010 07:26

All you need is the firebird driver JAR file. You can add this to iReport through the services window and it will then allow you to connect to a Firebird database.

We're currently working on updating our reports to use the table element that was introduced in 3.7.2. There was an enhancement in 3.7.3 to hide the columns which is awesome. I'm going through them now and as we're updating we need to have a condition to hide the table band. I couldn't see if there is currently a way to do that or if I should put in an enhancement. Post Edited by dnewsom at 07/19/2010 15:10

I saw this prior to 3.7.2. Since the move to Java 5 and being able to remove the boxing, I haven't been able to reproduce this.

All I'm really referring to is ensuring that the width of the sub-report is the same width as the main report. iReport provides a simple solution to do this in their formatting tools called "Adapt to parent width".