Hide a load field in order that the user can see it

[#1]

I have a quick question, how can i hide a field that is loaded in order to load it, but the user can't see it.

Thanks,

[#2]

Can you be a little more specific? I'm imaging you want to load it into a pivot/straight table for ordering purposes but don't want it to be visible?

[#3]

if this field is no longer utilisés, can Elmina with

</div><div>
DROP FIELD field;</div><div></div><div>

[#4]

If it is a dimension or dummy expression in a pivot table for example, you can make it 0 width to hide it from display (but be aware the user might still get at it if downloading to excel)

You just need to run a macro on it once (attach the macro to a button) where the code would be like this:

sub test1

set chart = ActiveDocument.GetSheetObject("CH01")
set p = chart.GetProperties

set dims = p.Dimensions
dims(0).ColWidth = 0

set expr = p.Expressions.Item(0).Item(0).Data.ExpressionVisual ' group.expression numbered from 0
expr.ColWidth = 0

chart.SetProperties p

end sub

Regards,

Gordon

[#5 · Accepted solution]

Hi, thanks for the responses, I found the solution:

In the Main area:

set HidePrefix='_' ;

and then, all the fields I want to be hidden, put a '_' ahead the field name.

Regards

[Oleg_Troyansky]

keep in mind that this solution is "cosmetic" only. If your users can check "Show system fields", the hidden fields become visible again. If you need to hide the fields for security reasons, look into using a keyword OMIT in Section Access.

[#7]

Hi Gordon,

I'm trying to implement the code you provided about but not having any success. I'm trying to hide a column called "Reported_QTY" as soon as the pivot table is loaded. Is this possible?

Thanks

Ward

[#8]

The code is designed to be run once during the development process to 'permanenetly hide' a column. If you are trying to hide a column dynamically then that is a different matter (and I personally create different tables rather than allow a session to 'change' the attributes of a chart).

However, are you sure that you are defining the correct occurence of the column?

Regards,

Gordon