Topic Options
#13338 - 06/26/08 11:13 AM Hide Columns in Gridview based on Filter
Todd Levin Offline
Adagio Groupie

Registered: 05/14/08
Posts: 19
Loc: Los Angeles, CA - USA
I want to hide a column based on the filter used - not 'hide when printed' all the time.
I'm using the following calculated column formula which returns a blank column, but I prefer not printing the column at all. Is this possible?
-Todd

IF
(
FILTERNAME()="ALL BULK - BLK, NSB, OSB",
" ",
{Minimum Level 1} / {Alt Factor 1}
)

When it's true, I get a blank column. When it's false, I get the result of the formula.
I prefer getting no column if true and the result if false.

Top
#13339 - 06/26/08 11:33 AM Re: Hide Columns in Gridview based on Filter [Re: Todd Levin]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11550
Loc: Vancouver, BC Canada
Sorry, but columns cannot be hidden based on the results of a filter or a calculated column. Neither can rows, though there is a separate Row Formatting function that could mimic the filter.

Create 2 separate Views - one for when using the 'all bulk' filter and another for other filters.
_________________________
Regards,
Softrak Tech Support

Top
#13361 - 06/26/08 07:25 PM Re: Hide Columns in Gridview based on Filter [Re: Softrak Support]
Todd Levin Offline
Adagio Groupie

Registered: 05/14/08
Posts: 19
Loc: Los Angeles, CA - USA
Thanks, I was afraid of that.
Is there any way to keep it all in one Gridview file?
Can 2 views exist in one GV file?

Top
#13362 - 06/26/08 07:28 PM Re: Hide Columns in Gridview based on Filter [Re: Todd Levin]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11550
Loc: Vancouver, BC Canada
2 ore more views can exist in a single workspace. Simply have multiple views open (can be related or not), then from the file menu, choose Save Workspace. All view (GV) and workspace (GVS) files must be saved to the same Windows folder.
_________________________
Regards,
Softrak Tech Support

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 75 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14467 Topics
70662 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30