problem in accessing parameter inside Query

[sagarnikam123]

 

I have below query in Report query wizard of iReport

select docid_fname_pemid.*, MONTHNAME(b.ServicePeriodDate) as month_name,YEAR(b.ServicePeriodDate) as year_name , b.NonLTCMaximumSpecialPayment, b.NonLTCEnrolledPatientOutsideUseTotal, b.NonLTCAccessBonusfrom (select docid_pemid.PEMID, docid_pemid.DoctorID, b.$P!{transparency_check})from (select DoctorID,PEMID from DoctorPEMMap where PEMID in ($P{PEMID_input}) and StartDate >= $P{StartDate}  and (EndDate <= $P{EndDate} or EndDate <= '0000-00-00') group by PEMID order by PEMID)docid_pemid   left join  Doctors b on docid_pemid.DoctorID=b.DoctorID) docid_fname_pemidleft  join DoctorPayments b on docid_fname_pemid.DoctorID=b.DoctorID[/code]

& parameters,as in order (Parameter class, Prompt Yes/NO, Default value Expression)

1)PEMID_input--> string, prompt yes, no

2)month_year--> .String,prompt yes, no

3)transparency_input--> String,prompt yes, no

4)transparency_check -->String,No prompt,($P{transparency_input}=="yes" ) ? ("FirstName") : ("AliasFirstName")

5)StartDate -->String,No prompt, $P{month_year}.split("-")[0]=="April" ? $P{month_year}.split("-")[1].concat("-04-01") : $P{month_year}.split("-")[1].concat("-10-01")

6) EndDate -->String, No prompt, $P{month_year}.split("-")[0]=="April" ? $P{month_year}.split("-")[1].concat("-09-30") : $P{month_year}.split("-")[1].concat("-03-31")

when retrieving fields automatically,gives "Error:null"

I ignore that & proceeds further to run.

It runs when given transparency_input="yes",but when I give transparency_input="no",error occurs->Error filling print... Unknown column name : FirstName  Setting up the file resolver...

I want dynamic value of transparency_check to be either "FristName" or "AliasFirstName",which depends upon transparency_input("yes"/"no") parameter (look in question in parameter section) 

  

I think query not getting 'b.FirstName'. So I used concat function asconcat('b.',$P{transparency_check}), but it not works.[/code]

 

How should I go ?