Chart synced with other data

SSRS 2008 r2

I have 2 datasources, 2 datasets and 2 objects on the report. 1st object is a chart, 2nd object is a tablix

Chart gets data from 1st dataset, x axis is time

Tablix has some other data from 2nd dataset that I want to filter dependent on time passed to it.

I want to click on the chart and pass the date/time value to the tablix. I want the tablix to filter on the time passed +/- 15 minutes.

WHERE 
Log1.TimeStart > dateadd(MINUTE,-15,@parDateTime) and
Log1.TimeStart < dateadd(MINUTE,15,@parDateTime)

Which do I select to add the action and filter the tablix based on the series value passed from the chart

Stephen

This is an interesting idea.  I think what I would try is to reference the same report in a go to report action.  You would have to configure some parameters to take the appropriate inputs to filter everything as you desire, but it should work.  The only problem would be if the report takes a long time to run.

There was a session on Advanced Reporting Services in last fall's 24 Hours of Pass that is available on the website that demonstrated some amazing things with interactive slicing right on a report.  It might be worth a view for your problem as well.  I am not positive, but I think it was the presenation by Simon Sabin. 

Good luck  Whatever you figure out, you should post your solution here, or blog about it.  I am sure a lot of people would find it interesting.