Reports Admin - Managing Reports


25Live Reports offers an administration area for users to perform report management functions such as:

  • Defining custom reports for use in 25Live
  • Copying existing standard and custom report definitions as the basis for creating new custom report definitions
  • Editing custom report definitions
  • Deleting custom reports from 25Live

Getting To Reports Admin

The More menu in the upper right of the application has the link to Reports AdminImage: The More menu in the upper right of the application has the link to Reports Admin.

Go to the Reports Administration area in the More menu. Use the Navigate to link to reveal options, then choose Reports Admin. From there, choose whether you wish to manage or schedule reports.

Report Administration includes both managing and scheduling reportsImage: Report Administration includes both managing and scheduling reports.

Viewing Existing Reports

All of your existing reports are shown in pages of results. This includes the standard reports which come with 25Live as well as any custom reports you've defined.

Filtering Your View

Filtering options are at the top of the list or grid view of reportsImage: Filtering options are at the top of the list or grid view of reports.

Type any keywords found in the title of a report into the Filter By Report Name to show only reports that match your keyword.

You can also use the dropdown menu to filter reports by their group (event, location, organization, etc) or type (standard or custom).

List View

The list view is the default on wide displaysImage: The list view is the default on wide displays.

The List View is the default view on desktop and wider tablet views. You can tap or click on the column headings to sort the list. The Actions column has links to manage each report, including View and Copy for standard reports and  Edit, Copy, and Delete for custom ones.

Viewing a report allows you to see its parameters and other details that make it function in 25Live. You cannot edit these details unless the report is a custom one, but they are a useful reference point when defining your own custom reports. You can copy both standard and custom reports to pre-fill all these details in a newly defined report instead of starting from scratch as described below.

Tip

The object security functionality and ability to determine which groups could run reports are available in Series25 Group Administration.

Grid View

The grid view is convenient for mobile devicesImage: The grid view is convenient for mobile devices.

Mobile views will use the grid view by default, or you can switch to this view on wider displays using the Grid View button at the top of the list.

In this view, information is compacted into labeled blocks. You can tap or click on any bolded label to sort the blocks by that label.

Action links are at the bottom of each block, allowing the same actions described above.

How to Define a New Custom Report

In order to add a custom report to 25Live, you must first create and upload the report file. We recommend using the 25Live Interactive Report Designer and following the instructions on that page.

Once you have uploaded this file, you can use it to define a custom report in 25Live Reports using the instructions below.

1. Start a New Report Definition

Screenshot of the report list with the Add and Copy actions circledImage: Define reports by copying an existing report or starting a new one.

Click the Create button in the top right of the screen to open a window to define a new report.

Clicking Copy on an existing report will open the same window but fill out the fields and parameters based on the original, giving you a head start on the next steps.

2. Complete Name, Engine, and Group Fields

Screenshot of the report definition window with required fieldsImage: Fill out all fields to define a new report.

Define the report by giving it a Name and choosing which Report Group it will appear in. Users will see these fields when running the report.

You must also enter the File Name of the file uploaded to the report server and select the Report Engine (WebServices or Interactive Reports) corresponding to that file. Include the extension (.xls for WebServices and .cls for Interactive Reports) in the filename.

3. Add Report Parameters

Screenshot of the parameters for a new report, highlighting the buttons used to change display orderImage: Add new parameters for the report and change their display order.

For each input parameter specified in the custom report file, you must define a Parameter for the report in 25Live. Users will select values for these parameters when running the report.

  1. Click New Report Parameter.
  2. Enter the parameter Name as you want it to appear to a user.
  3. Choose the parameter’s Data Type from the drop-down list. (See below for an explanation of data types.)
  4. From the Field Mapping drop-down list, choose the field in the RPT_PARM_VALUE record where the user-supplied value for the parameter should be stored.
  5. If you chose “Object” as the parameter’s data type, choose the object type from the Validation drop-down list.
  6. If the user must enter a value to run the report, select “Yes” for Value Required.
  7. Repeat these steps to define additional parameters.
  8. Use the up and down arrows to set the order that parameters will appear when a user runs the report.

4. Save the Report

Report creation success messageImage: Report creation success message.

Click Save Report to add the report definition to 25Live. You will see a green success message in the bottom of the screen.

5. Define Report Security (Optional)

A newly created report will use the default object security settings to determine who is allowed to run it. To edit these permissions for an individual report, change its security settings in the Series25 Group Administration Help.

Deleting a Report

The standard reports which come with 25Live cannot be deleted, but you can remove any custom report from 25Live by clicking the Delete link next to its name.

Deleting a report definition in 25Live does not remove any files uploaded to the custom report server. You can create a new report definition using the same file.

To hide a report from users without deleting it (such as you might wish to do with a standard report), change its security settings in the Series25 Group Administration tool.

Data Types for Report Parameters

Most reports in 25Live use parameters so that users can narrow down what is included in the results. For example, users may need to supply a date range, a number, or a saved search as a parameter.

When defining a custom report, you must choose the data type of each parameter. This should correspond to the data type of the variable used in the report file.

Most parameters are commonly marked as required fields, but sometimes (depending on the report and the variable) this is not necessary.

If a parameter's type is...The user generating the report must...
StringEnter alphanumeric text (maximum 80 characters)
IntegerEnter a whole number
FloatEnter a number that may include a decimal
DateEnter a date
TimeEnter a time
Date/TimeEnter a date and time
DurationEnter a time duration (days/hours/minutes)
BooleanSelect Yes or No
SearchSelect an existing event, location, organization, or resource search
ObjectSelect an organization, contact, requirement type, or organization type