Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Hide Column in SSRS Based on Parameter

(0) ShareShare
ReportReport
Posted on by 55

Hi All,

I am working on a custom version of the Transfer Order Overview report(InventTransferOrderOverview). I removed and re-added some columns and I'm running into an issue.

For columns related to parameters, they should be visible/hide based on whether the parameter is selected. In the standard report, if the parameter isn't selected it is hidden, and the column acts as though it was collapsed. What I'm running into, is that when I don't select a parameter, it leaves a blank space where the column would have been:

pastedimage1677113012787v1.png

I've looked up several SSRS tutorial videos and forum posts, and all seem to just use the visibility property of the column, which is what I set:

pastedimage1677113108877v2.png

Using this expression: 

"=iif(Parameters!ViewInventSerialId.Value="Yes", false, true)"

What would be needed for the column to collapse and not just become blank like that? It isn't clear to me looking at the standard report how they were collapsing/hiding it. Any help or clues in the right direction would be greatly appreciated. Thank you!

  • Cody M Profile Picture
    Cody M 55 on at
    RE: Hide Column in SSRS Based on Parameter

    Hi Mohit,

    Thanks for the link, you are a life saver. I needed to set the hidden property of the column group, not the column itself.

  • Suggested answer
    Mohit Rampal Profile Picture
    Mohit Rampal 12,554 Super User 2024 Season 1 on at
    RE: Hide Column in SSRS Based on Parameter

    Hi Cody, check this tutorial

    www.google.com/search

  • GirishS Profile Picture
    GirishS 27,821 Super User 2024 Season 1 on at
    RE: Hide Column in SSRS Based on Parameter

    Hi Cody,

    Have you set the visibility for the each text box or for the whole columns?

    Try to set the column visibiltiy.

    Select whole column and then click on column visibiltiy.

    Thanks,

    Girish S.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,162 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans