Query Admin

Click Group ,Type and/or Include Product Owned to select options to filter queries in view, if desired.
Click on line of desired query to view. Query screen displays. Query may be edited in detail from this screen, if desired. Close Query screen when finished.

Edit directly in Name and Description if desired. Description should include any special instructions on how to customize report before running it.
Click to spell check.
Click for additional space.
It is NOT recommended to change Type . Select type displays the data from the database for reports, but Update, Delete or Insert makes direct changes to the database and should only be attempted by experienced users.
Output Type displays the default format for query. It can be changed to any of the following :
- TIFF Image is a graphics file.
- CSV is a comma-separate values file.
- Excel is a Microsoft Excel version 1997-2003 format file.
- HTML is a web page in the standard Synergy SIS format.
- PDF is a Portable Document Format for Adobe Reader.
- Rich Text is a document file, basically Microsoft Word format.
- Text File is a plain text file with no formatting, in tab-delimited format.
- XML is an extensible markup language file.
User Name indicates who created the query, and cannot be changed.
Product Owned displays Yes if query came with Synergy SIS and No if user-created. Product Owned cannot be changed.
Group , used to categorize queries to make them easier to find, may be changed.
Click or .

Delete Query

Public Queries: