Query Report - How to save a Query

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

  1. click on the TAB “Type in Query”
  2. CLEAR the contents “COLS” of the Query Box. Then Paste in the entire Query Values that was emailed to you.
  3. Validate the Query and should get a GREEN OK when Validated.
  4. 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.