Hi,I am creating a dashboard report My screen is divided into quarters and I have a graph in each quarter. Is it possible to use sub reports in each quarter that could be drilled down by the user. For example the user could drill down on a bar chart graph in quarter 1, but the rest of the quarters remains static on the screen.

Yes. You can create an action on the series and use the "jump to" action type to go to another report that could be the exact same report. Pass the value of the quarter as a parameter to that second report, as well as a parameter that indicates which chart was clicked on. Wire up the second report to these parameters and it should be possible. I have an example of this over on my SkyDrive account at http://cid-209305deacf224d0.skydrive.live.com/self.aspx/TechReady%208/TechReady8.zip There should be a report called "drilldown" in that zip file. It takes care of the drill down part, but you will need to add a parameter to indicate which chart was drilled on. Chris Webb also has a similar example posted on his blog as well. -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

I am on the SSRS 2005. Does that matter? When I try to open your report I get error saying "The Report element was not found."

It matters in terms that you can't open up the sample that I pointed you to, but the technique still works on SSRS 2005. You need to create an action on the series that goes to another or the same report and pass a parameter for the quarter to the second report, as well as a parameter that indicates which chart was selected. Unfortunately I don't have a sample that runs on SSRS 2005, but if you download Report Builder 2.0, you can open up the report sample, and look at how it's set up. You can then use that same technique on SSRS 2005. -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

PDF to EPUB Converter , PDF to EPUB Converter for Mac , PDF File Transfer , Transfer PDF to iPhone 3G , PDF Ripper , Convert PDF to Image , Convert PDF to BMP , Convert PDF to Tiff , Convert PDF to Office , Convert PDF to Excel , Convert PDF to Word , Convert PDF to Doc , Convert PDF to TXT , Convert PDF to Text , Convert PDF to RTF , Convert PDF to Powerpoint