The Output Results tab enables you to tailor the output of your query. For each query you can:
- Generate a report
- Export the query to a file as an ASCII text file, for use in Microsoft Office applications, or as a data table.
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.
- From the Output Results tab, select Report (Portrait Layout) or Report (Landscape Layout).
- Click Run Query. The Report Setup dialog box opens.
- Select the Output Direction.
- To preview the report, select Preview.
- 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.
- Click Start Report.
Page Preview Toolbar
When you are previewing a report, the page preview toolbar enables you to enlarge your view, scroll the pages, and print the report. You can see the button’s description as you position your cursor over the button.
The following table describes the buttons on the page preview toolbar.
| Button | Description |
|---|---|
|
|
The First Page button displays the first page of the report. Note: This button is disabled if you are previewing the first page of the report. |
|
|
The Previous Page button displays the previous page of the report. Note: This button is disabled if you are previewing the first page of the report. |
|
|
The Go To Page button lets you select a specific report page to display. |
|
|
The Next Page button displays the next page of the report. Note: This button is disabled if you are previewing the last page of the report. |
|
|
The Last Page button displays the last page of the report. Note: This button is disabled if you are previewing the last page of the report. |
|
|
The Zoom control lets you choose six different magnifications. You can also click your cursor anywhere in the preview window to zoom in or out on a particular area of the report. When you zoom, your cursor changes to a magnifying glass. |
|
|
The Close Preview button closes the preview window and returns to the reports dialog box. Tip: You can also click |
|
|
Click the Print Report button to print the report. |
in the report title bar to close the preview window.
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.
- 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.
- 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.
- 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.
- Click to view the file.