How can we use iReport parameter in sql query column -
in ireport i'm using parameter in sql query, parameter field not showing in data set. have fee structure table 12 months columns amount, i'm trying desire month passing parameter column, parameter column not showing in data field. here query, i'm passing feestructure.$p!{months}
parameter column.
select studentinformation.id, classs.class, parents.parents, feecatagory.feecatagory, feestructure.$p!{months} studentinformation inner join classs on studentinformation.[c/class] = classs.id inner join parents on studentinformation.parentid = parents.id inner join feestructure on classs.id = feestructure.classid , parents.id = feestructure.parentid inner join feecatagory on feestructure.catagoryid = feecatagory.id class = $p{classid} , parents = $p{parent} , studentinformation.id = $p{studentid} order feecatagory
plz check this.
$p!{months}
parameter give month name default value
and use aliasing
feestructure.$p!{months} month
instead of
feestructure.$p!{months}
Comments
Post a Comment