2006 IR Open Dicussion

By: Adrian Hummel - adhu ClassCastException with incrementer factory 2006-06-30 03:05 Hi all, I use a custom incrementer factory for a report variable. The factory creates an incrementer which uses a custom value class. All works fine if I compile/fill my report from within my java application. Generating a report using IReport 1.2.4 (with an active database connection) works only once and throws a ClassCastException for the data value object if I run it again (even though the object has the expected type). To debug I printed out the hashcode of the class (e.g. ValueClass.class.hashCode()) and of the object which I try to cast (obj.getClass().hashCode()). These two values are identical when running the report for the first time. I receive different hash codes the second time (but the one of ValueClass.class.hashCode() did not change). I suppose that something goes wrong with the class loader used by IReport (two different versions of the same class are loaded which are incompatible then?). If I restart IReport I can re-run the report once. Are there any solutions? Is this a bug? Thanx for feedback. Adi By: Giulio Toffoli - gt78 RE: ClassCastException with incrementer factory 2006-07-03 06:47 Try to run iReport using iReport.bat instead of iReport.exe. Let me know or open a bug. Giulio

By: none - digitalblade [PROBLEM] 1.2.4 main button and menu disabled 2006-06-30 01:17 I've a big problem with some installation, on two machine (of four) i've all main button on toolbar disabled, the query menu and some other are disabled too.. after some check i've verified that the machine are identical, all classpath and path are the same (i launch every java app with a batch that reset all variable and set my own environment, for more security i've make a compare of SET command result from commandline prompt) i use winxp sp2 os with JRE or SDK 1.4.2_03 (tested with both) Any help will be appreciated. TIA By: racelike - racelike RE: [PROBLEM] 1.2.4 main button and menu disabled 2006-06-30 16:01 maybe you need java 5 i have the same problem, i just didn't have time to check this on the machine that i have this problem...when i installed iReport 1.2.2 it worked ok with an older java version By: Giulio Toffoli - gt78 RE: [PROBLEM] 1.2.4 main button and menu disabled 2006-07-03 06:45 Due to a compatibility issue, iReport can work only with java 1.5. The problem was already fixed in CVS, you can compile now iReport with java 1.5 and run correctly using java 1.4. Giulio

By: David Karnowski - karnowski Can't see report band names 2006-03-14 11:00 Hi, We have a developer who can't see the report band names printed in light blue on the main designer window. For example in this screenshot: http://ireport.sourceforge.net/images/ir2shot6.jpg you see the "columnHeader", "detail", "columnFooter", "pageFooter", "summary" all printed in light blue identifying each band. Our one developer can't see those labels. The bands just appear all white with no labels. All our other developers don't have this problem. She is running iReport 1.2.0 with Java 1.5. I looked through the documentation and don't see any option for turning this on or off, so I'm guessing it's something weird with her PC, Java installation, or iReport installation (a missing font perhaps?). Any help appreciated. Thanks, David By: David Karnowski - karnowski RE: Can't see report band names 2006-07-06 08:52 All, just in case anyone else comes across this same issue, this was resolved. Turns out it was simply a contrast issue on the ancient LCD monitor our developer was using. The light blue text fades into white if the contrast is too high. Adjusting the monitor's contrast fixed the problem. Foolishly, David

By: karibouxe - karibouxe create $variable 2006-07-06 04:50 Hi, I want to calcul the percent of person in my report. There are a $F{NumberPerson} and $F{AllPerson} with the java.lang.Long type. I want to do: $V{percent} = $F{NumberPerson}*100/$F{AllPerson} I'm no idea, please help me. Tanks for your help. By: karibouxe - karibouxe RE: create $variable 2006-07-06 05:10 I try that: new Double(($F{nbperson}.doubleValue() * 100)/$F{allperson}.doubleValue()) I'm surprise the result move to down. for example: ----------------------- nb | all | % ----------------------- 1 | 4 | null 2 | 4 | 25 3 | 4 | 50 ... Is it a bug? or it's me the bug ? ;) By: karibouxe - karibouxe RE: create $variable 2006-07-06 06:03 it's me the bug :P there was a problem with my groups sorry

