Hi, I have drill down in my ssrs report. But when I export the report to Excel , I get fully expanded report instead of drill down. Is there any way to get the drill down in Excel report as per the grouping? I want report which is when exported in Excel should have drill down as it is in ssrs instead of fully expanded report and it should expand at the click of drill down. Any suggestion how to implement it. Or if this thing is not possible. Thanks

Hi, you can able to see the drilldown while preview report? did you export the report after expanded ? if you export the report after expanded you will get the expaned report only. hope it helps Best Regards, C.Gnanadurai ----------------------- Please mark the post as answer if it is helpfull to you