Activate Sheet from List Box

[kerkying]

Hi all,

We are trying to build a home page that contains a list box of report names. There are multiple sheets that contain reports.

We intend to guide the user from the home page to the reports located in different sheets, by having them select the report names (which are values in a field called Report Names). We are trying Field Event triggers and variable triggers with no luck. Does anyone have any clue?

The current inline load looks like this:

Test:

LOAD

[Report Name],

[Tab Number];

LOAD * INLINE [

    Report Name, Tab Number

    Report 1, 1

    Report 2, 1

    Report 3, 1

    Report 4, 2

    Report 5, 2

];

The reports with tab number 1 is supposed to go to sheet 1, while those with tab number 2 is supposed to go to sheet 2.

Attached the QVW for reference.

Thanks all!

[marcus_sommer · Accepted solution]

Maybe like the one within the attachment.

- Marcus

[kerkying]

Hi Marcus,

Thanks a bunch. That was the solution I was looking for!

Just for reference, the solution was to include a Activate Sheet with sheet number = pick(match([Tab Number], 1,2), 'SH02', 'SH03') in Document Properties - Triggers.