Hiding a column in a List box

[#1]

Hi,

Can you hide a column in a list box. I've got two columns the second is an expression, I would like to hide the first one.

Rgds

Graham

[PrashantSangle]

Hi,

Can you post Example,

Regards

[its_anandrjs]

Hi,

I dont understand a requirement but can you ask for hiding any list box then go to layout properties and load condinally

can you explain more.

Hope this helps

Thanks & Regards

[#4]

Hi Hamster70

please attach the snap of your problem

[DavidFoster1]

I think the answer is 'No'. BUT did you know that if you scroll to the bottom of the field list in the the List Box properties then you can select <expression> and input an expression directly?

[#6]

I saw that, the problem is my expression is based on the first columns information.

[tresesco]

May be you are trying to show something like Sum(Amt) against a dimension. And you don't want the dimension values to be visible. If so, you might not need a dimension/field. You can write your expression, something like:

=Aggr(Sum(Amt), Yourdimension)

Hope this helps.

[fernando_tonial]

Hi Graham,

This isn't possible. Maybe you try with a Straight Table. See my example.

Best Regards.

[#9]

Hi Fernando,

I've got a field (Departments) I'm trying to show but it has to be sorted in a particluar order. I'm using the RowNo() expression but this only works if the Departments field is already there.

Any ideas?

Rgds

Graham

[tresesco]

Have you tried expression like:

=Aggr(RowNo(), Departments)

?

Add: This would not require Departments to be there. You can use this expression directly as expression instead of a field.