Query reports

The Query Reports page lists the query reports of your installation. A query report is built on a database query that TrakIT Support writes for you. It can be previewed at any time, sent on a schedule by email, FTP or an API post, and can ask for parameters, such as a date range.

To open it, select Reports > Query. To compare the kinds of report, see Choose the kind of report.

Select a report in the list to open it on the Query report page, where you preview it, schedule it, choose its recipients and set its parameters.

Which reports you see

System administrators see every query report.
Other users see the active reports, and the inactive reports they own.

In the list, an inactive report is shown in red. An active report that you can’t generate is grey: you don’t own it and the owner hasn’t given you access. Open it to request access.

Find a report

Select Filters to open the filter panel, if it is closed.
Enter or select the filters you need.
Select Search.

The number of matches appears above the list, as Reports Found. Reset clears the filters. TrakIT remembers your filters and the number of rows per page for the next time you open the page.

Filter	Finds
Title	Any part of the report title.
Owner / User	Any part of the name of the report’s owner, or of a user who was given access to it.
Delivery Mode	Email, FTP or API, or — Any —.
Generation Time	Reports whose last generation took longer than the time you choose, from > 10 sec to > 10 min.
Report Status	Active Only or Inactive Only, or – Any –.
Show Accessible Only	Only the reports you own or were given access to. System administrators can generate every report, so for them it changes nothing.
Tags	Reports with the selected tags. [No Tags] includes reports without tags. The check icon selects all or none.

The list

The list shows 20 reports per page, in order of title. Select the Report Title heading to sort the other way. The current UTC time is shown above the list, on the right: report schedules are set in UTC.

Column	Shows
Report Title	The title, with the description under it.
Report Owner	The user responsible for the report.
User Access	How many users were given access to generate the report. Empty if none.
Format	The file format, for example Excel Spreadsheet (XLSX) or HTML In Email.
Zip	Yes if the report is marked to be zipped.
Days	When the report is sent: the weekdays as letters, for example `M_W_F__` for Monday, Wednesday and Friday, or the dates of the month, for example 1,15. Empty if it is not scheduled.
Delivery	Email, FTP or API.
Last Queued	When the report was last added to the report queue to be sent, or -.
Last Sent	When it was last sent, or -.
Last Gen	How long the last generation took, for example 1m 20s. Red when it took more than 3 minutes.
Params	Yes if the report has parameters.
Last Modified	When the report was last changed, and by whom.

Times such as Last Sent show how long ago it was; point at one to see the date and time.

Who can use this page

Section	Permission	Allows you to
Query Reports	Read	Open the page and the query reports listed on it.

What you can do with a report depends on whether you own it or were given access to it: see Query report.