Print WhenExpression??

[kogantivijay]

HI all,

 

I have a problem using Print When Expression..Let me brief You the problem..

I have arranged the TextFields and Static Text like this.

[$F{Hello}] [ Static Text Here "In the "] [$F{World}]

Now My Requirement is that i have to Print that whole Line including Static Text only if [$F{Hello}] returns some value from the DB.If it has no value it should not print the whole line including the Static Text also..How can i do that..

 

Thanks,

vijay kumar k.

[redwine]

vijay

 

check out the attached file and look at the properties. better for you to see it than for me to explain it. :)

 

also check out this recent question posted by vanhuet. it is similar to what you need: http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&id=25350&catid=9

 

i hope these will help.

 

Edwin

[file name=print_when_expr.jrxml size=6575]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/print_when_expr.jrxml[/file]

Post edited by: edwin, at: 2007/05/16 20:54

[kogantivijay]

Hi Thanks for that ..but i have found an alternative too which i thought to share for rest :

I have modified my Query (MYSql) and i was keeping that Temporary Rows as my Field and Setting the Field property to print when it is Not NUll and Blank when Null..So if my DataSouce has empty value it will never get print this way..

 

select concat(B.PG_DEGREE ," in ",B.PG_SPECIALISATION," from ",B.PG_UNIVERSITY_NAME," in ",B.PG_YEAROFGRAD) AS pg

,concat(B.UG_DEGREE ," in ",B.UG_SPECIALISATION," from ",B.UG_UNIVERSITY_NAME," in ",B.UG_YEAROFGRAD) AS UG

from educational_qualification B where EMP_ID ='123'

 

Hope this will help some one out there..

 

thanks,

vijay kumar