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

Popular posts from this blog

java - UnknownEntityTypeException: Unable to locate persister (Hibernate 5.0) -

python - ValueError: empty vocabulary; perhaps the documents only contain stop words -

ubuntu - collect2: fatal error: ld terminated with signal 9 [Killed] -