Understanding Running Reports

As PS/nVision runs the report, it does the following:

  • Creates a copy of the layout for each instance of the report.

  • Calls the database to extract information defined in the layout of the report, replacing the selection criteria with specific values.

  • Examines the report request, scope, and accounting calendars to transform PS/nVision variables into values.

Microsoft Excel then performs the calculations you entered on the layout. The finished report—a normal Microsoft Excel spreadsheet—appears on your screen. This spreadsheet is also saved in the directory you specified.

If you produced multiple instances of a report, each instance is saved in the specified directory, all instance are closed except the last instance to save Microsoft Excel memory.