question

TSYUK-3423 avatar image
0 Votes"
TSYUK-3423 asked TSYUK-3423 commented

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

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

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 Votes 0 ·
TSYUK-3423 avatar image TSYUK-3423 IsabellaZhangMSFT-7746 ·

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 Vote 1 ·
TSYUK-3423 avatar image TSYUK-3423 IsabellaZhangMSFT-7746 ·

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 Votes 0 ·
TSYUK-3423 avatar image TSYUK-3423 IsabellaZhangMSFT-7746 ·

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 Votes 0 ·

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered TSYUK-3423 commented

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
5 |1600 characters needed characters left characters exceeded

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

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 Vote 1 ·

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)?

0 Votes 0 ·

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 Votes 0 ·