the menu

[#1]

hi, i want to make something like wat i have attached with this.how could i make it??

Thanks and regards

Darshika

[tresB]

May be like attached, using buttons.

[#3]

hi,

thanks for ur reply but i want the left menu like it is mentiomed in the picture.and it should be dynamic like wen i click to it it should show the sub menu under the main menu and wen i click to the sub menu it should show me my desired kpi or graph

[tresB]

Use text box/button and add action to it. For moving to new sheet you can use activate sheet trigger. For sub menu (activating kpi /graph) use conditional enablement for the object againds a variable balue. Use the text box action to set the variable value.

[tresB]

PFA

[#6]

Dear Darshika

use this below code and add list box "TreeMenu"  your menu will be Hierarchy view check this out

Employee:

LOAD * INLINE [

EmployeeID, Name, Email, ManagerID

1, Ahsan, g@co.com

2, Abid, ss@co.com,

3, Kashif, f@co.com,

4, Maria, j@co.com, 1

5, noman, m@co.com, 2

6, kamran, e@o.com, 2

7, zeeshan, e@o.com, 3

]

;

Hier:

Hierarchy (EmployeeID, ManagerID, Name, ManagerName,  Name, TreeMenu)

LOAD EmployeeID, ManagerID, Name, recno() as recno

RESIDENT Employee

;

[amit_saini]

Hi Darshika,

Please see the attachment for "Tree Structure".

Thanks,

AS