Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Name

  • Template – This is the Report Template that the report is based on.

  • File ID

  • Report – If the Output Type is Spreadsheet, you will be able to Download or Preview the report file. If it is Interactive, selecting View Report will open the Interactive Report in PICSWeb.

  • Output Type – This indicates whether the report was run as a Spreadsheet to download or as an Interactive Report, which can be viewed and customised within PICSWeb.

  • Created – This shows the date and time that the report was generated.

  • Report Exported to Azure – If the Output Type is Spreadsheet, selecting this will download the report in an Excel Spreadsheet format. If it is Interactive, selecting this will open the Interactive Report in PICSWeb.Date – This shows the date and time that the report was generateda tick is shown for the report underneath the cloud icon, this report has been Exported to Azure Storage.

  • Created by Schedule – If a tick is shown for the report underneath the clock icon, this report was generated according to a Report Schedule rather than run manually.

  • Overwritten Output – If a tick is shown for the report underneath the pin icon, this report is a Scheduled Report that will be replaced by a new instance the next time it is automatically run.

  • Interactive Output for Dashboards – If a tick is shown for the report underneath the graph icon, then the report is being used as the data source for a Dashboard.

Filtering the List

The options to Search by name and filter by Number of Records are available above the list. Once you have applied any filters, press Enter or select the Search icon to run the search and apply your filters.

...

Selecting Download by a report in the list will save the report to your device in an Excel Spreadsheet format.

For Interactive Reports, select View Report will open the pivot chart.

As well as this, selecting ... > Deleteby a report in the list will show the following details:

  • Load Options – This will open the Set Up Report Window with all the options set to match the selected report. From this window, you can modify any necessary options before saving the report or running it again.

  • Delete – This will remove the report from the page. You will be prompted to confirm before the report is deleted. 

...

...

Viewing Running Reports

If you have Database Administrator User Permissions, a button to View All Running Reports will be available in this page to show all reports that are being generated for all users.

...

In the running reports window, you can view report details and abort any slow reports by selecting … > Abort. If you abort a report, the user who ran it will be notified by email.