Jasper - Select first Item from group using Expressions

[zain.nabi]

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.

 

[hozawa]

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}