Hi,

I am using Report Builder 3.0 and i have report which has a drill down group.

The report opens in a collapsed form.This report has interactive sorting on a column. But,when we drill down and sort the column, the group collapses and the details disappear.

In some posts, i have seen that instead of interactive sorting, people recommended a parameter. But i have to do interactive sorting only.

Is there any solution to this problem?

Hi daripalli,

this can be done in one way, follow the below steps.

1. Make the InitialToggleState property value of the field to Expanded ( field on which you are performing expand/collapse).
2. Select all the fields that you are showing/hiding , goto Visibility  property of these fields
 and set Hidden property to False , ToggleItem property to above fieldname of step1