Back | Forward

How to create a command file to run a report

---

The following parameters must be in effect to create a command file to run a report:

• Report must exist as either a standard report or a user-defined report.

• User must be assigned to a user group that is authorized to execute the report (specified on the Groups Currently Assigned tab of the System Mgmt -> Setup -> Access Rights -> Users screen). Report access rights for user groups are defined on the System Mgmt -> Setup -> Access Rights -> Rights Templates -> Report Access screen.

• File must contain the screen ID of the Queries/Reports -> Query Report Generator screen (i.e., 3005), the report name, and the output destination (such as a file or a printer).

---

To create a command file to run a report, use a text editor (such as WordPad) and complete the following steps.

1. Create a text file in the AppServer directory of FA on the server.
   For example: C:\AssetWorks\FASuite\1507\AppServer

   • This file will be the command file that runs the GUI Report screen
   • Name the file something that will be easy to remember with a .cmd extension
     For example: RunReport_ToPrinter.cmd

2. Type a string in the text file for printing directly to a printer or printing to a file.

   • 3005 <Name of GUI Report>,<Printer Location>,
     • Network location and name: 3005 PR:WO_Detail_Report,\server\hplaserjet,
     • Default Printer specified in Windows: 3005 PR:WO_Detail_Report,WIN,
     • Printer name: 3005 PR:WO_DETAIL_REPORT,hp laserjet
   • 3005 <Name of GUI Report>,<Report Location>,
     • 3005 PR:WO_Detail_Report,C:\Reports\WODetailReport.txt

3. Create a text file in any other directory on the computer.

   • This will be the batch file that runs the command file created in step 2.
   • Name the file something that will be easy to remember with a .bat extension
     For example: RunReport_ToPrinter.bat

4. In the file, type in the following:

   • <Location of the GUI program> username/password <Location of the .cmd extension file> -nohide
     For example: C:\AssetWorks\FASuite\1507\AppServer\fa_gui.exe workstation3:3027 edward/1234 C:\AssetWorks\FASuite\1507\AppServer\RunReport_ToPrinter.cmd -nohide

5. Create a Windows Task Scheduler task that will run the .bat file created in step 4 at a time you designate.