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.
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
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.