Interactive Sorting of a Subreport Column...

Question

I 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.

Answer 1

 

Hello,

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.

Hope helpful...

Thanks,

Pavan

Answer 2

Pavan,

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).

Answer 3

hi,

i have same problem in my project ,so i wonder if you guys already had fixed it, any reply would be appreciated

thanks

Answer 4

This 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?