Jump to content
We've recently updated our Privacy Statement, available here ×

dheerajsea123

Members
  • Posts

    23
  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Posts posted by dheerajsea123

  1. Hi,

    I have a main report which has one query that will retrun some fields value and i hav a one subreport where i want to pass this value as a parameter,  is it possible how to do this, than please tell me any one has any idea?

    Thanks

     

  2. Hi,

    I am new user with ireport, i have succcess fully cretaed my doc file, but i face one problem, i am getting data in table format but i have to select all column data at a time like doc file, so how to do this.

    Please any one help me out.

    thanks.

     

  3. thanks to reply me,

    that's i already tried but as i try to get these parameter value on my subreport i am getting null value, i don't understand where is the actully problem. Now i am explaning everything to you, what actully i want.

    exec pg_sp_brokingMerchantDeatils '14:00', this is my first procedure which is calling by main report, and this procedure is returning some fields like (SubMerchantid, payment_seg_code), and now i have a another report which is the subreport of my main report and in this i call another procedure which is as follows.
    exec pg_sp_brokingFundTransafer $P{PStrSchemeCodeFlag},$P{PstrSchemeTypeFlag},$P{PstrPlanCodeFlag},$P{PstrCSFPos},$P{PstrCSEPos},$P{PstrSCSep},$P{PstrSCTFPos},$P{PstrSCTEPos},$P{PstrPCFPos},$P{PstrPCEPos},$P{PstrStartTime},$P{PstrEndTime},$P{PstrMerID},$P{PstrFromDate},$P{PstrToDate}.

    Now i want pass these all parameter in to subreport from main report automatically, as my main report procedure call.



    I am sending my both file to you.

    1. main report:- FundTransferMaster_rpt.jrxml

    2. subreport:- fundtransfer_rpt.jrxml.

    pls find the attachment.

     



    Post Edited by dheerajsea123 at 01/13/2010 05:03
  4. Hi,

    I am new user for ireport tool, i hav a requirement to pass main report field result, as a parameter in to subreport.

    i am calling onew procedure from main report which is giving some field resule and this field resule i want to pass in subreport procedure as a parameter, so if any one have any idea please le me know.

    thanks.

     

  5. Dear All,

    I am new for use ireport tool, i am trying to pass main report variable value, in to my subreport as a parameter, is there any way to pass it, pls suggest me.

    I m waiting for ur reply, this is very urgent for me.

    thanks in advance.

     

     

     



    Post Edited by dheerajsea123 at 01/11/2010 07:11
  6. hi,

    i have one report and i want to pass hashmap asa parameter in to my report but i don't understand the way how to pass it as we pass string parameter like $p{str}.

    same way i want to pass hashmap:-

    i am showing the palce in bold letter where i passmy hashmap in to this query.

    SELECT slc_salstructdet.PAYTYPEYN,mas_salaryhead.PRINTNAME,mas_salaryhead.SALHEADROWID,

    IF(mas_salaryhead.SALHEADROWID=1,slc_salarycalc_e.ECOMP01,
        IF (mas_salaryhead.SALHEADROWID=2,slc_salarycalc_e.ECOMP02,
             IF (mas_salaryhead.SALHEADROWID=3,slc_salarycalc_e.ECOMP03,
                IF (mas_salaryhead.SALHEADROWID=4,slc_salarycalc_e.ECOMP04,
                    IF (mas_salaryhead.SALHEADROWID=5,slc_salarycalc_e.ECOMP05,
                        IF (mas_salaryhead.SALHEADROWID=6,slc_salarycalc_e.ECOMP06,
    IF (mas_salaryhead.SALHEADROWID=7,slc_salarycalc_e.ECOMP07,
    IF (mas_salaryhead.SALHEADROWID=8,slc_salarycalc_e.ECOMP08,
    IF (mas_salaryhead.SALHEADROWID=9,slc_salarycalc_e.ECOMP09,
    IF (mas_salaryhead.SALHEADROWID=10,slc_salarycalc_e.ECOMP10,
    IF (mas_salaryhead.SALHEADROWID=11,slc_salarycalc_e.ECOMP11,
    IF (mas_salaryhead.SALHEADROWID=12,slc_salarycalc_e.ECOMP12,
    IF (mas_salaryhead.SALHEADROWID=13,slc_salarycalc_e.ECOMP13,
    IF (mas_salaryhead.SALHEADROWID=14,slc_salarycalc_e.ECOMP14,
    IF (mas_salaryhead.SALHEADROWID=15,slc_salarycalc_e.ECOMP15,
    IF (mas_salaryhead.SALHEADROWID=16,slc_salarycalc_e.ECOMP16,
    IF (mas_salaryhead.SALHEADROWID=17,slc_salarycalc_e.ECOMP17,
    IF (mas_salaryhead.SALHEADROWID=18,slc_salarycalc_e.ECOMP18,
    IF (mas_salaryhead.SALHEADROWID=19,slc_salarycalc_e.ECOMP19,
    IF (mas_salaryhead.SALHEADROWID=20,slc_salarycalc_e.ECOMP20,
    IF (mas_salaryhead.SALHEADROWID=21,slc_salarycalc_e.ECOMP21,
    IF (mas_salaryhead.SALHEADROWID=22,slc_salarycalc_e.ECOMP22,
    IF (mas_salaryhead.SALHEADROWID=23,slc_salarycalc_e.ECOMP23,
    IF (mas_salaryhead.SALHEADROWID=24,slc_salarycalc_e.ECOMP24,
    IF (mas_salaryhead.SALHEADROWID=25,slc_salarycalc_e.ECOMP25,
    IF (mas_salaryhead.SALHEADROWID=26,slc_salarycalc_e.ECOMP26,
    IF (mas_salaryhead.SALHEADROWID=27,slc_salarycalc_e.ECOMP27,
    IF (mas_salaryhead.SALHEADROWID=28,slc_salarycalc_e.ECOMP28,
    IF (mas_salaryhead.SALHEADROWID=29,slc_salarycalc_e.ECOMP29,
    IF (mas_salaryhead.SALHEADROWID=30,slc_salarycalc_e.ECOMP30,slc_salarycalc_e.BASIC
    )))))))))))))))))))))))))))))) as AMOUNT

    FROM slc_salstructdet,mas_salaryhead,slc_salarycalc_e,mas_employee,mas_employeedet
    where
    slc_salstructdet.STRUCTID=$P{empMap}  //This is my hashmap

    This is the place where i use hash map.

     


    AND
    slc_salstructdet.PAYTYPEYN=mas_salaryhead.PAYTYPEYN
    AND
    slc_salstructdet.SALHEADROWID=mas_salaryhead.SALHEADROWID
    AND
    slc_salstructdet.SALHEADROWID NOT IN ('100','101')
    AND
    mas_salaryhead.PAYTYPEYN=0
    AND
    mas_employee.EMPID=mas_employeedet.EMPID
    AND
    slc_salarycalc_e.EMPID=mas_employeedet.EMPID
    AND
    slc_salarycalc_e.EMPDETID=mas_employeedet.EMPDETID
    AND
    slc_salarycalc_e.MONTHYEAR=$P{monthyear}
    AND
    mas_employee.EMPID=$P{em}
     

     

    i have also two subreport in which i want pass this hashmap value also. can u suggest me the way..

    thanks in advance..

    pls reply me it's imp to me...

    bye...

     

     

     

     

     

     

  7. hi,

    I used iReport tool, i have one problem i.e. actully i have a one report of salary slip and in their two subreport exist, when i run my main report, so some times my both subreport data is merge, can some one have nay idea how to resolve this merging problem, pls sugeest me.

    I am sending my three report with attachment pls check it and replied me.

    thanks

    bye.

  8. hi everyone,

    I have a one problem how to pass comma seprated value with string parameter, actully i have one report, there is one sql query with IN clause so i have to pass one parameter as a list of values with comma separted dynamically.

    when i pass this value as a static like (1,2) it works, the same thing i want to do dynamically. so pls suggest me how to achieve this thing.I am sending my jasper report to u... there is one leaveid parameter and also employeeid, these both wants to contain comma separted value as i discussed above.

     

    thanks to u in advance.

    pls help me out any one, it's really important to me.

    waiting for ur reply..



    Post Edited by Dheeraj Gupta at 11/25/08 12:24
  9. Thanks for reply,

    ya, i have checked it if i open that file in windows opearting system, it opens correctly and properly, i am sending my java code to you with attachment of java fiel so pls guide me properly where i require changes.

    thanks.

    below side define my java code.

    package WIL.Operations.Script.Utilities.JapserReport.Reports.Accounts.ClientBilling.BillRecent;

    ////////PREDEFINED PACKAGE\\\\\\
    import java.util.*;
    import java.sql.*;
    import java.awt.event.*;
    import net.sf.jasperreports.view.JasperViewer;
    import net.sf.jasperreports.engine.xml.JRXmlLoader;
    import net.sf.jasperreports.engine.xml.*;
    import net.sf.jasperreports.engine.JasperCompileManager;
    import net.sf.jasperreports.engine.JasperFillManager;
    import net.sf.jasperreports.engine.JasperPrint;
    import net.sf.jasperreports.engine.design.JasperDesign;
    import net.sf.jasperreports.engine.JasperReport;
    import net.sf.jasperreports.engine.export.*;
    import net.sf.jasperreports.engine.export.JExcelApiExporter;
    import net.sf.jasperreports.engine.design.*;
    import net.sf.jasperreports.engine.*;
    import net.sf.jasperreports.engine.util.*;
    import net.sf.jasperreports.engine.design.JRAbstractClassCompiler;
    import net.sf.jasperreports.engine.design.JRAbstractCompiler;
    import net.sf.jasperreports.engine.design.JRDefaultCompiler;
    import net.sf.jasperreports.engine.JasperCompileManager;
    import net.sf.jasperreports.engine.design.JRClassCompiler.*;
    import net.sf.jasperreports.engine.design.JRCompiler.*;
    import net.sf.jasperreports.engine.design.JRMultiClassCompiler.*;
    import net.sf.jasperreports.engine.JasperManager;
    import net.sf.jasperreports.view.*;
    import org.apache.commons.collections.*;
    import org.apache.commons.digester.*;
    import org.apache.commons.beanutils.*;
    import java.lang.*;
    import com.lowagie.text.*;
    import java.io.*;
    import java.io.File;
    import java.io.FileOutputStream;
    import java.io.IOException;
    import java.io.OutputStream;
    import java.io.ByteArrayOutputStream;
    import javax.servlet.http.*;
    import javax.servlet.*;
    import java.text.*;
    import java.util.Date;
    ///////USER DEFINED PACKAGE\\\\\
    import WIL.DBConn.ConnectionProvider;
    import WIL.GenericClasses.propertyreader.PropertyFileReader;



    public class BILLRECENT extends HttpServlet
    {
      Connection con=null;
      ConnectionProvider provider;
      String str_WILInvoiceNo;
      String str_dollar,imgPath="";
      Double db;
      String subFileRpt,subFPerson,subBillPerson;
      String fileName,fName;
      JasperDesign jasperDesign;
      JasperReport jasperReport;

      public void doGet(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException
      {
        doPost(request,response);
      }
      public void doPost(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException
      {
        try
        {    
            
            /////////// Flushing cache & set document content type \\\\\\\\
              response.setHeader("Cache-Control", "no-cache");
              response.setContentType("text/html");
              
            //////////DATABASE CONNECTIVITY\\\\\\
            provider=new ConnectionProvider();
              con=provider.getConnection();
            PropertyFileReader reader=new PropertyFileReader();
            
            ///////// REQUEST FOR SESSION \\\\\\\
            HttpSession session=request.getSession();
            
            ////////// REQUESTED PARAMETER FROM BILLRECENT FORM \\\\\\\    
            str_WILInvoiceNo    =(String)session.getAttribute("Invoice_No");
            //str_dollar          =(Double)session.getAttribute("dollar");
            
            fName                =request.getParameter("fName");
            fileName            =request.getParameter("filePath");
            subFileRpt            =request.getParameter("subFilePath");        
            subFPerson            =request.getParameter("FPerson");    
            subBillPerson        =request.getParameter("BillPerson");    
            str_dollar             =request.getParameter("dollar");
            db=Double.parseDouble(str_dollar);
            /////////// GETTING CONTEXT PATH FROM DD \\\\\\\\\
            File file=new File("");
            String sep=file.separator;
                    
            String path=reader.readProperty("JRXML_Property","jrxmlproperty.properties","iReportPath",getServletContext(),"common");
            
            //System.out.println(".jrxml File Path Before Using Replcae function ::"+fileName+"n");
            fileName=fileName.replace("?",sep);
            subFileRpt=subFileRpt.replace("?",sep);
            subFPerson=subFPerson.replace("?",sep);
            subBillPerson=subBillPerson.replace("?",sep);
            //System.out.println(".jrxml File Path After Using Replcae function ::"+fileName+"n");
            
            fileName=getServletContext().getRealPath(path).concat(fileName);
            subFileRpt=getServletContext().getRealPath(path).concat(subFileRpt);
            subFPerson=getServletContext().getRealPath(path).concat(subFPerson);
            subBillPerson=getServletContext().getRealPath(path).concat(subBillPerson);
            
            imgPath=reader.readProperty("JRXML_Property","jrxmlproperty.properties","imagePath",getServletContext(),"common");
            imgPath=getServletContext().getRealPath(imgPath).concat(sep+"LoGo_Company.jpg");
            
            //String path=getServletContext().getInitParameter("iReportPath");
          
            //fileName        =path+fileName;
            //subFileRpt        =path+subFileRpt;
            //subFPerson        =path+subFPerson;
           // subBillPerson    =path+subBillPerson;
            
            
            //////////// CODE IS USED FOR DUBURGING PURPOSE \\\\\\\\\
            System.out.println ("/////////////////////////////////////////////////////////////////");    
            System.out.println("Invoice No::"+str_WILInvoiceNo+"n");
            System.out.println("dollar::"+str_dollar+"n");
            System.out.println(".jrxml File Path ::"+fileName+"n");
            System.out.println("SubReport File Path:"+subFileRpt+"n");
            System.out.println("subFPerson File Path:"+subFPerson+"n");
            System.out.println("subBillPerson File Path:"+subBillPerson+"n");        
            System.out.println("Image File Path:"+imgPath+"n");        
            System.out.println ("/////////////////////////////////////////////////////////////////");
        
            //////////// PUTTING PARAMETER IN HASH MAP SAME AS USED IN JRXML FILES \\\\\\\
            HashMap parameters = new HashMap();
            parameters.put("InvoiceNo",str_WILInvoiceNo);
            parameters.put("DOLLAR",db);
            //System.out.println("***************************dollar*************************::"+db+"n");
            parameters.put("SUBREPORT_DIR",subFileRpt);
            parameters.put("SUBREPORT_DIR_FPerson",subFPerson);
            parameters.put("SUBREPORT_DIR_BillPerson",subBillPerson);
            parameters.put("imgPath",imgPath);
            
            ////////// LOADING & COMPILING OUR SPECIFIED JRXML FILE \\\\\
            jasperDesign=JRXmlLoader.load(fileName);
            jasperReport=JasperCompileManager.compileReport(jasperDesign);
            

            JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport,parameters,con);
            
            /* This Code Works  For Open File In .DOC or RTF Format */        
            
            JRRtfExporter exporter = new JRRtfExporter();
            response.setContentType("application/rtf");
            response.setHeader("Content-Disposition", "inline; filename=""+str_WILInvoiceNo+".rtf"");
            OutputStream outputStream = response.getOutputStream();
            exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
            exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, outputStream);
            exporter.exportReport();
            outputStream.flush();
            outputStream.close();
            
       
       }
       catch(JRException jrex)
       {
              jrex.printStackTrace();
       }
       catch (Exception j)
       {
            System.out.println("WILINVOICE_BILLRECENT_________Error:"+j.getMessage());
       }
       finally
       {
            if(con!=null){
                   try
                {
                      con.close();
                      con=null;
                      provider.exitCon();
                      provider=null;
                      fName="";
                      fileName="";
                      subFileRpt="";
                      subFPerson="";
                      subBillPerson="";
                      
                }
                catch(Exception er)
                {
                      System.out.println("Connection Error in WILINVOICE_BILLRECENT_Error:"+er);
                }
            }
       }//CLOSING FIMNALLY
       
      }//CLOSING doPost METHOD
     
    }// CLOSING WILINVOICE_BILLRECENT CLASS
     

     

  10. Hi Every one,

    Actully i have one java file through which i generated jasper report in rtf format on windows operating system it is worked perfectly, but when i genarate this jasper report in linux through same java class, file is open, but there is no content show, but the size of file is same as in window file size, so suggest me where is the problem and how can i resolve this problem..

    Any Body Help me...

    bye.

  11. Thanks for support.

    But this is not my problem.

    Actully i have one java file through which i generated jasper report in rtf format in windows system so that is worked perfectly, but when i genarate jasper report in linux through this class, file is open but there is no content show, but the size of file is same as in window file size, so suggest me where is the problem and how can i solve this problem..

     

    Any Body Helpme...

     

    bye.

  12. Hi Everyone,

    I am quite new for jasper report, i have one report in rtf format when i use this in windows operating system it shows nicely,

    but when i generate this file through java in ubunto linux system, it doesn't show any thing in that but when i see the property of that file ,it shows complete size of data...

    so can any one have nay idea related to this problem pls suggest what i will do for that problem...

     

    thaks in advance.

    bye...

     

     

×
×
  • Create New...