asked on

Is it posible make a column fully conditional using SSRS.

Is it possible to make an SSRS column fully conditional? I have tried using the hidden property and the Column Visibility property and the best it does is leave the column blank. I want the column width to go to zero and have all subsequent columns shift to the left. Is this possible?

Ryan Chong

I want the column width to go to zero and have all subsequent columns shift to the left. Is this possible?

Yes this is possible, which means to genearate dynamic columns based on your data source.

I have tested this code before and it worked:

DynamicColumnsRdlcDemo
https://github.com/iamshiao/DynamicColumnsRdlcDemo

rwheeler23

ASKER

Are you saying this cannot be done in the GUI but must be done by modifying the code?

Ryan Chong

have you tried the sample in that link? it got the gui

rwheeler23

ASKER

I downloaded the DynamicColumnsRdlcDemo-master.zip file. Is this the entire project?

rwheeler23

ASKER

This appears to be all code. Where in this code does it allow for a column to be completely dynamic?

rwheeler23

ASKER

DynamicColumnsRdlcDemo.sln is the only solution in this download. It opens up as code not as an SSRS project.

Ryan Chong

sorry that currently I'm focusing on other stuffs and not really doing SSRS these days in my work. So, I can only share based on my experience.

you may try to alert the moderator so more experts can come in this question to help out.

rwheeler23

ASKER

Not a problem. For others looking for a solution I came across this article.

https://www.sqlstad.nl/sql-server/hide-or-show-columns-in-ssrs-reports-using-parameters/

This question needs an answer!

Become an EE member today

7 DAY FREE TRIAL

Members can start a 7-Day Free trial then enjoy unlimited access to the platform.

View membership options

Learn why we charge membership fees

We get it - no one likes a content blocker. Take one extra minute and find out why we block content.