Sheet Trigger

[#1]

Hi,

I have a report with 4 sheet.

1)Home

2)ETL

3)Summary

4)Detail

In my home page sheet, i have added 3 text objects for the Sheets ETL,Summary and Detail to get triggered.

In ETL text object, i added action as

Set Variable=vETL

Activatesheet=ETL but it's not working.am i missing out something here?

Thanks.

[MK_QSL · Accepted solution]

What is your objective?

Do you want to click on text object for respective sheet to be appeared?

if it is then go to properties of respective text object

Go to Actions

Layout

Active Sheet

Write down Sheet ID ...

Sheet ID you can get from

Right Click Empty Space of any sheet

Properties

General

Sheet ID

[trappersw]

You only need one of the actions, not both, but you need to configure them.

Go to your sheet ETL and add in the properties of the sheet (tab General) the following:

ShowSheet

Conditional=Variable='vETL'

You can remove the trigger 'Activate Sheet ETL'

OR

Instead of Activate Sheet: ETL you use the sheetID of this sheet (for example: SH03). You can find this ID in the top right corner of the properties menus of the ETL sheet (tab General).

Now you can remove the former trigger.

Hope this helps!

[#4]

Hi.

I made a blunder...:P

Rectified that one.

Thanks for the quick reply.