meeza4u

Hi, Thanks ".equals" worked if the returned is a single value ... I also found that if its a collection ".contains" can be used for multiple values in a collection..... Thanks again Meeza

PLEASE NOTE: report designed using iReport 4.5 and deployed in JasperServer 4.5 by linking the iReport designer to the server using Repository Navigator. I have also created the input control thru the Repository Navigator section. I couldnt figure out how to extract values from the CheckBox input control. Input Control type: Multi Select List of Values (Check Box) Parameter Name: P_Quater Parameter Value: Q1, Q2, Q3, Q4 My report has 4 columns displaying values that belong to 4 quaters sample as shows bleow Q1 Q2 Q3 Q4 =============== 01 02 03 04 01 02 03 04 01 02 03 04 01 02 03 04 What I am trying to achieve is If I select Q1, Q2 from my input control screen I want to see only the first 2 columns in the report Q1 Q2 =============== 01 02 01 02 01 02 01 02 My CheckBox parameter value from the input contol comes in as [Q1,Q2] How do I check the values by extracting the values as Q1 and Q2 so that I can do the following (P_Quater == "Q3")?true:false in "Print When Express" to supress the column Thanks for your help in advance. Meeza

In iReport4.5 if I use the “repo:statistics” to reference to my sub report call in the main report I am getting Unable to locate subreport with expression “repo:statistics” followed by java.lang.Exception: repo:statistics not found. In my case I have both the main report and the subreport residing in the same folder. All works good if I pass the full path as showin in the code section How do I resolve this issue…. Thanks for your help with this… Meeza Code: <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA["C:\\JasperReports\\statistics\\"]]></defaultValueExpression> </parameter>

Folks.... Getting following error message while loading iReport 4.5.1 designer (Fresh Installation) java.lang.ArrayIndexOutOfBoundsException: 3184 at sun.awt.shell.Win32ShellFolder2.getFileChooserIcon(Win32ShellFolder2.java:748) at sun.awt.shell.Win32ShellFolderManager2.get(Win32ShellFolderManager2.java:248) at sun.awt.shell.ShellFolder.get(ShellFolder.java:221) at com.sun.java.swing.plaf.windows.WindowsLookAndFeel$LazyWindowsIcon.createValue(WindowsLookAndFeel.java:1873) at javax.swing.UIDefaults.getFromHashtable(UIDefaults.java:185) at javax.swing.UIDefaults.get(UIDefaults.java:130) at javax.swing.MultiUIDefaults.get(MultiUIDefaults.java:44) at javax.swing.UIDefaults.getIcon(UIDefaults.java:411) at javax.swing.UIManager.getIcon(UIManager.java:613) at javax.swing.plaf.basic.BasicFileChooserUI.installIcons(BasicFileChooserUI.java:237) at javax.swing.plaf.basic.BasicFileChooserUI.installDefaults(BasicFileChooserUI.java:219) at javax.swing.plaf.basic.BasicFileChooserUI.installUI(BasicFileChooserUI.java:135) at com.sun.java.swing.plaf.windows.WindowsFileChooserUI.installUI(WindowsFileChooserUI.java:126) at javax.swing.JComponent.setUI(JComponent.java:653) at javax.swing.JFileChooser.updateUI(JFileChooser.java:1755) at javax.swing.JFileChooser.setup(JFileChooser.java:366) at javax.swing.JFileChooser.<init>(JFileChooser.java:341) at javax.swing.JFileChooser.<init>(JFileChooser.java:300) at com.jaspersoft.ireport.designer.options.IReportPanel.jButtonAddClasspathItemActionPerformed(IReportPanel.java:2216) at com.jaspersoft.ireport.designer.options.IReportPanel.access$2000(IReportPanel.java:84) at com.jaspersoft.ireport.designer.options.IReportPanel$27.actionPerformed(IReportPanel.java:938) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169) 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:236) at java.awt.Component.processMouseEvent(Component.java:5501) at javax.swing.JComponent.processMouseEvent(JComponent.java:3135) at java.awt.Component.processEvent(Component.java:5266) at java.awt.Container.processEvent(Container.java:1966) at java.awt.Component.dispatchEventImpl(Component.java:3968) at java.awt.Container.dispatchEventImpl(Container.java:2024) at java.awt.Component.dispatchEvent(Component.java:3803) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822) at java.awt.Container.dispatchEventImpl(Container.java:2010) at java.awt.Window.dispatchEventImpl(Window.java:1778) at java.awt.Component.dispatchEvent(Component.java:3803) [catch] at java.awt.EventQueue.dispatchEvent(EventQueue.java:463) at org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149) at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)

