Share via

Using Column grouping takes more time.

Navinkumar Kanagaraj 96 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 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.

Developer technologies | Transact-SQL
Developer technologies | Transact-SQL

A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

Answer accepted by question author

Joyzhao-MSFT 15,651 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.

Was this answer helpful?

1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

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