problem in accessing parameter inside Query

<code style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif;"><span class="kwd" style="border: 0px; vertical-align: baseline; background-color: transparent; color: rgb(0, 0, 139);">select</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> docid_fname_pemid</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">.*,</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> MONTHNAME</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">(</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">b</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">.</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">ServicePeriodDate</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">)</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> </span><span class="kwd" style="border: 0px; vertical-align: baseline; background-color: transparent; color: rgb(0, 0, 139);">as</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> month_name</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">,</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">YEAR</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">(</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">b</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">.</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">ServicePeriodDate</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">)</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> </span><span class="kwd" style="border: 0px; vertical-align: baseline; background-color: transparent; color: rgb(0, 0, 139);">as</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> year_name </span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">,</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> b</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">.</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">NonLTCMaximumSpecialPayment</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">,</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> b</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">.</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">NonLTCEnrolledPatientOutsideUseTotal</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">,</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> b</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">.</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">NonLTCAccessBonus
</span><span class="kwd" style="border: 0px; vertical-align: baseline; background-color: transparent; color: rgb(0, 0, 139);">from</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> </span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">(</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">
</span><span class="kwd" style="border: 0px; vertical-align: baseline; background-color: transparent; color: rgb(0, 0, 139);">select</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> docid_pemid</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">.</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">PEMID</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">,</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> docid_pemid</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">.</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">DoctorID</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">,</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> b</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">.$</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">P!</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">{</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">transparency_check</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">})</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">
</span><span class="kwd" style="border: 0px; vertical-align: baseline; background-color: transparent; color: rgb(0, 0, 139);">from</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> </span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">(</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">
</span><span class="kwd" style="border: 0px; vertical-align: baseline; background-color: transparent; color: rgb(0, 0, 139);">select</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> DoctorID</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">,</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">PEMID </span><span class="kwd" style="border: 0px; vertical-align: baseline; background-color: transparent; color: rgb(0, 0, 139);">from</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> DoctorPEMMap </span><span class="kwd" style="border: 0px; vertical-align: baseline; background-color: transparent; color: rgb(0, 0, 139);">where</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> PEMID </span><span class="kwd" style="border: 0px; vertical-align: baseline; background-color: transparent; color: rgb(0, 0, 139);">in</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> </span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">($</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">P</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">{</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">PEMID_input</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">})</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> </span><span class="kwd" style="border: 0px; vertical-align: baseline; background-color: transparent; color: rgb(0, 0, 139);">and</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> StartDate </span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">>=</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> </span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">$</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">P</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">{</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">StartDate</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">}</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">  </span><span class="kwd" style="border: 0px; vertical-align: baseline; background-color: transparent; color: rgb(0, 0, 139);">and</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> </span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">(</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">EndDate </span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;"><=</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> </span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">$</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">P</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">{</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">EndDate</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">}</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> </span><span class="kwd" style="border: 0px; vertical-align: baseline; background-color: transparent; color: rgb(0, 0, 139);">or</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> EndDate </span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;"><=</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> </span><span class="str" style="border: 0px; vertical-align: baseline; background-color: transparent; color: rgb(128, 0, 0);">'0000-00-00'</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">)</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> </span><span class="kwd" style="border: 0px; vertical-align: baseline; background-color: transparent; color: rgb(0, 0, 139);">group</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> </span><span class="kwd" style="border: 0px; vertical-align: baseline; background-color: transparent; color: rgb(0, 0, 139);">by</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> PEMID </span><span class="kwd" style="border: 0px; vertical-align: baseline; background-color: transparent; color: rgb(0, 0, 139);">order</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> </span><span class="kwd" style="border: 0px; vertical-align: baseline; background-color: transparent; color: rgb(0, 0, 139);">by</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> PEMID
</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">)</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">docid_pemid   </span><span class="kwd" style="border: 0px; vertical-align: baseline; background-color: transparent; color: rgb(0, 0, 139);">left</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> </span><span class="kwd" style="border: 0px; vertical-align: baseline; background-color: transparent; color: rgb(0, 0, 139);">join</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">  Doctors b </span><span class="kwd" style="border: 0px; vertical-align: baseline; background-color: transparent; color: rgb(0, 0, 139);">on</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> docid_pemid</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">.</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">DoctorID</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">=</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">b</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">.</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">DoctorID
</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">)</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> docid_fname_pemid
</span><span class="kwd" style="border: 0px; vertical-align: baseline; background-color: transparent; color: rgb(0, 0, 139);">left</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">  </span><span class="kwd" style="border: 0px; vertical-align: baseline; background-color: transparent; color: rgb(0, 0, 139);">join</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> DoctorPayments b </span><span class="kwd" style="border: 0px; vertical-align: baseline; background-color: transparent; color: rgb(0, 0, 139);">on</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;"> docid_fname_pemid</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">.</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">DoctorID</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">=</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">b</span><span class="pun" style="border: 0px; vertical-align: baseline; background-color: transparent;">.</span><span class="pln" style="border: 0px; vertical-align: baseline; background-color: transparent;">DoctorID</span>

