filter the report for the top 10 sales and sort by sales

beom0313 110 Reputation points
2023-09-28T09:06:21.7633333+00:00

Can I filter the report for the top 10 sales and sort by sales?

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,065 questions
{count} votes

Accepted answer
  1. Anonymous
    2023-09-29T01:43:08.52+00:00

    Hi @beom0313

    I did a simple test.

    First this is my source data.

    User's image

    Then make the following settings in the Filters property box in the Tablix property, and sort according to Sales in the Sorting property box.

    User's image

    User's image

    Preview:

    User's image

    If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

    Best regards,

    Aniya

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Olaf Helper 47,516 Reputation points
    2023-09-28T10:15:09.68+00:00
    0 comments No comments

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.