abhinashdora
-
Posts
7 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Posts posted by abhinashdora
-
-
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[sELECTdate_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 BYadmission_class,form_noORDER BYadmission_class ASC]]></queryString>inside parameter i want to passand c.class_id=6 and a.admission_class=c.class_descCan 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?
Sql in Parameter
in Products
Posted
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