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