Reports

The Reports tool helps users run and configure reports in Lucity Web. Reports are documents that automatically pull information from the Lucity program and display it different ways. They can provide detailed information about one item or a general overview about sets of items.

To launch the Reports tool, click the Reports

button on the toolbar. A list of available reports appears. Each report is listed by name, along with a brief description and a file name.

Users can mark reports as quick reports. This allows to configure how they want a report to run and select it from a list using the drop down arrow next to the

icon on the toolbar.

Note: Reports cannot be run on the Filtered Set if the filter is created on a Comment field.

Note: The Work Order Form (Blank) is a blank Work Order that can be printed and used to enter information about a new or existing work order. It contains no data. If you want to use this Work Order form, print it against a single record, rather than against all records. The report may not run properly if it is run against all records.

At the top of the Report screen, use the Report Group drop-down to select a group.
- By default, this drop-down provides an All Reports option in addition to the list of report groups.
- The window displays only the reports in this module that are related to the selected group.
Select All Reports in the drop-down to once again show all reports for the module.

Select a record in the grid (to run the report against a single record).
OR

Create or load a filter (to run the report against a specific filterset of records).
Click the Reports tool on the toolbar. The Report screen opens.
In the Report screen, select the desired report.
Click the Run button. The following pop-up appears:
Select whether to run the report against:
- All Records - Runs the report against all records in the module.
- Filtered Records - Runs the report against the current filterset of records.
- Selected Records - Runs the report against the selected record.
Select how to view/distribute the report:
- Basic View - Generates the first ##* pages of the report. Users can scroll through the entire document.
- Advanced View - Generates the first page of the report and displays it to the user. Users can page through the report one page at a time, regardless of the number of pages. This view also allows the user to review the report parameters.
- Email Report - Generates a Basic View report and emails it as an attachment to the email addresses the user provides.
If Basic View or Advanced View is selected, the report opens in a new application tab. Enter any user-defined parameters.
If Email Report is selected, the following pop-up appears:
1. Set the list of email addresses to which to send the report.
  - By default, the report is sent to the currently logged in user's email address.
  - Enter an address and click add to add another email address to the list.
  - Click remove next to an email address to remove it from the list.
2. Update the Subject Line on Email if desired.
3. Click OK to send the email with the attached report.

Note: Reports run are logged in the Admin Portal > Web App Management > Application Activity Log. This includes reports run in basic or advanced mode and for email or PDF output.

If the Quick Report is configured to run against a single record, select a record in the grid.
OR
If the Quick Report is configured to run against a filterset of records, create or load the desired filter.
Click the drop-down arrow next to the tool on the toolbar.
Select the desired Quick Report from the list. The report appears in a pop-up window.

Requires the module's Admin - Lucity App Admin - Run permission.

Open the Manage Report Groups tool.
Click Add. The tool displays a Group Name field.
Enter the Group Name. The name should identify the department or user group that the report group pertains to or the nature of the reports in the group.
Click Save.

To add a report to an existing Report Group, select the Report from the grid and click Edit.
In the Optional Report Group field, assign the report to a group or modify its group.
Click Save.

Click Manage Groups at the top right.
Select the desired Report Group from the list.
Click Delete. The following pop-up appears:
Click Yes.
The Report Group is deleted.

To add a new report, click the Add button. The following dialog appears:
Enter the Report Name and Report Description.
In the Subdirectory that Report will be stored in field, enter the name of the folder to which you want to upload the report file.
Note: Reports are automatically uploaded to the location specified in the Admin Portal > Settings > System Settings > Documents > Path where uploaded documents are stored (Internal) (Document Hive) setting.

Note: If the folder name that the user enters does not exist, the system will create a folder with that name within the folder to which the reports are uploaded.
Under Choose File to Upload, click Browse... and select the .rpt file you would like to upload to the web server.
Note: The name of the .rpt file being uploaded cannot match any other .rpt files.
Assign the report to a Report Group (optional).
If this report is run from Crystal Enterprise:
- Check the Run this report from Crystal Enterprise box.
- Enter the CUID for the report in Crystal Enterprise.
Click Save.

To edit a report, select it from the list and click the Edit button.
Enter or change the Report Name or the Report Description.
Assign the report to a group (optional) or modify its group.
If this report should be available from Lucity Mobile check the Available for Mobile checkbox.
If this report is run from Crystal Enterprise:
- Check the Run this report from Crystal Enterprise box.
- Enter the CUID for the report in Crystal Enterprise.
Click Save.

Select the report you wish to update from the list and click Update.
Click SELECT FILES... and select your updated .rpt file.
Click Save. The new copy of the report will be uploaded and replace the existing report file.
Note: The reports that Lucity provides with the software cannot be updated.

Click the Reports tool on the toolbar. The Report screen opens.
Select a report to add to the Quick Reports list.
Click the Add Quick Report button. The following pop-up appears:
Select whether to run the Quick Report against:
- All Records - Runs the report against all records in the module.
- Filtered Records - Runs the report against the current filterset of records.
- Selected Records - Runs the report against the selected record.
Select how to view/distribute the Quick Report:
- Basic View - Generates the first ##* pages of the report. Users can scroll through the entire document.
- Advanced View - Generates the first page of the report and displays it to the user. Users can page through the report one page at a time, regardless of the number of pages. This view also allows users to review the report parameters.
Click Save. The report now appears in the Quick Reports list.

Click the drop down arrow next to the Reports tool on the toolbar.
Click the Add Quick Report button at the bottom of the Quick Report list. A pop-up similar to the following:
In the Report screen, select a report to add to the quick reports list.
Select whether to run the quick report against:
- All Records - Runs the report against all records in the module.
- Filtered Records - Runs the report against the current filter set of records.
- Selected Records - Runs the report against the currently selected record.
Select how to view/distribute the quick report:
- Basic View - Generates the first ##* pages of the report. Users can scroll through the entire document.
- Advanced View - Generates the first page of the report and displays it to the user. You can page through the report one page at a time, regardless of the number of pages. This view also allows you to review the report parameters.
Click Save.
The report will now show up in the quick reports list.


Report Groups Selector	Enables the user to choose a group of reports to view.
Manage Report Groups	Creates and manages report groups. Report groups can be based on department, type of user, type of report, etc.
Reports grid	Lists the reports indicated in the Report Groups Selector. Enables the user to search for a report or filter displayed reports. Click on a column header to sort the records. This icon indicates the column and direction (ascending or descending) by which the data is sorted.
Manage Reports tools
Add Quick Report	Adds a report to the Quick Report list. Quick Reports are the reports an agency uses most often. Click the drop-down arrow next to the button on the toolbar to access Quick Reports.
Add	Adds a new custom report.
Edit	Enables the user to modify an existing report.
Update	Updates the selected custom report with a new .rpt file.
Download	Downloads a copy of the selected custom report's .rpt file. Requires the Reports - Add permission.
Delete	Deletes the selected report.
Close	Closes the Report dialog.
Run	Runs the selected report.