Hi , I have a drill down tabular report with Country States Hierarchy when i click on country chart needs to show the sum(country) and clicking drill down on (+) mark the needs to get the all child data i.e state...... How can i achieve on Clicking drill down chart needs to refresh.... Thank you

Hi krishna_ece, If I have correctly understand you, there is a need to achieve the drill down action on the same chart. I'm afraid it might be impossible in Reporting Services. One possible workaround is to drill to another report with all child data by "go to report" action. References here: http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/f405bd33-f5cd-46dc-b809-c4a4bfced097 http://social.msdn.microsoft.com/Forums/ar/sqlreportingservices/thread/dbe7db7e-786a-4444-bd46-8602bc8a0bf1 Thanks, LolaPlease remember to mark the replies as answers if they help.