By: joeba - joeba4 iReport disabled buttons - empty "files" pane 2006-07-06 02:41 Hi, I have installed iReport 1.2.4 and am able to start the program. But, when opening a new report, all the buttons (except for "New" and "Open") are disabled. I see the new report, but am not able to manipulate it in any way. Also, the "opened files" pane is empty, even though I opened 2 new reports ... Does anyone have any idea what could be causing the problem?? thanks, PS: environment: - windows 2000 professional - jdk 1.4.2

By: Rasmus Kl沫e - rasmusk no "test successfull" message 2006-07-04 07:00 hi i receive no "test successfull" when i try to test a connection (Oracle OCI), but no error messages either. Does anybody know what the cause is..? Rasmus

By: omcosl - omcosl how to set break point in iReport 2006-07-03 22:54 as captioned, is it possible to set break point in iReport like in band's print when expression?

By: selmasul - selmasul needs BarChart Example???????? 2006-07-03 08:21 needs BarChart Example

By: Adrian Hummel - adhu ClassCastException with incrementer factory 2006-06-30 03:05 Hi all, I use a custom incrementer factory for a report variable. The factory creates an incrementer which uses a custom value class. All works fine if I compile/fill my report from within my java application. Generating a report using IReport 1.2.4 (with an active database connection) works only once and throws a ClassCastException for the data value object if I run it again (even though the object has the expected type). To debug I printed out the hashcode of the class (e.g. ValueClass.class.hashCode()) and of the object which I try to cast (obj.getClass().hashCode()). These two values are identical when running the report for the first time. I receive different hash codes the second time (but the one of ValueClass.class.hashCode() did not change). I suppose that something goes wrong with the class loader used by IReport (two different versions of the same class are loaded which are incompatible then?). If I restart IReport I can re-run the report once. Are there any solutions? Is this a bug? Thanx for feedback. Adi By: Giulio Toffoli - gt78 RE: ClassCastException with incrementer factory 2006-07-03 06:47 Try to run iReport using iReport.bat instead of iReport.exe. Let me know or open a bug. Giulio

By: none - digitalblade [PROBLEM] 1.2.4 main button and menu disabled 2006-06-30 01:17 I've a big problem with some installation, on two machine (of four) i've all main button on toolbar disabled, the query menu and some other are disabled too.. after some check i've verified that the machine are identical, all classpath and path are the same (i launch every java app with a batch that reset all variable and set my own environment, for more security i've make a compare of SET command result from commandline prompt) i use winxp sp2 os with JRE or SDK 1.4.2_03 (tested with both) Any help will be appreciated. TIA By: racelike - racelike RE: [PROBLEM] 1.2.4 main button and menu disabled 2006-06-30 16:01 maybe you need java 5 i have the same problem, i just didn't have time to check this on the machine that i have this problem...when i installed iReport 1.2.2 it worked ok with an older java version By: Giulio Toffoli - gt78 RE: [PROBLEM] 1.2.4 main button and menu disabled 2006-07-03 06:45 Due to a compatibility issue, iReport can work only with java 1.5. The problem was already fixed in CVS, you can compile now iReport with java 1.5 and run correctly using java 1.4. Giulio

By: guyq_chico - guyq_chico iReport 1.2.4 from CVS still not work on Win 2006-07-03 01:20 I must work on JDK1.4.2, so I have download iReport 1.24 from CVS server. when I compile get the following error: ---------------------------------------- [javac] Compiling 491 source files to D:javareportiReport-CVSiReport2cl asses [javac] D:javareportiReport-CVSiReport2srcitbusinesslogicireportIRe portCompiler.java:41: cannot access javax.persistence.EntityManager [javac] bad class file: D:javareportiReport-CVSiReport2libjpa.jar(java x/persistence/EntityManager.class) [javac] class file has wrong version 49.0, should be 48.0 [javac] Please remove or make sure it appears in the correct subdirectory of the classpath. [javac] import javax.persistence.EntityManager; [javac] ^ [javac] 1 error ---------------------------------------- By: Giulio Toffoli - gt78 RE: iReport 1.2.4 from CVS still not work on Win 2006-07-03 06:44 You have to compile with Java 1.5 due to the dependency with EJB 3.0. Ten you can run iReport using java 1.4 Giulio

