Netherlands: Software

Introductie van Micorosoft SQL Server 2016

Issue link:

Contents of this Issue


Page 150 of 212

138 C H A P T E R 7 | Better reporting Figure 7-18: Assigning data properties to a time navigator mobile report element. Some elements require you to connect two data sets, such as many of the gauge elements that compare one value (the Main Value) to another value (the Comparison Value). You can use the same data set for both values or use one data set for the Main Value and a separate data set for the Comparison Value. Reviewing mobile report elements The Mobile Report Element Gallery in Mobile Report Publisher contains a variety of element types: Navigators A navigator filters data by a time range or by one or more selected values. Gauges A gauge compares a value to a target, numerically, graphically, or both. Charts A chart uses visualizations to summarize a data view by using columns or shapes. Maps A map uses color to summarize data by geographical boundaries or superimposes bubbles representing aggregated data on geographical regions to enable comparisons by area. Data Grids A data grid is a table containing a fixed set of columns and a variable number of rows. It can display data only or, optionally, include delta values or indicators (or both) and a simple chart. Navigators You add navigators to a mobile report to enable filtering by a date or time column or by a column value. There are three types of navigators that you can use to filter elements in your mobile report: Time navigator You use a time navigator to specify a date range to use as a filter for any element in the mobile report that is connected to a data set containing a time-based column. The user can adjust the date range for the filter by using the slider control in the last panel of the time navigator, as shown in Figure 7-19. If there are multiple time-based columns in the data set, the navigator applies only to the first column by default, but you can override this by changing the data set's parameter settings as described in the previous section of this chapter. Figure 7-19: Time navigator displaying data as a column chart. Selection list You use a selection list navigator, shown in Figure 7-20, as another type of filter for the mobile report. This navigator can display a set of values as a list or as a hierarchical tree. You have the option to configure this list to include All in addition to values derived from a key column in a data set that you specify after connecting the selection list to a data set. You also specify which data sets to filter based on the user's selection. Another option is to configure the selection list to allow multiple selections.

Articles in this issue

Archives of this issue

view archives of Netherlands: Software - Introductie van Micorosoft SQL Server 2016