1. Drag and drop a label based menu. The default ‘Orientation’ setting in the ‘General’ tab is “Horizontal”. Change this to ‘Vertical’.

/wp-content/uploads/2013/09/orientation_279749.png

Figure 1 : Label Based Menu Orientation

2. Map the labels to the name of the reports. For example, map the labels to the Excel sheet from B1:B5.

Mapping_labels.png

Figure 2: Mapping labels

3. Keep the following settings for the ‘Behavior’ tab of the Label Based Menu.

  1. Uncheck ‘Always Expanded’. You can keep the ‘Expand On’ option as ‘Mouse Click’ or ‘Mouse Over’ depending on your requirements.
  2. Selected Item as ‘No selection’.
  3. Map the ‘Insert Selected Item’ to a cell say A1 in Excel Sheet.

Behavior_Tab.png

Figure 3: Label Based Menu – Behavior tab

4. Drag and drop a URL button onto the canvas. And type or map the Report URL, specify if the URL should open in the same browser window or new window as shown:

URL-general-tab.png

Figure 4: URL Button – General tab

5. Under the URL button’s ‘Behavior’ tab, map the trigger cell to the ‘Insert Selected Item’ cell of the Label Based Menu i.e. cell A1. Also, map the ‘When Value Becomes’ cell to the corresponding Report label which you want to trigger on clicking the label of the ‘Label Based Menu’.

URL-Behavior.png

Figure 5: URL Button – Behavior tab

6. Since, we do not need to explicitly show the URL button, we can make it invisible by not showing the button background and the label as shown:

URL-appearance.png

Figure 6: URL Button – Appearance tab

URL-label-unchecked.png

Figure 7: URL Button – Appearance tab (Text)

The label based menu’s label when clicked triggers the appropriate URL.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply