tkmbe

Hello I have 2 textfield calculations in an detail. 1.Textfield (($V{P1}.divide(new BigDecimal(1.21), 2, java.math.RoundingMode.HALF_UP)).multiply($V{C1})).toPlainString() 2. Textfield (($V{P2}.divide(new BigDecimal(1.21), 2, java.math.RoundingMode.HALF_UP)).multiply($V{C2})).toPlainString() How can I sum this 2 calculations and put in an variable to process later (in summary)?

BTW: ireport 5.1.0 version Independent from java version Tried: 32bit oracle jdk1.6.0_26, 64bit oracle jdk1.7.0_40 and 64bit jre-1.7.0-openjdk Select stament on mysql db does work right and also Report query preview data gives right lines ...

Hello I have a strange problem with ireport 5.1.0 I have a BigDecimal variable Calculation: System Reset Type: Page Increment Type: None InitalValue: new BigDecimal($F{p_value}).setScale(2,java.math.RoundingMode.HALF_UP) Now the value is set for the first 2 pages. The 3. page will use the value from the 2. page and 4.page will use value of 3.page after that of course all values are shifted by 1 I have also tried colum and it's the same stuff... Any idea? Greetings Beat

Hello I have my calulation now: ($F{iva_t} == 1 ) ? (new BigDecimal($F{p_value}).multiply(new BigDecimal($P{CambioDollar}))) : $F{p_value} But I''m unable to save te result in a variable. How can I do that? Does I need scriplet for that? Now I'm doing this calulation in a Textfield expresion. Is it unable to use and save in a variable in Textfields? I need to save because I have a lot of calculations to do with this result ...

Hello I want to use 2 detail groups but not vertically splittet I need horizontally splittet. I need to use a4 landscape to use original an copy of a bill. #################### # Orig # Copy # # Det1 # Det2 # #################### Is this posible with ireport? Properties have only band height not with... Thanks Beat

Hi Teodor I want to the the following: Get total as double which is saved as string in database TOTAL=Double.parseDouble($F{p_value}) and calculate the following SUB_TOTAL=TOTAL/1.21 IVA=TOTAl-SUB_TOTAL if field iva_t=1 or in case iva_t !=0 SUB_TOTALL=TOTAL IVA=0 How can I do that and how can I control the order of calculations i.e. SUB_TOTAL is calculated before IVA?

I have a report and need to calculate dependendent of an field some calculations and want to save this caululation in a variable to use in an other field. For example I have a filed with the amount p_value which is an amount but in a string (from database) and want to divide it by 1.21 save this value and subtract from the amount and assign the result to an other variable. How can I do that? I tried to create an variable SUB_TOTAL Variable Class: Double Calculation: Nothing Reset type: Report Incremente type: None which I try to add value $V{SUB_TOTAL}.add(Double.parseDouble($F{p_value})/1.21) or $V{SUB_TOTAL}.set(Double.parseDouble($F{p_value})/1.21) Nothing works... The ultimate ireport designer guide should have at least an example of using variable this way in my opinion :-( Thanks for any help

I need to copy & paste all elements of a detail1 node. How can I do that? The copy is enabled but pasting does not work. I want to have 2 almost same formulars per page in the same detail... Is there any possibility or do I have copy and past each element and do the whole arrnging stuff again???

Problem solved: After trying a lot of stuff and permutation of this. I've found some fragments in the forum but never a detailed info how to do that. Maybe this are basics but I think it would be nice in the manuel an exmaple of a counter not beginning by 0. Could help a lot of peoples maybe to save hours of try and error ... My example shows also how to use leading 0 for this counter value with an inital value as parameter. Here my solution: To use a counter with an inital value to beginn to count not from 0 in interval increment of 1 with leadings 0: Create a variable counter1 and edit the properties of this value: set Variable Class: to the type you want for example: java.math.BigDecimal Calculation: count Reset Type: want youn want for example never Increment Type: Column Create a TextField and add the counter1 value to the textfild i.e. $V{counter1} Go to to text field properties of this TextField and change Textfield Expression from $V{Number} to new DecimalFormat("00000000").format($V{Number}+$P{NumberStart}) I was not able to modify the Textfield Expression of the variable to do that. Maybe someone knows the trick, I did not found any solution... Hope this helps another one Greetings

Hello I need a counter which increments by one for every db row BUT must begin at a given start address. So I thought I create a parameter and a variable. The idea is: counter=counter+init value from parameter +1 I have defined mi variable "Number "as follow: Calculation: Count Variable Expression: ($V{Number}) I have read the answer about inital value from http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=57793 but if I define Variable Expression: $V{Number} + 5 The counter is 0 11 22 33 if I define Variable Expression: $V{Number} + 2 The counter is 0 5 10 15 Why there is added the doble of value + 1?? What is the right way to set an inital value and than incrementing by one every row?

Hello I need a unique number for every element in an report which should be start at a given number which I will enter as paramater and every reported element should grow by one. Something like if I give as parameter 2050: Client Name: gugus <- From DB Nr: X0001-0002051 <- Generated from JasperServer Client Name: klonk Nr: X0001-0002052 ... Can JasperServer generate this value? And would it be possible to save the last value back to the db? Greetings

Thanks for all the tips. Creating a datasource and putting the jar file in the mentioned location did the trick. Thanks a lot!!

Sorry I had only the installation manuel not the users guide. Now I have installed again from scratch and found the users guide Now I have found how to install the report... But the problem of mysql drivers still exists. Where should I install this driver? I have read you must install the driver in a readme but there is no info where to install...

Thanks for your answer. I'm not able to create any datasource from scratch. What's the glue? I then tried to modfiy the JDBC Data Source but I have not found a mysql jdbc driver installed. The only one I find is in ireport directory. Do I have install mysql connector by mysels in tomcat dir? Is there any documentation about all this stuff? It's really hard to work with jasperreports-server without documentation. And how can I import mi report generated i ireport? I know there a a lot of questions but I have not found this answers in the manuals :-(

Hello I'm very new to the whole jsaper stuff but I seems realy great!! I've created a report from an external mysql db with ireport. This works nice. But I want to use some input parameter etc. and so it seems this can be done exactly with jasperreports-server. Now the manual/samples always use the internal db ... I have no idea how can I use an report which is store in the internal db but use datas for the report from my remote mysql db :-( Where can I get such infos? Have found nothing in the manuel ... Greetings and thanks for any hint Beat