Hi, I've a dataset (based on a model) that holds a date field and a value field. The dates are decided into years, quarters, months. When this is used inside a tablix I can set a collapse/expand behavior on the different group (years, quarters and months). Is there a way to do the same with a chart so that first only the years will appear, then a specific year could be opened into its specific months and so on? I'm using SSRS 2008 (with a possibility to use R2). Thanks

You can get a similar effect by using Actions. Select the series and then create an action that goes to another report or the same report and create and pass a parameter value that represents the current year, quarter or month. I have an example posted here: http://blogs.msdn.com/b/seanboon/archive/2009/02/09/enabling-drilldown-on-ssrs-reporting-services-2008-charts.aspx -SeanProgram Manager, SQL Server Reporting Services This posting is provided "AS IS" with no warranties, and confers no rights. http://blogs.msdn.com/seanboon http://www.twitter.com/ssrs