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:
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:
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!
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.
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.
André Arnaud de Cal...
292,162
Super User 2025 Season 1
Martin Dráb
230,962
Most Valuable Professional
nmaenpaa
101,156