sreyu_2k Posted February 9, 2011 Share Posted February 9, 2011 I have a field called del_flg in my DB.If the field value is 'N', I want 'User Created' to be displayed. else 'User Deleted' to be displayed in the report.Plz tell me hw to achieve this in iReport.Urgent!Thanks! Link to comment Share on other sites More sharing options...
kburns Posted February 9, 2011 Share Posted February 9, 2011 sreyu_2kWrote: I have a field called del_flg in my DB. If the field value is 'N', I want 'User Created' to be displayed. else 'User Deleted' to be displayed in the report. Plz tell me hw to achieve this in iReport.Urgent! Thanks! I think it would be something like this: ($F{del_flg} == "N") ? "User Created" : "User Deleted") Link to comment Share on other sites More sharing options...
anaghaphadke Posted February 10, 2011 Share Posted February 10, 2011 Hello,You can write this way:Define field name as 'Del Flg',case (Fieldname with table) when 'N' then 'User Created' eles 'User Deleted' end as 'Del Flg Text'Please try thisThanks & Regards, -Anagha Link to comment Share on other sites More sharing options...
sreyu_2k Posted February 10, 2011 Author Share Posted February 10, 2011 Hi anagha where do i use this case statement? In the query itself? Link to comment Share on other sites More sharing options...
anaghaphadke Posted February 10, 2011 Share Posted February 10, 2011 Hello, Please use this in queryThanks & Regards, -Anagha Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now