abhinashdora

Thanks hozawa, i read the documentation and tried this code $P!{Query} the default value of the parameter is SELECT date_format(a.application_date,'%d-%m-%Y'),concat(ifnull(a.present_address,""),', ')," + "concat(ifnull(a.present_village,""),', '),concat(ifnull(a.present_post,""),', ')," + "concat(ifnull(a.present_ps,""),', '),concat(ifnull(a.present_dist,""),', ')," + "concat(ifnull(a.present_pin,""),', '),concat(ifnull(a.present_landline_no,"none"),', ')," + "concat(ifnull(a.present_mobile,"none"),''),concat(ifnull(a.permanent_address,""),', ')," + "concat(ifnull(a.permanent_village,""),', '),concat(ifnull(a.permanent_post,""),', ')," + "concat(ifnull(a.permanent_ps,""),', '),concat(ifnull(a.permanent_dist,""),', ')," + "concat(ifnull(a.permanent_pin,""),', '),concat(ifnull(a.permanent_landline_no,"none"),', ')," + "concat(ifnull(a.permanent_mobile,"none"),''),b.`school_name`,b.`school_address_1`,b.`school_address_2`," + "b.`school_address_3`,a.`admission_no`,a.`academic_year`,a.`form_no`,a.`admission_class`,a.`student_name`," + "a.`dob_day`,a.`dob_day`,a.`dob_month`,a.`dob_year`,a.`dob_words`,a.`age`,a.`nationality`,a.`religion`," + "a.`mother_tongue`,a.`gender`,a.`category_abbr`,a.`prev_school`,a.`prev_result`,a.`prev_rank`," + "a.`prev_mark_pc`,a.`blood_group`,a.`mother_name`,a.`father_name`,a.`guardian_name` " + "FROM `application_form` a,`config` b, class c " + "WHERE b.config_id = 1 " + "GROUP BY admission_class,form_no " + "ORDER BY admission_class ASC and I want to send SELECT date_format(a.application_date,'%d-%m-%Y'),concat(ifnull(a.present_address,""),', ')," + "concat(ifnull(a.present_village,""),', '),concat(ifnull(a.present_post,""),', ')," + "concat(ifnull(a.present_ps,""),', '),concat(ifnull(a.present_dist,""),', ')," + "concat(ifnull(a.present_pin,""),', '),concat(ifnull(a.present_landline_no,"none"),', ')," + "concat(ifnull(a.present_mobile,"none"),''),concat(ifnull(a.permanent_address,""),', ')," + "concat(ifnull(a.permanent_village,""),', '),concat(ifnull(a.permanent_post,""),', ')," + "concat(ifnull(a.permanent_ps,""),', '),concat(ifnull(a.permanent_dist,""),', ')," + "concat(ifnull(a.permanent_pin,""),', '),concat(ifnull(a.permanent_landline_no,"none"),', ')," + "concat(ifnull(a.permanent_mobile,"none"),''),b.`school_name`,b.`school_address_1`,b.`school_address_2`," + "b.`school_address_3`,a.`admission_no`,a.`academic_year`,a.`form_no`,a.`admission_class`,a.`student_name`," + "a.`dob_day`,a.`dob_day`,a.`dob_month`,a.`dob_year`,a.`dob_words`,a.`age`,a.`nationality`,a.`religion`," + "a.`mother_tongue`,a.`gender`,a.`category_abbr`,a.`prev_school`,a.`prev_result`,a.`prev_rank`," + "a.`prev_mark_pc`,a.`blood_group`,a.`mother_name`,a.`father_name`,a.`guardian_name` " + "FROM `application_form` a,`config` b, class c " + "WHERE b.config_id = 1 and c.class_id=6 and a.admission_class=c.class_desc " + "GROUP BY admission_class,form_no " + "ORDER BY admission_class ASC

Hi Guys, I need to pass a sql query in a parameter in ireport, i have tried some but failed to do that. Down here is my parameter and query <parameter name="sql" class="java.lang.String" isForPrompting="false"/><queryString><![CDATA[sELECT date_format(a.application_date,'%d-%m-%Y'), concat(ifnull(a.present_address,""),', '), concat(ifnull(a.present_village,""),', '), concat(ifnull(a.present_post,""),', '), concat(ifnull(a.present_ps,""),', '), concat(ifnull(a.present_dist,""),', '), concat(ifnull(a.present_pin,""),', '), concat(ifnull(a.present_landline_no,"none"),', '), concat(ifnull(a.present_mobile,"none"),''), concat(ifnull(a.permanent_address,""),', '), concat(ifnull(a.permanent_village,""),', '), concat(ifnull(a.permanent_post,""),', '), concat(ifnull(a.permanent_ps,""),', '), concat(ifnull(a.permanent_dist,""),', '), concat(ifnull(a.permanent_pin,""),', '), concat(ifnull(a.permanent_landline_no,"none"),', '), concat(ifnull(a.permanent_mobile,"none"),''), b.`school_name`, b.`school_address_1`, b.`school_address_2`, b.`school_address_3`, a.`admission_no`, a.`academic_year`, a.`form_no`, a.`admission_class`, a.`student_name`, a.`dob_day`, a.`dob_day`, a.`dob_month`, a.`dob_year`, a.`dob_words`, a.`age`, a.`nationality`, a.`religion`, a.`mother_tongue`, a.`gender`, a.`category_abbr`, a.`prev_school`, a.`prev_result`, a.`prev_rank`, a.`prev_mark_pc`, a.`blood_group`, a.`mother_name`, a.`father_name`, a.`guardian_name`FROM `application_form` a, `config` b, class cWHERE b.config_id = 1 $P!{sql}GROUP BY admission_class, form_noORDER BY admission_class ASC]]></queryString> inside parameter i want to passand c.class_id=6 and a.admission_class=c.class_desc Can somebody tell me how to do that in a proper way.

Thank you hozawa for the help. You are right about the " " added to the variable.

Thank you joehodges for the help. I remove the " " added to the variable and it's works fine.

Hi there, I am working on ireport 5.0.1. I have tried the currency format for my report but somehow it is not giving me the result. This is my code for the Textfield <textField pattern="###0.00" isBlankWhenNull="true"><reportElement uuid="133b0863-16ee-425e-b230-4fff9ef5ffc6" x="432" y="1" width="112" height="14"/><textElement textAlignment="Right"/><textFieldExpression><![CDATA[$V{netAmt}+" "]]></textFieldExpression></textField> Can somebody help me through it?

Thanks a lot hozawa, It just works fine.

Hi, I want to make part of the text underline inside a Text Field using <u>...</u> but can't get the desire result. This is my Field Expression <reportElement uuid="f878fb7f-c198-4c49-8310-f49d38c4119d" x="0" y="24" width="534" height="88"/><textElement markup="styled"/><textFieldExpression><![CDATA[" I Shri "<u>+$F{father_name}+</u>" & Smt. "+$F{mother_name}+" Parents of "+$F{student_name} "]]></textFieldExpression></textField>Can anybody help me through it?