HI All, I have bar graph as shown below.,i have taken range bar for that in SSRS 2008 ! Type C! ___________ Type B! ______ Type A! _________ !_________________________________ I have query for the same which fetches data for all records,now i want to click on Suppose graph of Type A ,then new report will populate which contains data only for Type A,in the similar way when i click on Type B Graph ,it will open the new report which contain data only for Type B Amit

Check out the following links on interactive drill-down/through charts. Let us know if helpful. http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/039e17e6-77f9-4e16-b3fb-75ffa428a34d http://social.msdn.microsoft.com/forums/en-US/sqlanalysisservices/thread/0d284266-48a2-4c40-b91a-dad378221f47 http://msdn.microsoft.com/en-us/library/aa964128(SQL.90).aspx Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM