Share via

How to display SSRS report columns in rank order

Bala Narasimha Challa 466 Reputation points
2023-10-06T12:20:52.7266667+00:00

Hi Team,

Want to display columns in rank order as shown in bellow. Please help me if it is possible.

Want to implement in dynamically because have 100 columns in dataset.

Input:

User's image

output:

User's image

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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-10-09T07:04:02.9733333+00:00

    Hi @Bala Narasimha Challa

    I did a simple test and this is my source data.

    User's image

    1. Add a matrix to the report and add the "ColumnName" field to the "Columns" area.

    User's image

    1. Then right-click the ColumnGroup, open the Group properties, find the sorting property box, and make the following settings.

    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
  2. Olaf Helper 47,436 Reputation points
    2023-10-09T07:51:49.21+00:00

    Calculate the ranking in SQL (if not already done) and then use a Matrix in your report to pivot the data sorted by the ranking.

    See Create a matrix in a paginated report (Report Builder)

    0 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.