web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
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!

I have the same question (0)
  • Cody M Profile Picture
    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
    12,563 Moderator on at
    RE: Hide Column in SSRS Based on Parameter

    Hi Cody, check this tutorial

    www.google.com/search

  • GirishS Profile Picture
    27,825 Moderator 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 764 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 619 Most Valuable Professional

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 603 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans