two tables

[soniasweety]

Hi all,

i have two tables  and one listbox called route

and  table1 and table2  

my rquirment is  user select  Direct   table1 should appear and user select indirect table2 should appear

how can i do this?

[vamsee]

You can do this in the Layout tab under properties of a chart.

[soniasweety]

no.. if i select indirect its not working 

[soniasweety]

Hi  Frank Hartmann    any idea on this? 

[Frank_Hartmann]

go to table 1 Layout Tab --> show Conditional:

If(GetFieldSelections(route)='Direct',1,0)

go to table 2 Layout Tab --> show Conditional:

If(GetFieldSelections(route)='Indirect',1,0)

[Frank_Hartmann]

But if both tables should be visible when both field are selected at the same time then use these formulas instead:

Table 1: If(GetFieldSelections(route)='Direct, Indirect',1,If(GetFieldSelections(route)='Direct',1,0))

Table 2: If(GetFieldSelections(route)='Direct, Indirect',1,If(GetFieldSelections(route)='Indirect',1,0))

[soniasweety]

instead of hiding the table 

franky_h79

if i want to show error message  like please select route to show the chart    is this possible?

[Frank_Hartmann · Accepted solution]

Yes, its possible.

Use the calculated condition in General Tab as well as the custom Errormessage on the bottom:

[Frank_Hartmann]

What else do you expect to get a correct answer instead a helpful one?

[soniasweety]

sorry for delay in correcting the answers as i need to test with original app then i can close