Show/hide a field in multibox

[vlad_komarov]

Hello,

Just checking if anybody knows the way to show/hide a field in Multibox (similar to "Conditional" option in chart's expression, for example).

Any suggestions will be appreciated.

Best regards,

Vladimir

[vlad_komarov]

Nitin,

Great idea!

Thank you for your solution.

It works exactly as I needed.

Regards,

Vladimir

[markmccoid]

So, I'm looking at this multibox and I see one Field in the "Fields Displayed" area:

=$(=SubField(concat(distinct [$Field],  '|'), '|', 1))

But I have no idea how this actually works.  When I copy the Multibox, the copy doesn't work, but the original one does.

This feature is really cool, but I can't figure out what is going on.  Can anyone enlighten me?

Thanks!

[Anonymous]

Because it is not one multi box but a set of many multi boxes, where only the top one has caption.  Press Ctrl+Shift+S to see what's going on .  See that the expression and the show condition is slightly different for each.

[markmccoid]

Thanks!  It makes much more sense now!

[#6]

Thanks, but I can't understand how to create the $Field.

I have this kind of scenario:

multiBox with:

dim1

dim2

dim3

then I have a table which has:

dim, inUse, labelName

dim1, 1, DATE

dim2, 1, GENDER

dim3, 0, NULL

In my multiBox I want to show for this only dim1 and dim2 with their labels, how can I do it?

Thanks,