I am building a chart in reporting services 2008, and at the report level I would like to restrict number of series groups (x-axis) to 10, so that chart does not grow too big and get difficult to read. Without changing the query that returns the rows, is there a way i can restrict number of series in the chart in each page to 10 ??

This has to be done @ Query Level itself.Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://myspeakonbi.blogspot.com/

Hi Rakesh Thanks. But how this can be done in the query level?

Hi hmai, Based on your description, I see there are too much groups on X-axis to read easily. So you want to break the page after a certain number of groups. To do this, please refer to the similar thread: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/e151aab5-7265-456d-b62c-38e7dff90ad5/. Any questions, feel free to ask. Thanks, Lola Wang Please remember to mark the replies as answers if they help.

Hi hmai. have you also tried to limit the rows returned via chart properties > filters? Regards, Arcus (working on SSRS 2008 R2)