dheerajsea123

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

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.

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

Hi friend, do you have any idea, how to pass one report field value result in to another subreport as a parameter. if u know reply me on dheeraj.gupta@techprocess.co.in thanks.

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.

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

hi, thanks to ur reply, but can u provide some sample code how to pass data source for individual subreport. bye..

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...

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.

hi, ya thanks to give the solution of that, i have solved my problem by ur code. thanks. bye.

hi, ya thanks to give the solution of that, i have solved my problem by ur code. thanks. bye.

hi EveryOne, I have a one query i.e., i want to pass parameter in IN clause of sql statement in jasper report so pls help me out. how to do this. Any one replied me, it's urgent for me. waiting for ur reply. thanks

hi EveryOne, I have a one query i.e., i want to pass parameter in IN clause of sql statement in jasper report so pls help me out. how to do this. Any one replied me, it's urgent for me. waiting for ur reply. thanks

hi everyone, i have put my servlet code here so any one have same problem he can refer this.

hi every one, I am quite new to use ireport, i have found, generate ireport through xml datasource but i am not able to generate same report through by java servlet can anybody help me out, if u have any sample code or suggesstion how to do this.. pls help me out. waiting for ur reply... thanks

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

thanks for support, Sorry i was not there that's why i am not replying you... still i faced same problem and you were asked, what RTF Viewer i am using, so I used ooWriter viewer for RTF format in my ubuntoo linux system.. pls help me out. waiting for ur reply.

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

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.

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.

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...

i have make rtf format repot in windows irreort and it will open in window os but when i will check in linux os it will not display content of file.

Hi, This is dheeraj, I am new for ireport actually i made a two subreport with one master report, and i want to pass may subreport variable value to master report, how can i do this, please give me ur suggession. thanks