Interactive sort for multiple tables RRS feed

  • Question

  • I used VS2008 Report Wizard to create a Table report that has each LOB in a page break, and then a table.  I'm turning on Interactive Sorting.  It's the Web report viewer I'm using.

    I notice the Interactive Sorting values are remembered on a page-by-page basis, but no matter what I choose for "scope", it only changes the sorting for the current page.

    If I turn off the page breaks, I see all the tables on one page, and the interactive sort only affects the current table.

    What do I need to do to have the interactive sort affect everything?

    Also, what useful action could I take in the ReportViewer.Sort event handler?  I get notified when the click happens, but no way to set the interactive sort columns or state or view or affect anything, AFAICT.

    Monday, May 24, 2010 8:15 PM