Related topics

Using Secure Query

View Data and Run Queries

Output Results

The Output Results tab enables you to tailor the output of your query. For each query you can:

Generate a Report

Select Report as your output when you want to view or print copies of your query in a report format. Reports are formatted for standard 8 1/2-by-11-inch paper with a half-inch margin on all sides. Portrait orients the print vertically and displays a maximum of 6 columns. Landscape orients the print horizontally and displays a maximum of 8 columns.

You can identify each report by the query title. The query title is at the top of each page of the report.

  1. From the Output Results tab, select Report (Portrait Layout) or Report (Landscape Layout).
  2. Click Run Query. The Report Setup dialog box opens.
  3. Select the Output Direction.
  4. To preview the report, select Preview.
  5. To print the report, select Print. If you select to print the report, the Print Options dialog box opens. Select the appropriate options such as page range, number of copies, and name of printer. Note that if you have a PDF driver installed, you can create a PDF version of the report and then send it as an email attachment.
  6. Click Start Report.

Export a Query to a File

Sage HRMS enables you to export or save your query to a file so you can use it in a variety of different applications, such as Microsoft Excel.

  1. From the Output Results tab, select the file format you want to use. The extension in the Filename field automatically fills in according to the File Type you select.
  2. You can change the file name in the Filename field, for example, you may want to add a date to the file name. Enter up to 40 characters for the file name. The filename must contain only alpha and numeric characters, such as alphabetic characters a-z, A-Z, and numeric characters 0-9. Do not use any special characters, such as #, -, @, or punctuation marks.
  3. Click Run Query. When the process is complete, a message displays the total number of records exported to your file, the location of the file, and asks if you want to view file. Sage HRMS exports the file to the \EXPORT directory in your Sage HRMS directory.
  4. Click Yes to view the file.