anupp

Hi, I have calculated % in each row.I m getting prob is how to calculate total sum % in footer section.i m sending jrxml code also .plz chek it where i m missing in jrxml. ex---> qty %tota 100 3.23 1000 32.26 1000 32.26 1000 32.26 total--3100 ? i want to total sum % in footer section Code: Post Edited by anupp at 09/24/2010 06:05

Hi, I have done percentage in ireport for each column.but i m facing problem is how to calculate sum of percentage in ireport.for example : row1 -10% row2-90% sum of Total percenatge is 100%.(i want to do that calculation only.) Thanks Anup

Hi, i want to generate pdf report but i m getting error net.sf.jasperreports.engine.JRException: Byte data not found at location : ../../Images/logo-agile-1.gif.If i remove image then pd report is generated fine. String reportPath = request.getSession().getServletContext().getResource("/reports/jasper").toString().substring(6); File file = new File(reportPath + "BrokerTurnover.jasper"); String jasperFile = file.getPath(); but my LOGO is in image folder.so My jrxml is like that <image> <reportElement x="340" y="4" width="123" height="40"/> <imageExpression class="java.lang.String"><![CDATA["../../Images/logo-agile-1.gif"]]></imageExpression> </image> i m using servlet application protected void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException { ServletOutputStream servletOutputStream = response.getOutputStream(); InputStream reportStream = getServletConfig().getServletContext() .getResourceAsStream("/reports/ParameterReport.jasper"); HashMap parameterMap = new HashMap(); parameterMap.put("paramName", "paramValue"); try { JasperRunManager.runReportToPdfStream(reportStream, servletOutputStream, parameterMap, new JREmptyDataSource()); response.setContentType("application/pdf"); servletOutputStream.flush(); servletOutputStream.close(); } catch (JRException e) { // display stack trace in the browser StringWriter stringWriter = new StringWriter(); PrintWriter printWriter = new PrintWriter(stringWriter); e.printStackTrace(printWriter); response.setContentType("text/plain"); response.getOutputStream().print(stringWriter.toString()); } } plz help me .its very urgent. Thanks

Hi, i have one form and form contains two field i.e search criteria.Suppose user filed only one field and submit button then according to query report will be generated but my question is two filed(label) i have taken static text so another label should not be display.plz help me. thnks

Hi, Suppose i have one form and form contains two field.If user select one Field,then Dont display another label,i m using static text as a label.so According to Query,My report is generated but problem is second search should not be display. Thanks

Hi, I want to generate Report.Is it possible for muliple Query in jasper Report without subReport.

Hi, i want to generate report.My requirement is how to dynamic where clause in jrxml.Actually i have one form and that form is selection criteria of three field.if user select only one then search after that report should be generated.if user select 2 entry then according to search criteria report should be generated. thnks Post Edited by anupp at 07/12/2010 14:04

Hi, I have some problems with the relative path of an image and subreports. I receive this error when I try to execute jasperreport: [java] net.sf.jasperreports.engine.JRException: Byte data not found at location : .logoBancaIMI.jpg net.sf.jasperreports.engine.JRException: Could not load object from location : ./DatVestReport1.jasper Thanks Post Edited by anupp at 06/23/2010 08:02

Hi, I have generated PDF report in destination folder i.e. C Drive.But My Requirement is when click the save button,PDF should be opened. please check the code and where i m missing in this code.I have used jasper view .viewReport its generated but problem is when jasper view part is closed then automatic weblogic server is terminating..Please find the attachement.. Thanks in advance Code: reportDataSource = new JRMapCollectionDataSource(reportdataList); JasperPrint jasperPrint; HttpServletRequest request = (HttpServletRequest)FacesContext.getCurrentInstance().getExternalContext().getRequest(); String reportPath =request.getSession().getServletContext().getResource("/reports").toString().substring(6); // substring cuts off the 'file://' File file = new File(reportPath + "TransferSecretaries_Report.jasper"); String file1 = file.toString(); Random generator = new Random(); int reportId = generator.nextInt(); String dest ="c:/report_"+reportId+".pdf"; String destFileName = "transferReport"+reportId+".pdf"; try { jasperPrint =JasperFillManager.fillReport(file1, new HashMap(),reportDataSource); System.out.println("jasper printing>>>>>>>>>>>>>>>>>"+jasperPrint); response.setContentType("application/pdf"); // OutputStream ouputStream = new FileOutputStream(new File(dest)); OutputStream ouputStream = new FileOutputStream(new File("dest")); JRPdfExporter exporter = new JRPdfExporter(); exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, ouputStream); JasperExportManager.exportReportToPdfStream(jasperPrint, ouputStream); System.out.println("exporter pdf file calling>>>>>>>>>>>>"); exporter.exportReport(); ouputStream.flush(); ouputStream.close(); HttpServletResponse response = (HttpServletResponse)FacesContext.getCurrentInstance().getExternalContext().getResponse(); response.sendRedirect("/reports"+ouputStream); } catch (JRException e) { } catch (FileNotFoundException e) { } catch (IOException e) { } } Post Edited by anupp at 06/12/2010 14:13

Hi All, I have generated PDF report in a destination i.e. C Drive or D Drive.But My requirement is when click the save button PDF Report should be opened.I have used jasperViewer.viewReport but its working but problem is when generated view report and close the report then automatically server is shutdown. plase suggest me.. Thanks Anup Code: Post Edited by anupp at 06/07/2010 05:26 Post Edited by anupp at 06/10/2010 11:12

Hi All, I am using ireport3.6 and jasper jar 3.6.Actually i have generated pdf report in c drive.but my question is when click the save button then pdf should be opened.please response my question. Thanks in advance

HI All, i have generated pdf report but i have given hardcoded in destination C Drive. but destination c Drive is not required. when click the save button then pdf file should be opened.Directly pdf Should be opened. please help me. Thanks in Advance Code: private void generateReport(InjectionAMDataControlImpl certifiaceService) throws JRException, MalformedURLException, IOException { JRDataSource simpleDS=null; JRMapCollectionDataSource subDS1; JRMapCollectionDataSource subDS2 ; List dataMasterList = new ArrayList(); DCBindingContainer dcBc =(DCBindingContainer)ADFUtils.getBindingContainer(); DCIteratorBinding dcIbLoc = dcBc.findIteratorBinding("TransferSecretaryVOIterator"); certificateBreakUpIdHM =(HashMap<String, String>)session.getAttribute("CerificateBreakUpSysId"); // System.out.println("SecurityName***********************************************"+ADFUtils.getBoundAttributeValue("SecurityName")); Integer seqId =0; Map simpleMasterMap = new HashMap(); for (Row rowLoc : dcIbLoc.getAllRowsInRange()) {//to get the qunatity,certificateNo.,referenceNo and partyId from CertifictaeBreakup if (seqId == 0){ seqId =new Integer((rowLoc.getAttribute("SmtBrkupTxfMapSeq") == null ? "0" : ((Number)rowLoc.getAttribute("SmtBrkupTxfMapSeq")).toString())); } rowLoc.setAttribute("BrkCovrLtrTs", "Y"); if (certificateBreakUpIdHM.containsKey((String)rowLoc.getAttribute("BrkId"))) { Map<String, Object> dataMap = new HashMap<String, Object>(); dataMap.put("quantity", new Integer((rowLoc.getAttribute("BrkQty") == null ? "0" : ((Number)rowLoc.getAttribute("BrkQty")).toString()))); dataMap.put("certificateNo",rowLoc.getAttribute("BrkCertiNo")); dataMap.put("partyName",rowLoc.getAttribute("partyName")); dataMap.put("referenceNo",seqId); ViewObject viewObject = certifiaceService.getInjectionQuantityVO(); Row sname = viewObject.getCurrentRow(); dataMap.put("SecurityName",sname.getAttribute("SecurityName")); //dataMap.put("SecurityName",rowLoc.getAttribute("SecurityDesc")); dataMasterList.add(dataMap); } } subDS1 = new JRMapCollectionDataSource(dataMasterList); DCBindingContainer dcBc1 =(DCBindingContainer)ADFUtils.getBindingContainer(); DCIteratorBinding dcIbLoc1 =dcBc1.findIteratorBinding("TransferCertificateVOIterator"); dataMasterList = new ArrayList(); for (Row rowLoc : dcIbLoc1.getAllRowsInRange()) { //to get the qunatity,certificateNo.and partyId from transferCertificateVo if(seqId==((Number)rowLoc.getAttribute("CertBrkupTxfMapSeq")).intValue()) { Map<String, Object> dataMap = new HashMap<String, Object>(); dataMap.put("tquantity",new Integer((rowLoc.getAttribute("CertTxfQty") == null ? "0" : ((Number)rowLoc.getAttribute("CertTxfQty")).toString()))); dataMap.put("partyName",rowLoc.getAttribute("newHolderDesc")); ViewObject viewObject = certifiaceService.getCertificateTypeVO(); Row sname = viewObject.getRow(new Key ( new Object [] {rowLoc.getAttribute("CertCertiTyp") })); dataMap.put("tcertificateNo",sname.getAttribute("LkEngText")); dataMasterList.add(dataMap); } } subDS2 = new JRMapCollectionDataSource(dataMasterList); Row r = dcIbLoc1.getCurrentRow(); CMMAddressVOImpl cmmAddressImpl =(CMMAddressVOImpl)certifiaceService.getCMMAddressVO1(); cmmAddressImpl.setBIND_PATY_ID((String)r.getAttribute("CertTxfSecUid")); cmmAddressImpl.executeQuery(); RowSet rowSet = cmmAddressImpl.getRowSet(); simpleMasterMap = new HashMap(); if(rowSet.hasNext()) { // to fetch the Address of transfer secreatry ID i.e postal address r = rowSet.next(); simpleMasterMap.put("partyName",r.getAttribute("PtyName")); simpleMasterMap.put("address1",r.getAttribute("AddrLine1")); simpleMasterMap.put("address2",r.getAttribute("AddrLine2")); simpleMasterMap.put("address3",r.getAttribute("AddrLine3")); } else { // To be change latter simpleMasterMap.put("partyName",""); simpleMasterMap.put("address1",""); simpleMasterMap.put("address2",""); simpleMasterMap.put("address3",""); } simpleMasterMap.put("DatVestSubDS1", subDS1); simpleMasterMap.put("DatVestSubDS2", subDS2); List simpleMasterList = new ArrayList(); simpleMasterList.add(simpleMasterMap); simpleDS = new JRMapCollectionDataSource(simpleMasterList); JasperPrint jasperPrint; HttpServletRequest request = (HttpServletRequest)FacesContext.getCurrentInstance().getExternalContext().getRequest(); String reportPath =request.getSession().getServletContext().getResource("/reports").toString().substring(6); // substring cuts off the 'file://' File file = new File(reportPath + "TransferSecretaries_Report.jasper"); String file1 = file.toString(); //to be change latter String dest ="c:/transferSecreatary.pdf"; String filePath = file1 + File.separator +dest ; System.out.println("file path is>>>>>>>>>>>>>>>>>."+filePath); jasperPrint =JasperFillManager.fillReport(file1, new HashMap(),simpleDS); //generates PDF JasperExportManager.exportReportToPdfFile(jasperPrint, dest); removeToSession("CerificateBreakUpSysId"); }

Code:Hi All, i want to generate pdf file directly.when click the save button then directly pdf file should be generated.Actually i have generated pdf file through jasper but i have mentioned destination so its not required.My Requirement is after clicking the save button then pdf should be generated. HttpServletRequest request = (HttpServletRequest)FacesContext.getCurrentInstance().getExternalContext().getRequest(); String reportPath = request.getSession().getServletContext().getResource("/reports").toString().substring(6); // substring cuts off the 'file://' File file = new File(reportPath + "TransferSecretaries_Report.jasper"); String file1 = file.toString(); String dest = "c:/transferSecreatary.pdf"; jasperPrint =JasperFillManager.fillReport(file1, new HashMap(),simpleDS); //generates PDF JasperExportManager.exportReportToPdfFile(jasperPrint, dest); }

<dataSourceExpression><![CDATA[new net.sf.jasperreports.engine.JREmptyDataSource()]]></dataSourceExpression>

Hi, i want to genearte sub report in Ireport without datasource/Query exceuting,Actually i m getting some problem. I have passed data thorogh hashMap.so in a Report data is generated and first report data i m getting antother sub report data i m also getting but data is comiming NULL.So where i m getting missing plz reponse me .or reply me. Thanks in Advance Code:package demo.view;import java.io.InputStream;import java.util.HashMap;import java.util.Map;import net.sf.jasperreports.engine.JRDataSource;import net.sf.jasperreports.engine.JREmptyDataSource;import net.sf.jasperreports.engine.JRException;import net.sf.jasperreports.engine.JasperCompileManager;import net.sf.jasperreports.engine.JasperExportManager;import net.sf.jasperreports.engine.JasperPrint;import net.sf.jasperreports.engine.JasperReport;import net.sf.jasperreports.engine.JasperRunManager;import net.sf.jasperreports.engine.data.JRBeanArrayDataSource;import net.sf.jasperreports.engine.data.JRMapArrayDataSource;import net.sf.jasperreports.engine.fill.JRFiller;import net.sf.jasperreports.view.JasperViewer;public class Test3 { public Test3() { super(); } public static void main(String[] args) { String reportSource = "c:/reportApp.jrxml"; String reportDest = "c:/agile12.pdf"; try { JasperReport jasperReport = JasperCompileManager.compileReport(reportSource); JRDataSource dataSource = createReportDataSource(); JasperPrint jasperPrint = JRFiller.fillReport(jasperReport, new HashMap(), dataSource); JasperExportManager.exportReportToPdfFile(jasperPrint, reportDest); JasperViewer.viewReport(jasperPrint); } catch (JRException ex) { ex.printStackTrace(); } } private static JRDataSource createReportDataSource() { JRMapArrayDataSource dataSource; Map[] reportRows = initializeMapArray(); dataSource = new JRMapArrayDataSource(reportRows); return dataSource; } private static Map[] initializeMapArray() { HashMap[] reportRow = new HashMap[5]; HashMap<String, Object> Qty = new HashMap<String, Object>(); HashMap<String, Object> Certi = new HashMap<String, Object>(); HashMap<String, Object> address = new HashMap<String, Object>(); HashMap<String, Object> contact = new HashMap<String, Object>(); HashMap<String, HashMap<String, Object>> address2 = new HashMap<String, HashMap<String, Object>>(); Qty.put("certificateNo", "xyx"); Qty.put("quantity", 101); Certi.put("certificateNo", "HealthIns"); Certi.put("quantity", 1255); address.put("address","patna"); address.put("phone",54488); address2.put("address2", address); contact.put("address","mumbai"); contact.put("phone",7841); reportRow[0] = Qty ; reportRow[1] = Certi; reportRow[2] = address; reportRow[3] = contact; reportRow[4] = address2; return reportRow; }}

Hi All, I m using ADF11g Jdeveloper.I want to integrate jasper report.If any link then please send me .I m getting some error in adf11g Some errror like that .net.sf.jasperreports.engine.JRException: java.io.FileNotFoundException: .TestReport.jrxml. Thanks&regards Anup Post Edited by anupp at 05/19/2010 05:21