Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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!
Hi.
I made a blunder...:P
Rectified that one.
Thanks for the quick reply.