Thursday, December 10, 2009

Navigation - Dashboard and Answers

In column properties there is a possible option to interact with data or column header and navigate to other report passing also values.

We can use this action in 3 ways:
1. we can navigate from a table through a column header
2. we can do the same thing through the value of a cell in the table
3. we can do it also from a chart.

The navigation can act also as a pop-up menu by entering multiple navigation targets with labels:


Here is is how we can do this:
into the report criteria chose a column to set up a navigation action and enter it's properties ("Column Properties"). There chose the tab named "Column Format" and you'll find out 2 labels called "Column Heading Interaction" and "Value Interaction". In this case we'll chose the value interaction and select from the drop-down menu "Navigate". Hit "Add navigation target" and chose the report to navigate and fill in a Caption for it. Do this multiple times and as a result you'll get a pop-up menu:



For the interaction to work properly, and pass also the values, we should use the same column as a filter and set it up as "is prompted".

To do the same thing with the "Navigate" interaction in a chart, after choosing the same options into the report criteria and filling in the targets in the column properties, we should do it also into the chart properties. To use multiple columns with their values into the target reports, each of the column should have the same targets and caption.

No comments:

Post a Comment