By: Rasmus Kl沫e - rasmusk report with queries on different db's 2006-07-02 02:35 hey I have tried to use the subquery tutorial on the ireport homepage using two reports with two different database connections. However i am getting errors in the passing of parameters from the main report to the subreport. Can anybody tell me what might be wrong with this approach or could somebody explain a step-by-step approach for making reports involving multiple databases. thanks in advance for any advice sincerly Rasmus

By: racelike - racelike About Band Properties 2006-06-29 12:44 Hi What's the difference when you check or uncheck the option "split allowed" on a band property? I'd like to know if there's a way to control the Detail Band in order to bring more then one selection to it. I mean, if there's a way to have 3 columns on the detail band, and each one of them having information about 3 lines of a resultset. So on the left I would have information X for person X, on the middle information Y for person Y and on the right information Z for person Z I at least choosed 3 columns on the report properties, but it doesn't act as I thought. So the whole detail band keeps bringing information from one line of the selection I'm trying to make a report to generate labels for letters, so the sheet comes with 3 labels per line By: racelike - racelike RE: About Band Properties 2006-06-29 12:56 well, i'm sorry for opening this thread now i understand it, and it works like i thought... just choosing the number of columns... i still don't know what that "split allowed" option means, but soon i'll understand it By: ts_chung - ts_chung RE: About Band Properties 2006-06-30 17:59 i had try to use split allowed also. and the result output is that band starts on a new page

By: Rapsodia - rapsodia Print when isn't the last page 2006-06-30 01:12 Hy , In my report i would to print something on page footer if the page isn't the last one, but i can't do that.... Someone can help me? Thanks to all By: TBG - thebiggunner RE: Print when isn't the last page 2006-06-30 02:43 Hi. How many pages do you have? You can print the page footer only if you have more pages. If you have only one page, this page is the last page and only the last page footer will print.:) By: Rapsodia - rapsodia RE: Print when isn't the last page 2006-06-30 03:15 The number of the page are variable. The idea is to print how i need on page footer, but in the last page the footer doesn't print becouse how i need is in the last page footer. By: ts_chung - ts_chung RE: Print when isn't the last page 2006-06-30 17:34 i think you need to show last page footer band and page footer band together. what you need to display on page footer put inside page footer band. what you need to display on last page footer put in last page footer band. if nothing to show in last page footer but dun want to print there just left the last page footer band empty.

By: robertsiqueira - robertsiqueira Group in crosstab 2006-06-30 12:05 Hi!! there is a way of build a group in a crosstab to break to a new page ?? I would like using a group in crosstab, like I using in my report without crosstab... Regards... Robert

By: Damian Sobieralski - dsobiera Hibernate - HQL error (table name) 2006-06-27 10:40 I'm trying to get a Hibernate datasource to work. i am using iReport 1.2.3. I am running on Windows XP. I have a hibernate.cfg.xml in my C:Program FilesJasperSoftiReport-1.2.3 directory. I also have Student.hbm.xml in that directory. I created a jar file with my POJO's thatStudent.hbm.xml is referring to and put it in in C:Program FilesJasperSoftiReport-1.2.3lib. I am running iReport via iReport.bat. I create a Hibernate datasource via the Data->Connections/Datasources menu. I press the "Test" button and all goes well. I set it as the default. I then go to the Data->Report Query menu item. I change the pull down from SQL to HQL. I enter the following: from Student At the bottom I get a message stating ""Error: Could not execute query using iterate". I look at the console window and I find this interesting item: 61678703 [Thread-6] ERROR util.JDBCExceptionReporter - Table 'GraduateDatabase. GraduateDatabase__student' doesn't exist But the table should be GraduateDatabase.student. Why is it concatinating the extra GraduateDatabase and __ to the table name? These same hibernate configuraitons work fine when I am using them in a servlet. Any ideas? By: Damian Sobieralski - dsobiera RE: Hibernate - HQL error (table name) 2006-06-29 14:06 Anyone? Even some advice on where to start looking would help. We're using Hibernate on our server and if I can get iReport to work with Hibernate.....well...i'll think about naming my second born after the product! :) By: Damian Sobieralski - dsobiera RE: Hibernate - HQL error (table name) 2006-06-29 14:11 I got it. I used the HibernateTools plugin to generate the hibernate cfg mapping files. I looked inside my Student.hbm.xml and when I removed: catalog="GraduateDatabase" ...all seems to work fine. I can issue the HQL now.

