Reporting Services Error after Interactive sorting and drill down in pps

Hi Hyaron,

I am unable to reproduce the issue in my test environment. How did you add the drilldown feature? Were you doing that by setting visibility of the column or of the group? Please ensure to add the drilldown functionality by set the visibility of the workgroup from the Grouping Pane in the Report Designer.

How did you add the Interactive Sorting on the headers of the two columns? Based on the drilldown functionality, the Interactive Sorting on the second column doesn’t work. So, you can move the Interactive Sorting on the second column. When configuring the Interactive sorting on the first column, you should set the parent group to sort, and sort by the field that the parent group groups by.

Hope this helps.

Regards,

---

Mike Yin

TechNet Community Support