toxy
-
Posts
34 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Posts posted by toxy
-
-
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.gifthanks 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
-
The problem was solved by our db-developer... the calling application overwrites the parameter "SUBREPORT_DIR" with the right value of the actual installation. So I can develop my reports with a fixed subreports-path according to my installation, customer's installation doesn't bother me...
toxy
-
...seems to be a problem in the settings of the installation?!
toxy,
continuing searching...
-
anode36
Wrote:Personally I just use the relative path directly as the suberport expression, reffering to the relative location of the .jasper file. This is interesting... how do you write this exactly? In my case I would write: ""..//..//subreports//briefkopf_hoch.jasper" wich is interpreted by the compiler as "../../subreports/briefkopf_hoch.jasper". This expression is correct in all my knowledge of 20 years in IT... but doesn't work! :-(
greetings
toxy
( backslashes printed as slashes!)
Post Edited by toxy at 09/15/2010 06:46 -
hm, the "Subreport Expression" is $P{SUBREPORT_DIR}+"briefkopf_hoch.jasper". In the subdirectoy there are both files. Somwhere there is the setting "compile supreports" or similar... so iReports tries to compile it --> jrxml (if I understand it correctly).
thanks
toxy
-
this have been one of my multiple tries...
--> java.lang.Exception: ../../subreports/briefkopf_hoch.jrxml not found
thanks
-
Hi @all,
searching this forum, I found no hint to solve my problem:
I have a report (iReport 3.7.4, Win7-64) in this directory: C:\Users\Public\DocMgr\JRXML\Personen\Listen_Personen\
Subreports should be placed in: C:\Users\Public\DocMgr\JRXML\subreports
As I don't know the directory structure of the target pc, I've to address the subreport relatively. This should be solved via the parameter "SUBREPORT_DIR". This works fine if I fill it with the absolute path (C:\\Users\\Public\\DocMgr\\JRXML\\subreports\\) - but not with the relative one (..\\..\\subreports\\). I suppose, that my syntax for relative adressing is wrong... the error message is: java.lang.Exception: ..\..\subreports\mysubreport.jrmxl not found
Can anybody help?
toxy
-
hm - I guess you have to generate an ODBC-interface first (System-DSN). I have no Access-file here to try it...
the logic should be:
1. make the MDB accessible by ODBC
2. make the ODBC accessible by JDBC
good luck - I'm starting to weekend now... :)
cu
toxy
-
feragne wrote:
C:Documents and SettingsferagneBureaustagebddbase_telmob_agr is that a Microsoft Access Database file??? Perhapes I didn't understand your first posting correct...
toxy
-
..and ODBC
size=400]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/ODBC.JPG
-
new try...
size=338]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/JDBC.JPG
Adding an additional sum row to crosstab
in Products
Posted
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