Execu/Tech Systems, Inc.
Knowledgebase
Search:
850-747-0581 Email Website
Contents
 
:
IndexBookmarkPrint This Article

Home > Execu/Suite Hotel PMS > Procedures Execu/Suite PMS > Report Generator

This document explains how to use the Execu/Suite Report Generator to export Tab Delimited data that you may import into Microsoft Excel® or other programs.  You also can use this program to print reports. 

You can get to the Report Generator one of two ways:
  • Sales > Report Generator
  • Front Desk Operations > Guest History > Report Generator

              
Enter the dates and sort parameters.  In the "Report to generate" drop-down select "Export TAB delimited text file".   Click Generate Report.




When the file is created you will see a message stating that the file GAHMFILE.TXT has been created.  This is the file you will import into Excel.  The file will be located in your ExecuTech hotel folder on the server.  If you are not sure where this is located, look at your lower left Execu/Suite screen for the path to the hotel folder.




You will launch Excel to import the GAHMFILE.TXT file.  The following instructions and images are general; your version of Excel may be different.  Use the Help feature within Excel if you need further assistance.

In Excel, Select Data > Get External Data > From Text.



At the prompt, enter the file name GAHMFILE.TXT.  The location will be your ExecuTech Hotel folder.  Click Open.




When the import windows open, select "Delimited" and then click "Next".



Select "Tab" and then click "Next".



If you do not wish to import all columns, select "Do not import column (skip)" under "Column data format" options then select columns to skip and click "Next".  When you have the columns you wish to report, select "General" under "Column data format" options and then click "Finish".



You are finished.  You may use the data however you wish within the parameters of Excel.
           


For instructions on report printing and to export XML data for use in Crystal Reports, Microsoft Access, or other XML editor, see:

http://www.execu-tech.com/downloads/userguides/ExecuSuite-Report-Generator.pdf

End of Document






Article ID
 report_generator
Views
 4139
Last Modified
 10/13/2015 12:24 PM