Add top N filter to JasperServer report

[domagoj.hrzic]

Hi all,

is there a way to set a filter to show only top N results, for example I made a report that shows a chart with 40 bars,

so I want to do is to set the filter to show only top let's say 5 result.

Thank you

[pplaydon]

If you change the view type to a Crosstab, you can then right click on the measure column header in the crosstab and it will allow you to filter on the Top N or Bottom N values, as well as sort ascending or descending.  If you do this and then change the view type back to a chart, your bar chart will retain these settings and just show the top N bars.