Page 1 of 1
Limiting rows in chart
Posted: Fri Sep 18, 2009 9:57 am
by pauljza
I have a chart for which I want to limit the total number of rows displayed. I have tried to use the Filters and set an expression filter for Lines<11 but this does not appear to be working.
Is there an alternative way to limit the total rows in a chart without resorting to changing the data source?
Limiting rows in chart
Posted: Tue Sep 22, 2009 6:51 am
by Jan
Hello,
Please check sample report.
Thank you.
Re: Limiting rows in chart
Posted: Wed Oct 10, 2012 11:56 pm
by aaronrc
I'm trying to limit the number of rows displayed in a chart as well. I've downloaded the sample report but I can't find where the limiting is done. Could you give me a pointer as to whereabouts in the report it happens? Is it in the data source itself or somewhere in the chart properties?
Re: Limiting rows in chart
Posted: Thu Oct 11, 2012 10:08 am
by Alex K.
Hello,
Please check the Filter property for chart component.
Thank you.
Re: Limiting rows in chart
Posted: Thu Oct 11, 2012 10:00 pm
by aaronrc
Thx. For some reason when I open that example report there are no filters set on the chart. I've set a filter expression of "Line <= 20" on my own report but it does not appear to have any effect. Is that the correct expression?
Re: Limiting rows in chart
Posted: Fri Oct 12, 2012 6:23 am
by HighAley
Hello.
aaronrc wrote:Thx. For some reason when I open that example report there are no filters set on the chart. I've set a filter expression of "Line <= 20" on my own report but it does not appear to have any effect. Is that the correct expression?
Line system variable doesn't work with chart.
It seems that you open the Filter property of the Series instead of the Filter property of the Chart.

- ChartFilter.png (59.63 KiB) Viewed 3036 times
Thank you.
Re: Limiting rows in chart
Posted: Mon Oct 15, 2012 1:53 am
by aaronrc
Thanks. A filter using "Position" in it worked for a bar chart but not for a pie chart. In he charts below I've set a filter on them both with DataSet.Position < 10.
Re: Limiting rows in chart
Posted: Mon Oct 15, 2012 6:49 am
by Alex K.
Hello,
Please send us your .mrt file for analysis.
Thank you.