How to limit the number of dynamic columns in rdlc report

TS YUK 51

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.

Isabellaz-1451 3,616 Reputation points

2022-04-29T01:41:05.16+00:00

Hi @TS YUK
please refer to this thread:https://masudprogrammer.wordpress.com/2012/06/29/ssrs-report-limit-no-of-columns-in-ssrs-matrix-report/
I have tested it ，it surely can meet your needs.

Best Regard，
Isabella
TS YUK 51 Reputation points

2022-04-29T02:59:16.363+00:00

Thank you for reply.

Your solution need the custom code function of SSRS(Sql Server Reporting Service), but I made program not in SSRS.

I am working with the ReportViewer control (formerly included in Visual Studio, now available as a nuget package) in process client-side reports (.rdlc files) not requiring SQL Server.
TS YUK 51 Reputation points

2022-04-29T05:21:33.29+00:00

Just seconds ago, I found the way how to write custom code through rdlc report properties.
I will try it and let you know the result.

Thank you.
TS YUK 51 Reputation points

2022-04-29T05:57:11.307+00:00

I tried as you told me and it worked successfully.

So, I adjusted some codes to be suitable to my case and then, finally I got the result as I expected.

Thank you again.

Best regards.

Accepted answer

Joyzhao-MSFT 15,566 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.
Please sign in to rate this answer.
TS YUK 51 Reputation points

2022-04-29T03:02:23.1+00:00

Thank you for reply.

Your solution need the custom code function of SSRS(Sql Server Reporting Service), but I made program not in SSRS.

I am working with the ReportViewer control (formerly included in Visual Studio, now available as a nuget package) in process client-side reports (.rdlc files) not requiring SQL Server.

Is there anyway to get into custom code in process client-side reports (.rdlc files)?

TS YUK 51 Reputation points

2022-04-29T05:22:33.127+00:00

Just seconds ago, I found the way how to write custom code through rdlc report properties.
I will try it and let you know the result.

Thank you.

TS YUK 51 Reputation points

2022-04-29T05:58:56.027+00:00

I tried as you told me and it worked successfully.

So, I adjusted some codes to be suitable to my case and then, finally I got the result as I expected.

Thank you again.

Best regards.
Sign in to comment

How to limit the number of dynamic columns in rdlc report

.

0 additional answers