Limiting rows in chart

Stimulsoft Reports.NET discussion
Post Reply
pauljza
Posts: 18
Joined: Mon Dec 08, 2008 3:04 am
Location: South Africa

Limiting rows in chart

Post 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?
Jan
Posts: 1265
Joined: Thu Feb 19, 2009 8:19 am

Limiting rows in chart

Post by Jan »

Hello,

Please check sample report.

Thank you.
Attachments
231.Report.mrt
(20.96 KiB) Downloaded 479 times
aaronrc
Posts: 23
Joined: Thu Apr 05, 2012 2:41 am

Re: Limiting rows in chart

Post 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?
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Limiting rows in chart

Post by Alex K. »

Hello,

Please check the Filter property for chart component.

Thank you.
aaronrc
Posts: 23
Joined: Thu Apr 05, 2012 2:41 am

Re: Limiting rows in chart

Post 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?
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Limiting rows in chart

Post 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
ChartFilter.png (59.63 KiB) Viewed 3030 times
Thank you.
aaronrc
Posts: 23
Joined: Thu Apr 05, 2012 2:41 am

Re: Limiting rows in chart

Post 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.
Attachments
Screen Shot 2012-10-15 at 12.50.20 PM.png
Screen Shot 2012-10-15 at 12.50.20 PM.png (349.35 KiB) Viewed 3023 times
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Limiting rows in chart

Post by Alex K. »

Hello,

Please send us your .mrt file for analysis.

Thank you.
Post Reply