Monday, December 08, 2008 5:46 PMI have a column in a table that is a subreport. The subreport is run for every row in the table. Is there a way to specify interactive sorting in the parent table for this column? I've tried a few options in the SortExpression property with no luck.
Tuesday, December 09, 2008 5:10 AM
Select the column header for which you have the sub-report link and right click and go to properties. In properties window go to interactive sort tab in that check “Add an interactive sort action to this textbox” check-box and in dropdown select the field you want to sort.
Thursday, December 11, 2008 2:06 PMPavan,
I'm afraid that's not what I'm looking for. The column I'm trying to sort contains a Subreport, so the value cannot be directly accessed in the Fields collection. I want to know if there is a way to specify the value of the subreport as my SortExpression. Something like =MySubReport.Value (though this does not work).
Thursday, November 19, 2009 2:11 AM
i have same problem in my project ,so i wonder if you guys already had fixed it, any reply would be appreciated
Friday, August 31, 2012 6:34 PMThis problem has re-appeared in SSRS 2008 R2. We have recently upgraded from SS 2005 SP3 to 2008 R2 SP2 and we now have the same problem where we did not before. We have many reports that use subreports that require interactive sorting. This is a serious problem for us. Is there any workaround for this?