Hello Everybody, I've the following problem, I've a pie chart divided in 3 categories, so 3 different slices. How can I create a drill down for each of these slices? I need for every slice to open a different report. Thank you in advance, Andrea

Andrea, You can use an expression to make the drill through report dynamic (whether it is a drill through report or link to url). Hit the Fx button next to Specify a Report in the action tab. Then add an expression with something to the effect: =IIF( Fields!.MyField.Value = "This", "DrillThru_Report1", IIF( Fields!.MyField.Value = "That", "DrillThru_Report2", "DrillThru_Report3")) Please note though, if this data is all related in some way, you may be able to create a single drill thru report and pass appropriate parameters to filter it accordingly. Good luck, Mark

Hi Mark, I'm really sorry for the late answer but it's hard to explain know why I'm replying you only now :) Thank you very much for your suggestion, I still have the problem and I was wondering if there's a solution for this situation: I've a pie chart with 5 Slices, each slice represent a city I need to open a report passing to the new report the value of the drilled slice. Can you help me ? Thank you in advance, Andrea

If you are doing a Drill Thru report action, then you set the parameters to pass in the action menu of the parent report. There you define the column that you are passing in to which parameter on the drill thru report. If you are using a drill thru to a url, you can use a querystring to pass the parameters. Here is some information on the correct syntax for that: http://msdn.microsoft.com/en-us/library/ms155391(v=sql.100).aspx Mark

If you are doing a Drill Thru report action, then you set the parameters to pass in the action menu of the parent report. There you define the column that you are passing in to which parameter on the drill thru report. If you are using a drill thru to a url, you can use a querystring to pass the parameters. Here is some information on the correct syntax for that: http://msdn.microsoft.com/en-us/library/ms155391(v=sql.100).aspx Mark