By: Taryn - tarynocs NEW: iReport-1.2.4 is NOT starting up. 2006-06-26 16:16 In the following cases my ireports will not start. I get stuck at the: "Loading available font family names" When I try to use the "iReport.exe" or Double clicking on "iReport.bat" in folder the C:Program FilesJasperSoftiReport-1.2.4 Im getting the following exception. Exception in thread "main" java.lang.NullPointerException at com.digitprop.tonic.SplitPaneDivider.oneTouchExpandableChanged(SplitPaneDivider.java:70) at javax.swing.plaf.basic.BasicSplitPaneDivider.setBasicSplitPaneUI(Unknown Source) at javax.swing.plaf.basic.BasicSplitPaneDivider.<init>(Unknown Source) at com.digitprop.tonic.SplitPaneDivider.<init>(SplitPaneDivider.java:56) at com.digitprop.tonic.SplitPaneUI.createDefaultDivider(SplitPaneUI.java:57) at javax.swing.plaf.basic.BasicSplitPaneUI.installDefaults(Unknown Source) at javax.swing.plaf.basic.BasicSplitPaneUI.installUI(Unknown Source) at com.digitprop.tonic.SplitPaneUI.installUI(SplitPaneUI.java:64) at javax.swing.JComponent.setUI(Unknown Source) at javax.swing.JSplitPane.setUI(Unknown Source) at javax.swing.JSplitPane.updateUI(Unknown Source) at it.businesslogic.ireport.gui.docking.DockingContainer.recreateAll(DockingContainer.java:517) at it.businesslogic.ireport.gui.docking.DockingContainer.insertPanel(DockingContainer.java:247) at it.businesslogic.ireport.gui.docking.DockingContainer.insertPanel(DockingContainer.java:256) at it.businesslogic.ireport.gui.docking.DockingContainer.addPanel(DockingContainer.java:124) at it.businesslogic.ireport.gui.MainFrame.<init>(MainFrame.java:554) at it.businesslogic.ireport.gui.MainFrame.main(MainFrame.java:7110) I have been getting this error in the following versions :1.2.2, 1.2.3 as well. The only version to have worked is 1.2.0 Can someone please please help me. Please By: Vzern - vzern RE: NEW: iReport-1.2.4 is NOT starting up. 2006-06-26 18:56 Which version of iReports have you been downloading? The installer or the zip or the tar version? Also what version of Java have you been using? By: Taryn - tarynocs RE: NEW: iReport-1.2.4 is NOT starting up. 2006-06-27 08:29 I downloaded the installer. (the bat file comes with the installer too) Im running Java: j2sdk1.4.2_05 By: Giulio Toffoli - gt78 RE: NEW: iReport-1.2.4 is NOT starting up. 2006-06-27 09:40 Try java 1.5 Giulio By: Giulio Toffoli - gt78 RE: NEW: iReport-1.2.4 is NOT starting up. 2006-06-27 09:41 I think the problem is your L&F. Remove the .ireport directory in your user home and try again Giulio By: Taryn - tarynocs RE: NEW: iReport-1.2.4 is NOT starting up. 2006-06-29 09:52 Thank you soo very much, Giulio Toffoli, that worked! By: racelike - racelike RE: NEW: iReport-1.2.4 is NOT starting up. 2006-06-29 11:46 my problem with 1.2.4 version is that the main buttons and options aren't enabled I installed version 1.2.2 and now it works what can be the issue about this?

By: venz98 - venz Stored Procedure 2006-06-28 02:34 hi, Does ireport support stored procedures? I've tried using it in one of my report but it does not work. venz

By: Speed - jftan3 how to use subdata set 2006-06-28 00:14 while i am having the main database on my report, i need to add on a subdata set. but after i added a new subdata set, i cant execute the report cos shown error :- Errors compiling .subdataset.jasper! it.businesslogic.ireport.ReportClassLoader@da8b1d can anyone pls help me to solve or teach me? thanks

By: Giulio Toffoli - gt78 iReport with SAP 2006-06-27 09:47 I'm looking for users that use iReport with SAP. If you use iReport/JasperReports with SAP please contact me: giulio@jaspersoft.com Giulio (iReport project leader)

