SSRS report - table sorting

Zolotoy 221 Reputation points
2023-02-02T20:21:17.7033333+00:00

I have a table in a report. It is grouped by the first column. If I set table order to one of the columns the order is not working. It only works if I set sorting on the detail group. The second thing is I am additng an iteractive sort to one of the columns. The interactive sort is not working either. Why wouldn't it work?

Thanks

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,732 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AniyaTang-MSFT 12,216 Reputation points Microsoft Vendor
    2023-02-03T02:13:27.83+00:00

    Hi @Zolotoy

    What do you mean by "order doesn't work"? Does it mean that the data has not changed at all?

    I did a simple test and made a report to group by the first column. I sort number in the Tablix data area and in the details group separately and they show the same result, both sort "Number" within the group.

    1

    I also tried adding interactive sort and it works fine too. Are there any problems with your operation?

    2

    Are there any problems with your operation? Maybe you can refer to these links to understand the steps of sorting.

    Sort data in a data region

    Interactive sort in a paginated report

    Best regards,

    Aniya

    0 comments No comments