Overview:
A query is a way to define a custom report in Synergy SIS. A query can pull together any information in Synergy SIS.
- You can save the query so you can run it more than once.
- You can save it as a report so you can schedule it to run in the future.
Open your Synergy SIS screen “QUERY” as we will copy and paste and SAVE a Query report and you can run it yourself for future access. Your personal saved Queries can be found by clicking the OPEN button.
From the Screen QUERY
- click on the TAB “Type in Query”
- CLEAR the contents “COLS” of the Query Box. Then Paste in the entire Query Values that was emailed to you.
- Validate the Query and should get a GREEN OK when Validated.
- Next SAVE this for future Reference complete the following fields before SAVE.
Include steps 4-7 of the screen shot the: NAME (unique), Group (appropriate dropdown type), Output Type, and Description. And lastly SAVE.

To RUN or VIEW a Query Report click on the “Execute” button, first run Query in “HTML” File type to VIEW Results, then can select a different File type for Printing.
NOTE: .pdf results view/print differently than Excel (XLS), Excel has the benefits of sorting/filtering options.