By: Tomas Garrido - tgarrido iReport 1.2.4 doesn't work on Mac OSX 2006-06-26 18:48 After installing 1.2.4 I can open a report on Mac OSX, but an exception ocurred after this and I can't edit the report. I'm running java 1.4.2 and it seems that iReport 1.2.4 is using 1.5 methods. Previous version worked fine. This is the stack trace that appears on the system console: apple.awt.EventQueueExceptionHandler Caught Throwable : java.lang.NoSuchMethodError: java.lang.Boolean.parseBoolean(Ljava/lang/String;)Z java.lang.NoSuchMethodError: java.lang.Boolean.parseBoolean(Ljava/lang/String;)Z at it.businesslogic.ireport.gui.ReportQueryDialog.setSubDataset(ReportQueryDialog.java:1840) at it.businesslogic.ireport.gui.MainFrame.setActiveReportForm(MainFrame.java:925) at it.businesslogic.ireport.gui.MainFrame.jMDIDesktopPaneInternalFrameActivated(MainFrame.java:859) at it.businesslogic.ireport.gui.MainFrame$3.internalFrameActivated(MainFrame.java:423) at it.businesslogic.ireport.gui.JMDIDesktopPane.fireInternalFrameActivatedListenerInternalFrameActivated(JMDIDesktopPane.java:147) at it.businesslogic.ireport.gui.JMDIDesktopPane.internalFrameActivated(JMDIDesktopPane.java:85) at it.businesslogic.ireport.gui.JMDIFrame.formInternalFrameActivated(JMDIFrame.java:188) at it.businesslogic.ireport.gui.JMDIFrame.access$400(JMDIFrame.java:42) at it.businesslogic.ireport.gui.JMDIFrame$3.internalFrameActivated(JMDIFrame.java:124) at javax.swing.JInternalFrame.fireInternalFrameEvent(JInternalFrame.java:1537) at javax.swing.JInternalFrame.setSelected(JInternalFrame.java:1057) at it.businesslogic.ireport.gui.MainFrame.openNewReportWindow(MainFrame.java:6888) at it.businesslogic.ireport.gui.MainFrame.openFile(MainFrame.java:4761) at it.businesslogic.ireport.gui.MainFrame.jMenuItemOpenActionPerformed(MainFrame.java:6431) at it.businesslogic.ireport.gui.MainFrame.jButtonOpenActionPerformed(MainFrame.java:6087) at it.businesslogic.ireport.gui.MainFrame.access$2100(MainFrame.java:81) at it.businesslogic.ireport.gui.MainFrame$21.actionPerformed(MainFrame.java:1559) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1819) at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1872) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:247) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:231) at java.awt.Component.processMouseEvent(Component.java:5166) at java.awt.Component.processEvent(Component.java:4963) at java.awt.Container.processEvent(Container.java:1613) at java.awt.Component.dispatchEventImpl(Component.java:3681) at java.awt.Container.dispatchEventImpl(Container.java:1671) at java.awt.Component.dispatchEvent(Component.java:3543) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3527) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3242) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3172) at java.awt.Container.dispatchEventImpl(Container.java:1657) at java.awt.Window.dispatchEventImpl(Window.java:1606) at java.awt.Component.dispatchEvent(Component.java:3543) at java.awt.EventQueue.dispatchEvent(EventQueue.java:480) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:234) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:178) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:170) at java.awt.EventDispatchThread.run(EventDispatchThread.java:100) By: guyq_chico - guyq_chico RE: iReport 1.2.4 doesn't work on Mac OSX 2006-06-27 00:39 I am in windows OS ,have the same wrong. By: Giulio Toffoli - gt78 RE: iReport 1.2.4 doesn't work on Mac OSX 2006-06-27 09:43 Fixed in CVS. Workaround: use java 1.5 Sorry guys :-) Giulio

