toxy

Hello! I've created a crosstab with a yearly statistic about a "status" (one row per status and one line per year) - now I need an additional row with a calculated sub-sum.... is it possible? thanks! Christof

Perhapes I've just found another solution with readable code :-) new Date().getMonth() in an integer-variable. Same for year and day, and calculating inside the variable expression (add or subtract days, month, years). new Date().getYear() have to be added with 1900 to generate the current year (or subtract 100 for a two-digit year) - it's counting from 1900 But first tests gives a month one less the current, and a day one more than the current...? Hm, is there a counting too? how?... christof, going on testing..

thanks for the hint - I'll talk with our developer, perhapes he can include a ready made jar (calendar?)

Hi, isn't there a easy way in iReports to calculate the date one month back from today? Without calculating with milliseconds... and correct date with longer/shorterr months... In SQL it's so easy (DateAdd(mm,-1,getDate()) - thats it), but I need a field with the date I've used in the SQL-statement... Any solutions out there? thanks! Christof

Works perfectly! Many thanks! toxy

Hi again, in my report I've to print an IBAN-code. This is a quite long string with varying length (between 20 and 30 chars. approximatly). For reading, it is better to print it in groups of 4 chars. I don't think, there is a ready-made format function for this ... but I'm only a iReports-maker, not a java-programmer... perhapes I can get help here? http://community.jaspersoft.com/sites/all/libraries/ckeditor/plugins/smiley/images/regular_smile.gif thanks for any help toxy this is it, I would need: AT363471100000060815 --> AT36 3471 1000 0006 0815 (iReports 4.5.1)

sanbez Wrote: Try adding "manually" two days in milliseconds. For example: new SimpleDateFormat( "dd.MM.yyyy" ).format(new Date().getTime()+86400000*2) But IMHO is not good solution. But it must work. Post Edited by sanbez at 10/13/2011 17:00 /tools/fckeditor/editor/images/smiley/msn/teeth_smile.gif it works! of course not sooo elegant, but short and clear! Thank you very much!

Hello! Again I need some help... (iReport 4.1.1) I have a textfield in my report with two dates, today and a date some days later. My problem is the sytax for adding days to the date: "Geburtstagsliste vom " + new SimpleDateFormat( "dd.MM.yyyy" ).format( new Date() ) + " bis " + *today+2days*) ???[/code]I've found some postings about "calendar.add(...)" but my tries are all... thanks a lot!

I've found it... so I want to share my learning process :-) the line with the subreport (see picture in my last posting) is also a group and i put it in the group footer - with the above mentioned "success". Putting it into the header solves the problem... oh, it's so easy ;-) christof

next step in never ending story: I've got some sums, have a look at the attachment.... Every hint is welcome! Christof

Hi again, I'll try it again - perhapes someone can help...? A subreport fills a variable in the main report - this works well, I can print it out correctly at each line(=call of the subreport) Now I have to add this values for a group-sum... this should be trivial, but I can't manage it. I created a new variable for this sum and I think it's logical to define it with: Calculation: sum Reset type: group Increment type: column ...and I tried every(?) combination too: Reset type: report/column/page and Incr.type: none/report/group/page... nothing works. So I suppose my logic is basically wrong - that's I'm asking for! BTW: I'm working with iReports 4.1.1 Thanks a lot, Christof Post Edited by toxy at 10/04/2011 08:49

Hi, I need some help in building some sums in my report... please :-) (Using iReport 4.0.2) I have two groups in my report, in the footer of the inner group I'm calling a subreport, which is calculating a sum, prints it, returns it within a variable. I can print this variable in the same band using evaluationtime band (only for testing). Now I want to add this value to a sum for the outer group. I'm trying for hours... the output is always null. My way is another variable, calculation is sum, variable expression is the first variable, reset- and increment type I've tested in each possible combination... also I tried $V{variable1}.add($V{variable2}) as expression... no success.... Any idea for a solution...? Thanks a lot! Christof

wow - that could it be! I've solved the problem in the meantime by deleting elements one by one until the error disappeared, then I created them new. I think, there was at least one element I copied from another report... thanks a lot! toxy

Hi, I've problems to understand errormessages correctly... so my actual Report sends this when running: net.sf.jasperreports.engine.JRRuntimeException: Could not resolve style(s): Detail at net.sf.jasperreports.engine.fill.JRFillObjectFactory.checkUnresolvedReferences(JRFillObjectFactory.java:1630) at net.sf.jasperreports.engine.fill.JRFillObjectFactory.setStyles(JRFillObjectFactory.java:1557) at net.sf.jasperreports.engine.fill.JRBaseFiller.loadStyles(JRBaseFiller.java:1016) .... From other postings I know, that there should be a reference to a not exisiting style - but how can I find this reference? Where have I to look for? What exactly is missing...? Is there any help for me? thanks! toxy PS: I'm using iReports 4.0.0

Hi, I suppose, you have to solve that with a subreport for each band... toxy