Field event Trigger

[#1]

Hi,

Can anybody help me with my query.?

I have one field (Field 1) with values 'a', 'b', 'c'.

On selection of a or b or c, i want to display one chart and minimize other two. how do i do it through macro.

i know it's pretty simple, but for me, it's some what tough. so, pls help.

[#2 · Accepted solution]

You need not use macro. You can use an expression in the 'Conditional' show property under the 'Layout' tab. The expression will be as follows:

if([Field 1]='a',true(),false())

If you include above expression in the conditional property of the chart, the chart will be shown only when the value of field 1 is 'a'. You can use similar expression for other charts which should be displayed for other values of Field 1.

Regards, Haneesh

[#3]

Hi you can use this example with "macro" or "hide/show"

But thw macro is not recommended.

[johnw]

Haneesh wrote:if([Field 1]='a',true(),false())

Or just:

[Field 1]='a'