How to limit the number of dynamic columns in rdlc report

TS YUK 51 Reputation points
2022-04-28T11:21:17.1+00:00

Hello everyone!

I'm stuck in finding the way to set the dynamic columns to the specific number in matrix control of rdlc report.

If the number of columns exceed 10, I want to fix the the maximum number of dynamic columns in matrix control to 10 as below.

PRODUCT COL1 COL2 COL3 COL4 COL5 COL6 COL7 COL8 COL9 COL10
A 10 8 10 11 10 10 14 10 15 9
B 3 10 5 13 20 9 10 8 13 10
.
.

.

IN NEXT PAGE

PRODUCT COL11 COL12 COL13 COL14 COL15
A 10 10 10 10 10 10
B 20 20 20 20 20 20
.
.
.


Your help will be very appreciated.

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

Accepted answer
  1. Joyzhao-MSFT 15,571 Reputation points
    2022-04-29T01:44:43.01+00:00

    Hi @TS YUK ,
    You might consider using Custom Code to limit the number of columns per page of the matrix.
    Please refer to the following link: Limit no of columns in SSRS matrix report.
    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.


0 additional answers

Sort by: Most helpful