sachin_kataria

Hi, i have created master report with 12 subreports, and for that 12 subreports i am using 12 tables to fill data. Its working fine. But, my problem is when there is no data in table it is not showing that subreport. so, according to my requirement i have to show column header and after that message "No data Exists.." when there is no data in table. so, how i can do that..? its urgent. please help me.

hi, after many days i created subreports successfully, but two reports are overlapped. And view is not appearing properly. Both reports are appear together. (not showing one after another, second is displaying on first). so, how i can set view, that first subreport will display after that second sub report will display. Thanks in advance.

hi, i have to create multi report. From last many days i am trying to create but fail. i have to show 3 or more queries result in one report and all the queries have no relationship and no common field. i have seen some examples from google, but in all that there is relationship between master-detail report. but in my case there is not any relationship. when i am executing i am getting blank page. so, i want to know without passing common parameter between master and child report, can we show report ? how we can do that ? for that i have to use different datasource ? i tried all different ways to view report but failed.. its urgent. pls, help me...

Thanks for reply. I do not have to pass any parameters in sub-report. all the queries are different there is not any relationship between queries. From last three days i try hard to create multi report but failed, i try to cry it and it is not showing me any result. When i am executing my program i am getting blank page. my code is here : Master jrxml file : <?xml version="1.0" encoding="UTF-8"?> <!-- Created using an evaluation version of JasperAssistant (http://www.jasperassistant.com) --> <!DOCTYPE jasperReport PUBLIC "-//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="Database_Detail_Info" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="30" bottomMargin="30"> <property name="com.jasperassistant.designer.Grid" value="false"/> <property name="com.jasperassistant.designer.SnapToGrid" value="false"/> <property name="com.jasperassistant.designer.GridWidth" value="12"/> <property name="com.jasperassistant.designer.GridHeight" value="12"/> <parameter name="User_Info" class="net.sf.jasperreports.engine.JasperReport"/> <detail> <band height="52"> <subreport> <reportElement x="12" y="6" width="375" height="21"/> <subreportExpression class="net.sf.jasperreports.engine.JasperReport"><![CDATA[$P{User_Info}]]></subreportExpression> </subreport> </band> </detail> </jasperReport> child jrxml file : <?xml version="1.0" encoding="UTF-8"?> <!-- Created using an evaluation version of JasperAssistant (http://www.jasperassistant.com) --> <!DOCTYPE jasperReport PUBLIC "-//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd"> <jasperReport name="User_Info" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="30" bottomMargin="30"> <property name="com.jasperassistant.designer.Grid" value="false"/> <property name="com.jasperassistant.designer.SnapToGrid" value="false"/> <property name="com.jasperassistant.designer.GridWidth" value="12"/> <property name="com.jasperassistant.designer.GridHeight" value="12"/> <field name="USERNAME" class="java.lang.String"/> <field name="ACCOUNT_STATUS" class="java.lang.String"/> <field name="DEFAULT_TABLESPACE" class="java.lang.String"/> <field name="TEMPORARY_TABLESPACE" class="java.lang.String"/> <field name="CREATED" class="java.util.Date"/> <detail> <band height="28"> <textField> <reportElement x="3" y="5" width="80" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{USERNAME}]]></textFieldExpression> </textField> <textField> <reportElement x="89" y="6" width="80" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{ACCOUNT_STATUS}]]></textFieldExpression> </textField> <textField> <reportElement x="175" y="6" width="80" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{DEFAULT_TABLESPACE}]]></textFieldExpression> </textField> <textField> <reportElement x="261" y="6" width="80" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{TEMPORARY_TABLESPACE}]]></textFieldExpression> </textField> <textField> <reportElement x="348" y="5" width="80" height="20"/> <textElement/> <textFieldExpression class="java.util.Date"><![CDATA[$F{CREATED}]]></textFieldExpression> </textField> </band> </detail> </jasperReport> Java Program : import java.sql.*; import java.util.HashMap; import java.io.*; import net.sf.jasperreports.engine.JREmptyDataSource; import net.sf.jasperreports.engine.JRResultSetDataSource; import net.sf.jasperreports.engine.JasperCompileManager; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.JasperReport; import net.sf.jasperreports.engine.design.JasperDesign; import net.sf.jasperreports.engine.util.JRLoader; import net.sf.jasperreports.engine.xml.JRXmlLoader; import net.sf.jasperreports.view.JasperViewer; public class Test { public Test(){ } public Connection getConnection(){ Connection conn = null; String url = "jdbc:oracle:thin:@192.168.0.250:1521:sipl"; try{ Class.forName("oracle.jdbc.OracleDriver"); conn = DriverManager.getConnection(url, "system", "ganesh"); }catch(Exception e){ System.out.println("Error in getConnection() : " + e.getMessage()); } return conn; } public void createReport(){ Connection conn = null; Statement stmt = null; ResultSet rs = null; try{ conn = getConnection(); stmt = conn.createStatement(); String strQuery = "SELECT USERNAME, ACCOUNT_STATUS, DEFAULT_TABLESPACE, TEMPORARY_TABLESPACE, CREATED FROM DBA_USERS"; rs = stmt.executeQuery(strQuery); JasperCompileManager.compileReportToFile("User_Info.jrxml"); JasperFillManager.fillReportToFile("User_Info.jasper", new HashMap()); JasperReport multiReport = (JasperReport)JRLoader.loadObject("User_Info.jasper"); HashMap hashMap = new HashMap(); hashMap.put("User_Info", multiReport); JasperCompileManager.compileReportToFile("Database_Detail_Info.jrxml"); JasperPrint multiPrint = JasperFillManager.fillReport("Database_Detail_Info.jasper", hashMap, new JRResultSetDataSource(rs)); JasperViewer jasperViewer = new JasperViewer(multiPrint); jasperViewer.setTitle("Database Monitoring Tool"); jasperViewer.setVisible(true); }catch(Exception e){ System.out.println("Error in createReport() : " + e.getMessage()); } } public static void main(String args[]){ Test test = new Test(); test.createReport(); } } so, what is there error ? pls, help me.

hi, i am new to jasperreport. I have created some reports using it. Now i have to create multi reports using it. so, how i can create multi report. Actually, My requirement is that, there is one form in swing, and it contains multiple checkbox. According to selected checkbox it will execute queries and from that create mulitple reports and graphs and all that should be diplay in one ReportViewer. So, how can i create multi reports. all the reports are dynamic. its urgent. please help me...