Drill down SSRS: hide columns based on drill down in ssrs

Question

Before drill down summary report:

After drill down :

I have tried this and not able to hide project Name column,it should show only when I drill down the human resource fields.

Answer 1

I can suggest an workaround for this. However ProjectName Column heading will not be visible in this case.

The following is the process.

1) Remove the column heading of ProjectName (only text keep column as it is). 2) Merge 1st and 2nd column headings and for the group as well.

Now it looks as follows in design mode:

It will show as no column visible for Project name but data is visible once we expand the group.

output will be shown as follows: