[how to calculate total sum % on footer ireport]

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

[how to calculate Totalsum of percentage in ireport]

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

[Byte data not found at location : ../../Images/log]

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

[how to take parameter label(page header) ireport]

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

[how to dynamic label in ireport]

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

 

[Is it possible for muliple Query in jasper Report]

Hi,

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

[how to dynamic where clause in jrxml.]

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

[How to set relative/absolute path in subreport]

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

[when click the save button,PDF should be opened]

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

[when click the save button pdf should be opened]

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

[when click save button pdf should be generated]

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

 

[when click save button pdf should be generated]

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");    }

[i want to generate pdf file direcly in jasper repo]

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);

   

    }

[i want to generate subreport in Ireport3.6]

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

[i want to generate subreport in Ireport3.6]

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;    }}

[how to integrate jasper report in adf11g]

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