dpinfo

The only solution I found is to use a subreport with the main logic and in main report only for the title page. In that way I have only the problem of positioning the number of pages, so I put that in the page header because in the page footer it is attached to the detail. Marco

Hi, I have a report with a group and would like the number of pages compared to the group. This is not a problem if I not have the title page, the numbers are correct first group 1/2 2/2 the second group 1/1 the third group 1/1 and so on If I print title on new page then the result is the following first group 2/3 3/3 the second group 1/1 the third group 1/1 and so on The error is only the first group. Can anyone help me? I use, for jre compatibilty, jasperreport 3.0. thanks Marco

/tools/fckeditor/editor/images/smiley/msn/thumbs_up.gif Thank you very much /tools/fckeditor/editor/images/smiley/msn/teeth_smile.gif /tools/fckeditor/editor/images/smiley/msn/teeth_smile.gif

ktrinad Wrote: By: Fco Antonio - jofranco sum of variables 2003-07-11 14:28 Hi: As I make the sum of two variables? By: Giulio Toffoli - gt78 RE: sum of variables 2003-07-11 15:22 new Double( $V{var1}.doubleValue() + $V{var2}.doubleValue() ) I have assumed that your vars was Double... Giulio Code:I have to make the sum of a parameter that is integer with a defalut variabile (Pages).I have defined the parameter as integer and according on the example upstair I did :new Integer($P{PAGIN}.intValue()+$V{PAGE_NUMBER}.intValue())he said me "Can not cast from int to Integer" the default value of $P{PAGIN} The default value is 100. I tried both with 100 and "100" and I have the same result.Please help me.Bye

Hi all, I need to create a report with a group and for each group occurence a crosstable as detail. I tried to do it, but I get only 1 crosstable in all report, and not many crosstables, 1 crosstable for each group. Is it possible? thanks Dpinfo

I have created a new file .zip with the report and the access db. I don't understand if I make some error in the report or if there is a bug passing the images from db with version 2.1 Thanks a lot for the help. Bye Dpinfo [file name=prova.zip size=30559]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/prova.zip[/file]

I have tried your way but I can't reach the result. So I have tried the road of the post http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=9&id=14215#14215 but I haven't reach the point too. So, now I post a little access db with the report on it. I have tried also in oracle db , but it doesn't work. Please help me Dpinfo [file name=IMMAGINE_PROVA-3057fb63c650f91e83a032193f3ad324.gz size=142310]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/IMMAGINE_PROVA-3057fb63c650f91e83a032193f3ad324.gz[/file]

I hope that now the file will be uploaded. Dpinfo [file name=IMMAGINE_PROVA.gz size=142310]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/IMMAGINE_PROVA.gz[/file]

I have tried your way but I can't reach the result. So I have tried the road of the post http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=9&id=14215#14215 but I haven't reach the point too. So, now I post a little access db with the report on it. I have tried also in oracle db , but it doesn't work. Please help me Dpinfo

I have tried your way but I can't reach the result. So I have tried the road of the post http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=9&id=14215#14215 but I haven't reach the point too. So, now I post a little access db with the report on it. I have tried also in oracle db , but it doesn't work. Please help me Dpinfo

I have never used this method, because my images are normally files, but you could take images from the db. If you want to catch more information you could search about java.io.InputStream I hope that this post will guide you : http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=9&id=14215#14215 I hope that this help. Bye dpinfo

Your query is : select sum(HN),sum(HS) from table where number="XX" you need to create a new query like this select TYPE_HOURS,TIME from (select 'OFFICIAL HOUR' AS TYPE_HOURS,SUM(HN) TIME FROM TABLE GROUP BY 'OFFICIAL HOUR' UNION SELECT 'REAL HOUR' AS TYPE_HOURS,SUM(HS) TIME FROM TABLE GROUP BY 'REAL HOUR') The query will show : Official Hours and the total time Real Hours and he the total time Then you can make a pie chart which will show for the type of hours the value of each one. I hope that this help. Bye

First verify that $P{PARAMETER} is java.lang.string as your field. If $P{PARAMETER} is java.lang.string the annotation $P!{PARAMETER should be the same of $P{PARAMETER} . But sometimes $P{PARAM} don't work properly, so I prefer to use '$P!{PARAM}' You can also do in this way : define the default of $p{PARAMETER} as "'TEXFIELD'" and then in the query write where field = $P!{PARAMETER} in the query will appear: field = 'TEXTFIELD' Hope that this help. Bye dpinfo

Thank you a lot for your help. At the end I decide to print every time $V{TOTAL_SUM_REG}, because to print whit a print when expression I need a Boolean, and the boolean like integer but not like double (can not cast from Double to Boolean). So when I print every time the ledger if the global amount is a debit the sign will be normal and if is a credit with a "-". Bye Dpinfo

Sorry in the post the correct expression validate from IReport are: 1) PRINT WHEN EXPRESSION OF $V{TOTAL_SUM_REG}: (($V{TOTAL_SUM_REG}.currencyValue()>0) ? $V{TOTAL_SUM_REG}; ($V{TOTAL_SUM_REG}*-1)) 2) PRINT WHEN EXPRESSION OF $V{SIGN_SUM_REG}: (($V{TOTAL_SUM_REG}.currencyValue()>0) ? "DEBIT";"CREDIT") Thank you a lot for help Bye Dpinfo