Saving Queries

Save your Queries in the Property Shares Folder. There is a sub-folder named "SQL Queries" which consists of some SQL Examples that you can learn from. Please be aware that these queries may be overwritten during updates so if you do use them, save them as a different name.

If you write your own queries, it is recommended to prefix them with some indicator so you know which queries come with the system and which ones are yours. For example, you may want to call all your queries "myhotel_xyzquery.sql"

While creating an Embedded SQL Report may seem complicated at first, or not as powerful as a Report Wizard, you can quickly learn that this is not the case. SQL Queries are very powerful and you can actually create reports that span multiple tables, create sub-totals, totals and grand-totals as well as cross-tabs and pivot tables. You can also Union (combine) two different files together which you cannot do in the Report Wizard.

For more information on the SQL Wizard as well as saving SQL Wizard Specifications, click here.