Clarity

 View Only
  • 1.  jaspersoft report filter on a range of values

    Posted Apr 25, 2019 11:46 AM

    I have a calculated field that is linked to a display map. if the value range from 1-40 it displays green, if the value range from 41-80 it displays yellow, if the value range from 81-100 it displays red. 

    I'm writing a jaspersoft report and I want to be able to filter on that lookup (green, yellow, red)

    how do i write my sql statement to accept the range?

    Any ideas?



  • 2.  Re: jaspersoft report filter on a range of values
    Best Answer

    Posted Apr 25, 2019 12:45 PM

    I created an id for each range and I was able to map it to the lookup. Problem solved.