Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Hi you can use this example with "macro" or "hide/show"
But thw macro is not recommended.
Haneesh wrote:if([Field 1]='a',true(),false())
Or just:
[Field 1]='a'