PEMID_input--> string, prompt yes, no</p>
<p style="margin-top: 0px; border: 0px; font-size: 14px; vertical-align: baseline; background-color: rgb(255, 255, 255); clear: both; word-wrap: break-word; font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;">2)<code style="margin: 0px; padding: 1px 5px; border: 0px; vertical-align: baseline; background-color: rgb(238, 238, 238); font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif;">month_year--> .String,prompt yes, no</p>
<p style="margin-top: 0px; border: 0px; font-size: 14px; vertical-align: baseline; background-color: rgb(255, 255, 255); clear: both; word-wrap: break-word; font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;">3)<code style="margin: 0px; padding: 1px 5px; border: 0px; vertical-align: baseline; background-color: rgb(238, 238, 238); font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif;">transparency_input--> String,prompt yes, no</p>
<p style="margin-top: 0px; border: 0px; font-size: 14px; vertical-align: baseline; background-color: rgb(255, 255, 255); clear: both; word-wrap: break-word; font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;">4)<code style="margin: 0px; padding: 1px 5px; border: 0px; vertical-align: baseline; background-color: rgb(238, 238, 238); font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif;">transparency_check -->String,No prompt,<code style="margin: 0px; padding: 1px 5px; border: 0px; vertical-align: baseline; background-color: rgb(238, 238, 238); font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif;">($P{transparency_input}=="yes" ) ? ("FirstName") : ("AliasFirstName")</p>
<p style="margin-top: 0px; border: 0px; font-size: 14px; vertical-align: baseline; background-color: rgb(255, 255, 255); clear: both; word-wrap: break-word; font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;">5)<code style="margin: 0px; padding: 1px 5px; border: 0px; vertical-align: baseline; background-color: rgb(238, 238, 238); font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif;">StartDate -->String,No prompt, <code style="margin: 0px; padding: 1px 5px; border: 0px; vertical-align: baseline; background-color: rgb(238, 238, 238); font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif;">$P{month_year}.split("-")[0]=="April" ? $P{month_year}.split("-")[1].concat("-04-01") : $P{month_year}.split("-")[1].concat("-10-01")</p>
<p style="margin-top: 0px; border: 0px; font-size: 14px; vertical-align: baseline; background-color: rgb(255, 255, 255); clear: both; word-wrap: break-word; font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;">6) <code style="margin: 0px; padding: 1px 5px; border: 0px; vertical-align: baseline; background-color: rgb(238, 238, 238); font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif;">EndDate -->String, No prompt, <code style="margin: 0px; padding: 1px 5px; border: 0px; vertical-align: baseline; background-color: rgb(238, 238, 238); font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif;">$P{month_year}.split("-")[0]=="April" ? $P{month_year}.split("-")[1].concat("-09-30") : $P{month_year}.split("-")[1].concat("-03-31")</p>
<p style="margin-top: 0px; border: 0px; font-size: 14px; vertical-align: baseline; background-color: rgb(255, 255, 255); clear: both; word-wrap: break-word; font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;"><span class="comment-copy" style="border: 0px; font-size: 13px; vertical-align: baseline; background-color: rgb(250, 250, 250); color: rgb(68, 68, 68); line-height: 17px;">when retrieving fields automatically,gives "Error:null" </span></p>
<p style="margin-top: 0px; border: 0px; font-size: 14px; vertical-align: baseline; background-color: rgb(255, 255, 255); clear: both; word-wrap: break-word; font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;"><span class="comment-copy" style="border: 0px; font-size: 13px; vertical-align: baseline; background-color: rgb(250, 250, 250); color: rgb(68, 68, 68); line-height: 17px;">I ignore that & proceeds further to run.</span></p>
<p style="margin-top: 0px; border: 0px; font-size: 14px; vertical-align: baseline; background-color: rgb(255, 255, 255); clear: both; word-wrap: break-word; font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;"><span class="comment-copy" style="border: 0px; font-size: 13px; vertical-align: baseline; background-color: rgb(250, 250, 250); color: rgb(68, 68, 68); line-height: 17px;">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... </span></p>
<p style="margin-top: 0px; border: 0px; font-size: 14px; vertical-align: baseline; background-color: rgb(255, 255, 255); clear: both; word-wrap: break-word; font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;"><span class="comment-copy" style="border: 0px; font-size: 13px; vertical-align: baseline; background-color: rgb(250, 250, 250); color: rgb(68, 68, 68); line-height: 17px;">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)</span><span style="color: rgb(68, 68, 68); font-size: 13px; line-height: 17px; background-color: rgb(250, 250, 250);"> </span></p>
<div>  </div>
<pre class="lang-sql prettyprint prettyprinted" style="margin-top: 0px; margin-bottom: 10px; padding: 5px; border: 0px; font-size: 14px; vertical-align: baseline; background-color: rgb(238, 238, 238); font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; overflow: auto; width: auto; max-height: 600px;">
<span style="background-color: rgb(255, 255, 255); font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;">I think query not getting </span><code style="margin: 0px; padding: 1px 5px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif;">'b.FirstName'<span style="background-color: rgb(255, 255, 255); font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;">. So I used concat function as</span><code style="margin: 0px; padding: 1px 5px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif;">concat('b.',$P{transparency_check})<span style="background-color: rgb(255, 255, 255); font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;">, but it not works.</span></pre>
<p style="margin-top: 0px; border: 0px; font-size: 14px; vertical-align: baseline; background-color: rgb(255, 255, 255); clear: both; word-wrap: break-word; font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;"> </p>
<p style="margin-top: 0px; border: 0px; font-size: 14px; vertical-align: baseline; background-color: rgb(255, 255, 255); clear: both; word-wrap: break-word; font-family: Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;">How should I go ?</p>
<p> </p>