Jasper - Select first Item from group using Expressions


I have  TextFields that displays a list of zones and stations i n a grid layout. The zones col has a list of zone names and station avg's. The stations col has a station name and station avg. A zone has many stations and not all stations has a avg.

How do I select one zone and display all stations that has readings only. I am using sql to create the query.


zain.nabi's picture
Joined: Apr 11 2019 - 5:05am
Last seen: 2 weeks 5 days ago

1 Answer:


Not sure what you are asking. If you are asking how to write a sql statement to query a particular zone, just create a parameter and use that in the sql query statement.

For example, create a parameter named "zone". 

In this case, the sql query would be like below (I'm assuming the table name containing zone information is "zones".

SELECT * FROM zones WHERE zone = $P{zone}

hozawa's picture
Joined: Apr 24 2010 - 4:31pm
Last seen: 2 days 7 hours ago