Display sorting criteria in the header

Question

User1863216143 posted

Hi All,

Do you know of any way to display in the header the sorting criteria the user has selected? Can that be accessed programatically?

For example, if I have Column1, Column2, ... Column9 and the user multiselects Column2 and Column5, ideally I'd like to display "Sorted by Column2 descending and Column5 ascending". If this is not possible, is there a way to highlight which columns were used for sorting?

Regards,

Andrew

Answer 1

User500621135 posted

hello sir,

yes,By using the that Column id 

we can highlight that column 

private string ConvertSortDirectionToSql(SortDirection sortDireciton)<o:p></o:p>

    {<o:p></o:p>

        string m_SortDirection = String.Empty;<o:p></o:p>

<o:p> </o:p>

        switch (m_SortDirection)<o:p></o:p>

        {<o:p></o:p>

            case SortDirection.Ascending:<o:p></o:p>

                m_SortDirection = "ASC";<o:p></o:p>

                break;<o:p></o:p>

<o:p> </o:p>

            case SortDirection.Descending:<o:p></o:p>

                m_SortDirection = "DESC";<o:p></o:p>

                break;<o:p></o:p>

        }<o:p></o:p>

<o:p> </o:p>

        return m_SortDirection();<o:p></o:p>

    }<o:p></o:p>

<o:p> </o:p>

    protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)<o:p></o:p>

    {<o:p></o:p>

        DataTable m_DataTable = GridView1.DataSource as DataTable;<o:p></o:p>

<o:p> </o:p>

        if (m_DataTable != null)<o:p></o:p>

        {<o:p></o:p>

            DataView m_DataView = new DataView(m_DataTable);<o:p></o:p>

            m_DataView.Sort = e.SortExpression + " " + ConvertSortDirectionToSql(e.SortDirection);<o:p></o:p>

<o:p> </o:p>

            GridView1.DataSource = m_DataView;<o:p></o:p>

            GridView1.DataBind();<o:p></o:p>

        }<o:p></o:p>

    }

Answer 2

User1863216143 posted

Hi Kamal, 

Thanks for the answer. Does this solution (or a similar one) apply within SSRS?

Regards,

Andres

Answer 3

User500621135 posted

yes,

It works on SSRS

Answer 4

User-8475372 posted

Androcles, 

Right click on the column and select Properties --> Interactive Sorting -- > Sort By <Criteria>

By default, the sorted column highlights itself with an arrow facing the direction of the sort.