I am getting the same error message but in my case its with a sub report. I have added the sub report as Resource to my main report..... how to resolve this .... help Pls.....

Yes the requirement is like that I will have to display the sub reports in a specific sequence. I have given a sample report format in CaptnTony's response. Thanks for your help with this again. Meeza

Hi CaptnTony, First thank for a quick response Sorry if my question was not that clear.... I have 1 master report which is populated using a Oracle Stored Procedure --- till this it works fine. I then added two sub Reports. lets say Sub1 and Sub2 in the summary band. Sub1 displays the summary by category - uses the same stored procedure used by the master sub report Sub2 displays the input parameter - this uses a different stored procedure Sample Master Report No. Name Categroy Amount 01 WXY W001 10.00 02 MMM W001 10.00 03 WXYZ W002 10.00 04 MMMZ W002 10.00 Sub1 <Summary by Category Report> Category MyTitle <------ this comes from the second sub report W001 20.00 W002 20.00 Sub2 <The Parameter Report> User: MeeZa Title: MyTitle <----- this title that you are seeing in the second sub report this is what I want to pass as a shared variable to the Sub1 report..... Thanks for the help again.... Meeza

Hi I am designing my report using iReport4.5. I am new to Jasper Reports... 1. My main report displays the detailed transaction 2. First Sub Report say "SUMMARY_RPT" displays the summary by category 3. Second Sub Report say "PARAMETER_RPT" displays the input parameter's used Here is the requirement. In my second sub report PARAMETER_RPT I have a field that will give me a title value lets say the Field Name is "MY_TITLE" and the value is "THIS IS MY TITLE" as the output of my query. How do I pass this MY_TITLE from the second sub report to the main report and would like to display the value in my first sub report SUMMARY_RPT Or is there a way that I can pass the MY_TITLE directly from my Second Sub report to my First Sub Report using Shared Variable... if so could you please give me a step by step instruction with what and how to do.. Please help... Thanks Meeza

You can find a detailed step by step instruction on how to call Oracle Stored Procedurs in iReport Designer by following the below link... http://meezageekyside.blogspot.com/2012/04/jasper-reports-ireport-45-using-oracle.html#!/2012/04/jasper-reports-ireport-45-using-oracle.html

Hi, I have designed a report using iReport 4.5 and Oracle stored procedures that returns ref cursors. When I pass a correct parameter the report successfully returns data -- All good till now. When I pass a incorrect parameter the iReport designer displays No Data to display message so I changed the report property "When No Data" to "All Sections, No Detail" - All good till now. But my business requirement is to display a dummy band with a message stating "No Data to Display" and this band will display only when the stored procedures returns no records and this band should not display when the stored procedure returns data. How do i do that... Thanks for your help with this. Meeza

I am not able to proceed with the report design becasue of this issue (Please refer to the attached image) Report Designer: iReports 4.5.1 Database: Oracle 11g Other Configurations: 1. Set the ORACLE14.jar 2. PlSqlQueryExecuterFactory is also set I proceeded by clicking OK and manually set the fields in the report and while previewing I got the same error message. Please help in resolving this issue. Thanks Meeza

Hi, I am using iReport4.5.1 Designer/ JasperReport Server 4.5 to design and publish the reports. I am using embeded SQL in my report design process. I would like to find out how I can pass dynamic where clause as string to my embeded sql example below Report Query SELECT * FROM BOOKS B $P{WHERE_CLAUSE} -- this is defined as string parameter ORDER BY BBOOK_ID Where Clause sample 1 WHERE B.PUBLISHER_ID = 123456 Where Clause sample 2 WHERE B.PUBLISHER_ID = 123456 AND B.ISBN_ID = '1234-4321' Where Clause Sample 3 WHERE B.BOOK_ID IN(123, 124, 125, 126) The above where clause samples are from different option that the business user can select thru a java interface and our report engine will construct and will pass the string as parameter to the report. please help. Thanks Meeza