Running an Active Technologies Report on a Mobile Device
The following image shows a sample active report that is running on an iPad in full-screen web app view.
You can use the icons on the pagination bar of the grid in an active report to:
- Adjust the viewing mode, which can be either full-screen web app view or original active report view.
- Position the pagination bar at the top or bottom of the report.
By tapping the column title of a report, you can access the report column drop-down menu to refine the data in different ways and manipulate the way that you present it.
You can also use the icons on the chart, rollup, or pivot tool bar of an active report to adjust the viewing mode, which can be either full-screen web app view or original active report view.
Adjusting the Views
Tap the Fullscreen View 
icon
to display the report in full-screen web app view mode. Full-screen
web app view means that the report is presented as a gesture-enabled
web app with the features and functionalities customized for mobile
and touch-screen devices. This is the default view for the display
of a report on mobile and multi-touch devices.
In full-screen web app view, tap the Original View 
icon
to restore the report to its original active report view. Original
active report view means that the report is presented as a regular
active report running inside the browser. All the functionalities
of active reports in the desktop browser are intact in this mode,
except the window display option, which is set to Tabs instead of
Cascade by default to accommodate devices with small screen sizes.
Adding an Active Technologies Report or Dashboard to the Home Screen
For easy access, you can add an active report or dashboard to the Home screen of your device. When an active report or dashboard is added to the Home screen, it will create an icon of the report or dashboard. The user can tap the icon to access the active report or dashboard instead of entering its URL in the device browser. When the active report or the dashboard is opened from the Home screen, it will connect to WebFOCUS to retrieve the most up-to-date information. Accessing active reports and dashboards from the icon provides more space to view reports or dashboards on devices with small screen sizes. There will be no browser toolbars to take up screen space.
To add an active report or dashboard to the Home screen on the iPhone and iPad, open an active report or dashboard in the browser and then tap the Action icon at the bottom of the screen. Tap the Add to Home Screen option.
To add an active report or dashboard to the Home screen on Android devices, open an active report or dashboard in the browser and open the menu options. Tap Add shortcut to Home. Depending on your device, you may need to tap Add bookmark first. In this case, go to the Bookmarks list and touch and hold the bookmark you just added to bring up the Add shortcut to Home option.
Hiding and Showing the Pagination Bar and the Top and Bottom Toolbars
In full-screen web app view, you can hide the pagination bar and the top and bottom toolbars of the grid and chart. This is done so that there is more space to view the active reports and charts on devices with small screen sizes.
To do this:
-
Click the Fullscreen View icon to display the report in full-screen web app view, if it is not already in that view.
-
In the grid cell data area or in a chart, double tap to hide the pagination bar and the top and bottom toolbars.
-
In the grid cell data area or in a chart, double tap to show the pagination bar and the top and bottom toolbars.
Navigating Between Pages
To navigate between the pages of an active report:
- Click the Fullscreen View icon to display the report in full-screen web app view if it is not already in that view.
- On the pagination bar, swipe from right to left to display the next page of the report.
- On the pagination bar, swipe from left to right to display the previous page of the report.
Accessing the Report Column Drop-Down Menu
|
How to: |
The following image shows a sample report column drop-down menu for a numeric data column in full-screen web app view.
The menu option Visualize is available only for numeric data. The menu options Show Columns and Show All are available only when there are hidden columns in the report. The menu options Freeze Column and Unfreeze All are available only in full-screen web app view.
Procedure: How to Access the Report Column Drop-Down Menu
- On a run-time tabular report (grid),
tap once on a column title.
The report column drop-down menu is displayed, with a selection of options.
- Tap the desired menu option. An arrow to the right of a menu option means that there is an additional menu associated with that option. The options and their associated menus are described in the topics that follow.
- To remove the report column drop-down menu, tap Cancel.
Sorting Data
You can sort data in any column of an active report in ascending or descending order.
From the report column drop-down menu, tap Sort Ascending to sort the data in ascending order.
From the report column drop-down menu, tap Sort Descending to sort the data in descending order.
Filtering Data
|
Topics: |
On a run-time active report, locate and tap the title of the column that you wish to filter. From the report column drop-down menu, tap Filter or touch the right arrow for the Filter menu option. The Filter menu is displayed, specifying the default filter condition and default values for the selected column in the existing report.
The following image shows a sample Filter menu. In this example, the default condition is Equals and the default value is Alabama. Alabama is the first value in the existing report for the selected column.
The menu retains any previous filters that were applied to this column of the report.
You can:
- Tap Done once to see the result of the default condition and values. The filtered report is automatically generated, and a new Filter tab is appended after the Report tab and any other existing tabs. On the new Filter tab, you can change the default condition and values to customize the filter for your reporting needs.
- You can also tap the Condition and Values drop-down dialog box to change the filter condition or values before tapping the Done button.
- Tap Clear All to remove all the filters that are currently applied to this report.
Using the Filter Tab
The following image shows a sample Filter tab for an active report (grid).
The Filter tab shows all the filters that are applied to the report.
An individual filter applies only to the specific report from which the filter was created or to which the filter was added. You can scroll up and down the list to view all the individual filters.
From the Filter tab, you can do the following.
- Tap a drop-down list to change the filter condition or values. An asterisk next to a value (for example, next to Alabama in the preceding example) means that multiple values define the condition.
- Tap the Delete icon to remove an individual filter from the report.
- Tap Operator: AND to change the condition (operator) between all existing filters from AND (the default) to OR.
- Tap Add Condition to define a new filter.
- Tap Filter to apply a modified or new filter and generate the new report.
- Tap Highlight to apply highlight to the filtered values in the report.
- Tap Clear All to remove all the filters that are currently applied to the report.
Calculating Data
From the report column drop-down menu, tap Calculate or touch the right arrow for the Calculate menu option to display a menu from which you can apply a calculation to the selected column.
The following image shows the Calculate menu for a numeric data column. The calculations that are available on the menu depend on the data type of the selected column: numeric, alphanumeric, or date.
You can do the following:
- Tap a calculation type in the list. A new report is generated on the Report tab. The calculated result for the selected column is displayed at the location in the grid specified in the WebFOCUS report procedure. Depending on the size of the screen that you are using, the calculated result may be displayed over two lines.
- From the report column drop-down menu, tap Calculate and then tap Clear to remove the calculation that was last applied to the report.
- From the report column drop-down menu, tap Calculate and then tap Clear All to remove all the calculations that are currently applied to the report.
Viewing Data as a Chart
|
Topics: |
When you run an active report on an iPad, you can tap Chart from the report column drop-down menu and tap the right arrow, or touch the right arrow for the Chart menu option to display a menu that specifies the default value for the type of chart that will be displayed and the default aggregation (calculation) that will be used to draw the chart. Also listed are the columns that are available for display on the X-axis of the chart (the Group By columns).
The following image shows a sample Chart menu. In this example, the default chart type is Bar and the default aggregation is Sum, for the selected numeric data column. Columns that can be displayed on the X-axis (Group By columns) are listed on the menu.
You can access the same menu from the Advanced Chart icon at the bottom of the screen if you are already in a chart in full-screen web app view. This menu and icon apply to the WebFOCUS HTML5 chart engine (ARGRAPHENGINE=JSCHART).
Tap a Group By column for the X-axis to automatically generate a chart that is the result of the default values and the selected X-axis column. The chart is displayed in tab view, with a new Chart tab appended after the Report tab and any other existing tabs.
The chart is generated in full-screen web app view by default, if you are in that view.
Alternatively, you can tap the Chart Type menu to change the chart type or tap the Aggregation drop-down menu to change the calculation type, before selecting the Group By column to generate the new chart.
Tapping the Chart Type menu displays the Chart Type options, as shown in the following image.
You can now tap a category, such as Pie, and then tap the Donut chart type that will be used to display the chart. The following image shows some of the charts in the Pie category.
If you are using the WebFOCUS Mobile Faves for iOS app, it may take a moment for the chart types in a chart category to be displayed. There is no JavaScript engine that renders JavaScript faster inside the iOS app, and JavaScript cannot take advantage of features such as hardware acceleration.
On the new Chart tab, you can change the values to customize the chart for your reporting needs. You can also manipulate the way that you present the data.
Using the Active Technologies Chart Menu
The active chart menu and its submenus allow you to change the columns used in the chart or rollup table or select multiple columns from those available in the report, including hidden and NOPRINT columns.
The following image shows the active chart menu.
You can:
- Tap New to create a copy of the same chart on a new Chart tab.
- Tap Original View or Fullscreen to display the chart in the desired viewing mode.
- Tap Group By (X) to change the column selected for the X-axis (the Group By field) or add any column available in the report, including hidden and NOPRINT columns. On the Group By (X) submenu, values used in the existing chart are displayed at the top of the column names and are selected (checked) by default. A newly selected X-axis column is displayed at the top of the column names and is checked.
For a bar chart, tap Stacked to create a stacked AHTML bar chart.
The following image shows a sample Group By (X) submenu. The column Product Type is used as the X-axis in the existing chart.
Tap once to select an additional column, or tap again to deselect the column. Once you select or deselect a column, the Chart tab displays the modified chart, reflecting all the changes.
- Tap Add
(Y) to change the column selected for the Y-axis or
add any column available in the report, including hidden and NOPRINT
columns. On the Add (Y) submenu, the values used in the existing
chart are selected by default.
The following image shows a sample Add (Y) submenu. The column Cost of Goods is used as the Y-axis in the existing chart.
Tap once to select an additional column, or tap again to deselect the column. Once you select or deselect a column, the Chart tab displays the modified chart, reflecting all the changes.
Viewing Data in a Rollup Table
|
Topics: |
Tap Rollup or touch the right arrow for the Rollup menu option to display a menu that specifies the default aggregation (calculation) that will be used to generate the rollup table. Also listed are the Group By columns that are available for display in the rollup table.
The following image shows a sample Rollup menu. In this example, the default aggregation is Sum for a numeric data column. The available Group By columns are listed on the menu.
Tap a Group By column to automatically generate a rollup table that is the result of the default aggregation value and the selected column. You must select at least one Group By column. After you select a column, the rollup table is displayed in tab view, with a new Rollup tab appended after the Report tab and any other existing tabs.
The rollup table is generated in full-screen web app view by default, if you are in that view.
You can also tap the Aggregation drop-down menu to change the calculation type before selecting the Group By field to generate the new rollup.
On the new Rollup tab, you can change the values to customize the rollup table for your reporting needs, making it more complex as required for analysis. You can also manipulate the way that you present the data.
Using the Rollup Tab
|
Topics: |
The following image shows a sample Rollup tab.
Beneath the rollup table is the chart or rollup tool bar, which contains the icons described in the following table.
|
Icon |
Name |
Description |
|---|---|---|
|
|
More Options |
Displays the active chart or rollup menu. For details, see Using the Rollup Menu. |
|
|
Column |
Changes the report to a column chart. |
|
|
Pie |
Changes the report to a pie chart. |
|
|
Line |
Changes the report to a line chart. |
|
|
Scatter |
Changes the chart type to scatter. Scatter charts are available for numeric columns. |
|
|
Rollup |
Displays the chart as a rollup table. |
|
|
Advanced Chart |
Opens the chart tool to change the chart type. |
|
|
Original Chart |
Restores the current chart type to the initial chart type that was displayed. |
|
|
Lock/Unlock |
Freezes the chart or rollup table. You can link or unlink a chart or rollup table to the filters that you have applied in your report using the Freeze Chart or Freeze Rollup icon. The icon indicates whether the report is linked to the filter (Freeze Chart or Freeze Rollup) or not (Unfreeze Chart or Unfreeze Rollup). |
|
|
Aggregation |
Changes the aggregation method. |
Using the Rollup Menu
The rollup menu and its submenus allow you to select multiple columns from those available in the report, including hidden and NOPRINT columns.
The following image shows the rollup menu.
To access the Rollup menu, tap the More Options 
icon
with a rollup table open.
You can:
- Tap New to create a copy of the same rollup table on a new Rollup tab.
- Tap Original View or Fullscreen to display the rollup table in the desired viewing mode.
- Tap Group
By (X) to change the column selected for the X-axis
(the Group By field) or add any column available in the report,
including hidden and NOPRINT columns. On the Group By (X) submenu,
the Group By column used in the existing rollup table is displayed
at the top of the column names and is selected (checked) by default.
The following image shows a sample Group By (X) submenu. The column Product Type is the Group By column for the existing rollup table.
Tap once to select an additional column, or tap again to deselect the column. Once you select or deselect a column, the Rollup tab displays the modified rollup table, reflecting all the changes.
- Tap Add
(Y) to change the column selected for the Y-axis or
add any column available in the report, including hidden and NOPRINT
columns. On the Add (Y) submenu, the Y-axis column used in the existing
report is selected by default.
The following image shows a sample Add (Y) submenu. The column Cost of Goods is the Y-axis column for the existing report.
Tap once to select an additional column, or tap again to deselect the column. Once you select or deselect a column, the Rollup tab displays the modified rollup table, reflecting all the changes.
Viewing Data in a Pivot Table
|
Topics: |
Tap Pivot (Cross Tab) or touch the right arrow for the Pivot (Cross Tab) menu option to display a menu that specifies default values for the aggregation (calculation) that will be used to generate the pivot table, the column that will be displayed across the pivot table, and the Group By column that will be used to generate the table.
The following image shows a sample Pivot Tool menu. In this example, the aggregation is Sum (default for a numeric column), the Across column is Product Type, and the Group By column is Region. A pivot table requires at least one across column and one Group By column. The first value for the column in the report is displayed by default.
Tap Done once to see the result of the default values. The pivot table is automatically generated in tab view, and a new Pivot tab is appended after the Report tab and any other existing tabs.
The pivot table is generated in full-screen web app view by default, if you are already in that view.
On the new Pivot tab, you can change the default values to customize the pivot table for your reporting needs, making it more complex as required for analysis.
Using the Pivot Tab
The following image shows a sample Pivot tab.
Beneath the pivot table is the active pivot tool bar, which contains the icons described in the following table.
|
Icon |
Description |
|---|---|
|
|
Displays the active pivot menu. For details, see Using the Pivot Menu. |
|
|
Freezes the pivot table. You can link or unlink a pivot table to the filters that you have applied in your report using the Freeze Pivot icon. The icon indicates whether the report is linked to the filter (Freeze Pivot) or not (Unfreeze Pivot). |
|
|
Changes the aggregation method. |
Using the Pivot Menu
The pivot menu and its submenus allow you to select multiple columns from those available in the report, including hidden and NOPRINT columns.
The following image shows the pivot menu.
You can:
- Tap New to create a copy of the same pivot table on a new Pivot tab.
- Tap Group
By (X) to change the column selected for the X-axis
(the Group By field) or add any column available in the report,
including hidden and NOPRINT columns. On the Group By (X) submenu,
the Group By and Across columns used in the existing pivot table
are displayed at the top of the column names and are selected (checked)
by default. You can switch Group By and Across columns using the arrow
icons in the pivot table at run time.
The following image shows a sample Group By (X) submenu. The Product Type column is used for the Across column and the Region column is used for the Group By column in the existing pivot table.
Tap once to select an additional column, or tap again to deselect the column. Once you select or deselect a column, the Pivot tab displays the modified pivot table, reflecting all the changes.
- Tap Add
(Y) to change the column selected for the measure field
to any column available in the report, including hidden and NOPRINT columns.
On the Add (Y) submenu, the measure column used in the existing
report is selected by default.
The following image shows a sample Add (Y) submenu. The column Cost of Goods is the measure field for the existing report.
Tap once to select a column, or tap again to deselect the column. Once you select or deselect a column, the Pivot tab displays the modified pivot table, reflecting all the changes.
Using Data Visualization
Tap Visualize to add or remove visualization bars to the selected column. The Visualize option is available for numeric data columns.
Hiding or Restoring a Column
Tap Hide Column to suppress the display of the selected column in the report.
Tap Show All to restore all the hidden columns to the report.
Tap Show Columns to list the names of the columns that are hidden in the report, allowing you to individually restore a column.
Tap the name of a specific column in the hidden columns list to restore that column to the report.
The Show All and Show Columns options are available only when there are hidden columns in the report.
Freezing or Unfreezing a Column
Tap Freeze Column to freeze the selected column and all the columns to the left of it. You cannot scroll left or right within the frozen part of the report, but you can scroll up and down within the frozen part. You can scroll in any direction in the unfrozen part of the report.
Tap Unfreeze All to unfreeze all the frozen columns in the report.
In full-screen Web app view, the column titles and report headings will stay fixed as you scroll through the report when the Freeze Column option is turned on.
Controlling the Number of Records Per Page
Tap Show Records or touch the right arrow for the Show Records menu option to list the groups of records available for display per page in the report. On the Show Records menu, you can:
- Tap a group of records (for example, 20 Records) to display, per page, only the number of records in that group.
- Tap Default to display the number of records (lines) per page that is specified in the WebFOCUS report procedure.
- Tap Show All to display all the records in a single page.
Restoring a Report to Its Original State
Tap Restore Original to restore the active report to its default state specified in the WebFOCUS report procedure.
Unsupported Menu Options
The following menu options are not supported by Active Technologies for mobile web apps.
- Comments
- Send as E-mail
- Save Changes
- Grid Tool
- Chart/Rollup Tool
- Pivot Tool
- Export and Export to for a chart
- Window
- Accordion
Note: Active cell menu options are not supported (for example, Comments, Highlight Value, Highlight Row, Unhighlight All, and Filter Cell).
| WebFOCUS | |
|
Feedback |