Skip to main content

Modifying Views Reports


Modifying Views Reports

Overview

To modify a report, select the Create/Modify link from the Action Links list.

Report Wizard

When creating or modifying a view/report, the Report Wizard page will appear.

The first page of the Wizard allows you to select an operation. You will be able to specify:

OptionsDescription
Create a New Report/ViewCreate a single report/view
Edit an existing Report/ViewModify an existing report/view
Create Multiple Reports/ViewsCreate multiple views in a single operation

Modify a Report

To modify a report, select the Edit an existing Report/View operation on the first page of the Report Wizard.

To modify a report, you must select the report from the Reports drop list.

When modifying report, you will be able to specify the following:

OptionDescription
Report NameSpecify a name for the report
DescriptionDescription of the report (for search purposes)
TypeEither database view or database report
View NameWhen creating a database view, you must provide a view name

Once all options are set, click the Next button on the Toolbar.

Field Seletion

When creating or modifying reports, you will be able to select the fields that will appear in the reports/views.

To include a field in the report, click field hyperlink.

Fields will be listed in the order you select them from the list.

You can adjust the field order by hovering over a field and using the Up and Down icons.

You can remove a field by hovering over a field and using the Delete icon.

ou can remove all fields using the Remove All icon.

When selecting fields, the ViewManager will allow you to include an "Object Link" field.

If this field is included in the view, the view will contain a field that includes a URL (link) to the Item form in Desktop.

For each field in the list, you will be able to specify a field alias. The alias will be the name that will appear in the view/report and not the actual Empower field name.

You can sort each field in the report by selecting the sort drop list (you can choose either Ascending [Asc] or Descending [Desc] order).

When creating multiple views, the ViewManager will provide an option to automatically select which attribute fields to include.

When this option is checked, the system will determine which attribute fields are in use by the items that will be included in the report and only include those attribute fields.

Once all fields have been selected, click the Next button to specify any additional parameters.

Parameters/Options

When creating or modifying reports, the last page of the Report Wizard will allow you to specify additional report parameters and options.

To add a parameter, select the Add button in the Parameters section.

The Add Parameter panel will present you with a list of available fields that you use to filter your results.

To add a filter, specify the field and value and then click the Add button. The limiting/search fields will appear in the Parameters list.

When creating multiple views, you can base the views on Item Type, Category, or Attribute field values.

FieldDescription
TypeA separate view will be created for each Item Type value used by items.
CategoryA separate view will be created for each Item Category value used by items.
AttributeA separate view will be created for each value of the selected Attribute field.

Once all parameters and options have been selected, click the Create Report button.

The final page will provide a verification check.