Displaying an String Output

[richriccio]

I'm brand new to iReport;

I have a data source with 4 levels of scoring.

field_4 is a Desimal ouput

How do I get a display on my report:

If field_4 is <80% then display "Has Issues"

If field_4 is >80% but < then 85% then display "Improvement required"

If field_4 is >85% but < 90% then display "Meets Expertations"

If field_4 is >90% but < 95% then display the answer "Exceeds Expertaions"

I appreciate this very much!

 

The code may not be of any help for you.

Code:

SELECT     qa_formdata_1.`score_1` AS qa_formdata_1_score_1,     qa_formdata_1.`sectionweight_1` AS qa_formdata_1_sectionweight_1,     qa_formdata_1.`sec_score_1` AS qa_formdata_1_sec_score_1,     qa_formdata_1.`rating_1` AS qa_formdata_1_rating_1,     qa_formdata_1.`rating_2` AS qa_formdata_1_rating_2,     qa_formdata_1.`rating_3` AS qa_formdata_1_rating_3FROM     `qa_formdata_1` qa_formdata_1

[mrcaffeine]

you could do that with a tertiary operation as field expression. Create a text field having this as expression:
 

( field_4 < 80 ? "Has Issues":  ( field_4 < 85 ? "Improvement required" :   ( field_4 < 90 ? "Meets Expertations" :   ( field_4 < 95 ? "Exceeds Expertaions" : ""   )  ) ))