Report access

[santhosh_k_n]

Hi All,

I am having two columns which represents reports type(each type in separate sheet) and report name.

Now i need to open the sheet of respective report type on clicking the report name. Both fields are placed in a table box in home page.

Report type	report name	sheet ID
Type1	report1	sheet2
Type1	report2	sheet2
Type1	report3	sheet2
Type2	report4	sheet3
Type2	report5	sheet3
Type2	report6	sheet3
Type2	report7	sheet3

Sheet1 is the home page and sheetID is not a field just for reference.

Currently I am applying field event trigger on Report type

if(GetFieldSelections([Report Type])='Type1','SH02',   

if(GetFieldSelections([Report Type])='Type2','SH03'))

Please suggest to navigate to the respective sheet from clicking on the report name, making all other reports in the sheet expcept the report selected should be hidden and only the selected report to be visible.

Thanks all