subreport based on logic

[gmpf]

Hi everyone

I would like to create a report based on a query. The first part is simple enough. However within this query I have a 'Count field' (a total of the number of duplicated this record has appeared in the table). And would like to create a subreport (if possible) based on that value for example. if count > 1 then show subreport.

My question therefore; is the above possible? How would I go about linking this logic with the subreport

thanks

 

[JHB]

Show some sample data (in database table/Excel sheet format), and also how you want the result.