Using Column grouping takes more time.

Navinkumar Kanagaraj 86 Reputation points
2022-05-25T11:46:48.373+00:00

I have one dataset, where I am getting all the data. It consists of some 30 columns and based on parameters, it is providing the no of Rows.

I am using Column grouping in the SSRS report Tablix, it is working fine. But when the no of records are high, then the Tablix is taking too much time to load.

The same thing is taking very less time to load in SQL Server.
Is there any better solution for making it's performance improve?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions
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,798 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,552 questions
Accepted answer
  1. Joyzhao-MSFT 15,566 Reputation points
    2022-05-26T01:28:26.447+00:00

    Hi @Navinkumar Kanagaraj ，
    When you view a report, you might experience a long wait time before you see the first page. To help determine where the report processing time is being spent, see Troubleshooting Techniques for Report Problems. After you determine whether the delay time is in data retrieval, report processing, or report rendering, use this topic to help troubleshoot issues.
    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.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest