How to limit the number of dynamic columns in rdlc report

Question

question

TSYUK-3423 asked Apr 28, '22 TSYUK-3423 commented Apr 29, '22

How to limit the number of dynamic columns in rdlc report

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

· 4

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

IsabellaZhangMSFT-7746 · Apr 29 at 01:41 AM

Hi @TSYUK-3423
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

0 ·

TSYUK-3423 IsabellaZhangMSFT-7746 · Apr 29 at 05:57 AM

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.

1 ·

TSYUK-3423 IsabellaZhangMSFT-7746 · Apr 29 at 02:59 AM

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.

0 ·

TSYUK-3423 IsabellaZhangMSFT-7746 · Apr 29 at 05:21 AM

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.

0 ·

Answer 1 · 2022-04-29T01:44:43.01Z

Joyzhao-MSFT answered Apr 29, '22 TSYUK-3423 commented Apr 29, '22

Hi @TSYUK-3423 ,
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.

· 3