By: guyq_chico - guyq_chico iReport 1.2.4 doesn't work on Windows OS 2006-06-27 05:00 Exception in thread "main" java.lang.NoSuchMethodError: java.lang.Boolean.parseB oolean(Ljava/lang/String;)Z at it.businesslogic.ireport.connection.JRXMLDataSourceConnection.loadPro perties(JRXMLDataSourceConnection.java:90) at it.businesslogic.ireport.gui.MainFrame.traverse(MainFrame.java:7872) at it.businesslogic.ireport.gui.MainFrame.loadiReportConfiguration(MainF rame.java:7732) at it.businesslogic.ireport.gui.MainFrame.loadiReportConfiguration(MainF rame.java:7630) at it.businesslogic.ireport.gui.MainFrame.<init>(MainFrame.java:331) at it.businesslogic.ireport.gui.MainFrame.main(MainFrame.java:7110) By: Giulio Toffoli - gt78 RE: iReport 1.2.4 doesn't work on Windows OS 2006-06-27 09:42 I already fixed the problem on CVS. Use java 1.5 to work around the problem Giulio

By: dominik_ - dominik_ print when expression: wrong evaluation time 2006-06-27 06:30 Hi, i have a jasper report with a chart. Everything is perfect with a usual query, i.e. a query that returns at least one result-row, but when the Query return no rows, i get a NullpointerException caused by the chart. In order to avoid this i tried to use the "Print when expression" on the chart. My expression is: new Boolean($V{REPORT_COUNT}.intValue()>0) The Evaluation Time of the chart is set to "report" but the variable is alway zero - regardless how many rows are returned. When i output the variable in a textfield in the same band (again the evaluation time set to "report") it prints the number of rows returned by my database Query. I think the problem is that the evaluation time is only considered by the chart but ignored by "Print when expression". Is it possible to create an expression that says: "Print only if the SQL-Query returned any rows". Or even better: Is it possible to express the evaluation time when i use a variable? Just something like $V{REPORT_COUNT}[@report].intValue() - $V{REPORT_COUNT}[@now].intValue() Regards dominik

By: tolga gucuk - e111982 Adding pdfs in jasperreport 2006-06-27 01:11 How can I add pdf files in jasperreports? I have 3 pdf files and have to make them 1 pdf file.Is tehere any function that enables this operation? thanks.

By: Param - pankaj_vaksh Problem with query in ireport1.2.3 2006-06-26 02:34 Hello friends, I m using ireport1.2.3. I put this query in the report. When I run this query in toad by replacing startdate with a any date like 22/02/2006 query is running fine but when I put this query in the ireport file it gives me an error stating that not a group by expression. When I tried to print the startdate value in ireport file it is printing that fine. I don’t think that it is problem with the query. Can anybody help me out SELECT TRUNC(ADD_MONTHS(TO_DATE('01/' || TO_CHAR(TO_DATE($P{startdate},'dd/mm/yyyy'),'mm/yyyy'),'dd/mm/yyyy'), FLOOR(MONTHS_BETWEEN(statdate,TO_DATE('01/'|| TO_CHAR(TO_DATE($P{startdate},'dd/mm/yyyy'),'mm/yyyy'),'dd/mm/yyyy') ) ) ),'mm') DATES, SUM(calls) COUNT FROM Table1 WHERE statdate >= TO_DATE('01/'||TO_CHAR(TO_DATE($P{startdate}, 'dd/mm/yyyy'), 'mm/yyyy'),'dd/mm/yyyy') AND statdate <= ADD_MONTHS(TO_DATE('01/'||TO_CHAR(TO_DATE($P{startdate}, 'dd/mm/yyyy'), 'mm/yyyy'),'dd/mm/yyyy'), 06) GROUP BY TRUNC(ADD_MONTHS(TO_DATE('01/' || TO_CHAR(TO_DATE($P{startdate},'dd/mm/yyyy'),'mm/yyyy'),'dd/mm/yyyy'), FLOOR(MONTHS_BETWEEN(statdate,TO_DATE('01/'|| TO_CHAR(TO_DATE($P{startdate},'dd/mm/yyyy'),'mm/yyyy'),'dd/mm/yyyy') ) ) ),'mm') ORDER BY TRUNC(ADD_MONTHS(TO_DATE('01/' || CHAR(TO_DATE($P{startdate},'dd/mm/yyyy'),'mm/yyyy'),'dd/mm/yyyy'), FLOOR(MONTHS_BETWEEN(statdate,TO_DATE('01/'|| TO_CHAR(TO_DATE($P{startdate},'dd/mm/yyyy'),'mm/yyyy'),'dd/mm/yyyy') ) ) ),'mm') ASC