Filtering a list on a hidden column

[mrl72]

All -

I have a list within a deck card that is controlled using a Data Drop down list. The list is grouped on say "Country". The dropdown list displays "US" and "CA" and is set to filter on the list. Everything works fine except when I then hide the Country column as I don't want it to be shown, the filter stops working. It just displays a blank list.

Is this by design? If so, can anyone recommend a workaround?

Cheers.

[MFGF]

All -

I have a list within a deck card that is controlled using a Data Drop down list. The list is grouped on say "Country". The dropdown list displays "US" and "CA" and is set to filter on the list. Everything works fine except when I then hide the Country column as I don't want it to be shown, the filter stops working. It just displays a blank list.

Is this by design? If so, can anyone recommend a workaround?

Cheers.

Hi,

What steps are you taking to hide the Country column? Are you using the Column Visibility property or are you setting the Box Type to None (or some other way)?

MF.

[mrl72]

Both box type set to none and visibility = no produce the same results. I think what it's doing is using HTML markups/references to the data label so it has to be present in the code somewhere.

Only solution I found so far is to set the font to white and size 1pt. That seems to work fine for now but not an elegant solution by any means.

[MFGF]

Both box type set to none and visibility = no produce the same results. I think what it's doing is using HTML markups/references to the data label so it has to be present in the code somewhere.

Only solution I found so far is to set the font to white and size 1pt. That seems to work fine for now but not an elegant solution by any means.

Hi,

Box Type set to none will give you the sorts of odd results you're experiencing here, but the "Column Visibility" property should work just fine - its purpose is to hide columns you want your variable to filter on in a list in your active report.

Are you sure you're looking at the correct property? It's called "Column Visibility" and the options you can select are "Visible", "Hidden" or "Visible based on condition". There isn't a "yes/no" option.

Cheers!

MF.