how to pass hashmap in report on the fly.

[dheerajsea123]

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

 

 

 

 

 

 

[tarunsapra]

Use DataSOurces for individual Subreports , put the HashMap in the List and the run time Match the List with the dataSource of the Correspondin' Subreport.

[dheerajsea123]

hi,

thanks to ur reply,

but can u provide some sample code how to pass data source for individual subreport.

 

bye..