SSRS Report History Snapshot not sorted in 'Created' date

Sandie Zarate 1 Reputation point
2022-01-04T23:21:42.88+00:00

SSRS reports history snapshots162325-snapshot.jpg are used to be in created date order but now it is shuffled and not in order. Below is a sample screenshot from one of our report and the sorting issue is occurring across all the reports history snapshot. Please let us know if any sorting option can be provided or sorted based on created date (how it was earlier).

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.
3,061 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 47,436 Reputation points
    2022-01-05T07:10:41.293+00:00

    from one of our report

    So it's a customer created report? And have you defined a sort order in the datasource / report tablix? If not, it's natural that you get data in a random sort order.

    0 comments No comments

  2. Joyzhao-MSFT 15,631 Reputation points
    2022-01-05T07:19:07.077+00:00

    Hi @Sandie Zarate ,
    This may be a natural order. You can modify it in the following method.
    In the historical snapshot page, when you click the "Created" option, it will be sorted in the positive or reverse order of date.
    162456-02.jpg
    It can also be sorted according to “Size”.
    162428-03.jpg
    Best Regards,
    Joy


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.