Reports and server processes

Ordering reports and server processes

§ Choose the report or server process from the main menu.

§ If relevant, choose the report variant.

§ Define the report parameters. Use the Tab key to move between the fields.

§ Choose the command Save (F12) on the Data menu to order the report.
The report order number is displayed.

§ Click OK to run the report.


If you want to change or remove the ordered run, this is done via the Maintenance of ordered reports window (from AGRESSO Common or the View menu).

Note that you can override an existing setup to change the printer, queue or number of copies when you order the report/server process.


Maintenance of ordered reports

Using the screen Maintenance of ordered reports you can set up, maintain and enquire on the queue of reports and server processes which have been ordered.

If you choose the command Find (F7) in the Data menu, you will see a list of ordered reports and server processes awaiting execution. The search can be restricted or made more general by changing the values in the searchfield. You can also use the Setup search command in the Tools menu, followed by Find in the Data menu to use a more specialised search. The advanced search method will, for example, allow you to search for reports sent to a specific printer.

When you choose the command Zoom in the Data menu, the report order is shown in greater detail in a new screen. Here you may amend the order details such as the printer, queue or number of copies of the report if the report has yet to be run.



Authorisation

Users who have Select access to this screen can only change their own report’s status.0
Users who have Amend access can change the status of any reports.

Explanation of Field

User The user ID of the person who ordered the report or server process.
Report The report number.
OrderNo The order number which was automatically assigned when the report was submitted.
Status Status of the report or server process

N Normal, awaiting execution.
W Working. If Completed is filled out, the report has stopped due to an error. If Completed is not filled out the job is being executed.
T Terminated. The job has been executed and has been completed.
P Parked. The job has been temporarily stopped.
C Cancelled. The job has been permanently cancelled.

P Priority. Each user will be assigned a priority for running each report. The priority may be from 0 - 9, where 9 is immediate. The priority for reports and server processes awaiting execution may be amended by using the Zoom command in the Data menu.
Order date Date when the report was ordered.
Completed date Date when the report was completed. Field filled out on completion.
Queue The server queue in which the report was ordered. Valid server queues are defined in the Server queue screen in AGRESSO System Administration.

The queue can be amended by choosing the Zoom command in the Data menu.


Amendment

If you have authorisation, you can change the report status. The possible changes in status are:

§ From N to P or C

§ From P to N or C.

You can also delete ordered reports by choosing the command Delete row in the Edit menu when the cursor is positioned on the correct row.

NOTE

§ If the report is being printed, it is not possible to use the Delete row command.

§ If the report status is W, the report must be cancelled at server level by ending the task in Windows NT Task Manager®. However, this procedure will cancel all reports currently in the server queue.

To make the changes and deletions permanent, choose the command Save (F12) in the Data menu. If a report is still awaiting execution it is possible to change the printer, report queue and number of copies using the Zoom command in the Tools menu.

Command in the Data Menu

Zoom Zooms to display further detail concerning the submission of the report, and gives the possibility to change printer, report queue, priority and copies.

Command in the Tools Menu

Setup Defines whether a search will run with simple or advanced search criteria.
In simple mode the search is executed using the criteria listed above the table field as limiting criteria for the search.
In advanced mode the search fields above the table are not used and instead a new window is shown when you choose Find (F7). In this window you can enter more advanced search criteria.
Template Uses the row on which the cursor is positioned as a basis for subsequent rows. The template can then be used to enter the information automatically. The column Value shows the template default value. By clicking F you can turn on or off the field as fixed values in new rows. You activate the template by clicking in the lower left hand corner of the field Template.
New rows with data from the template will be displayed when you choose Insert row on the table field.

Print report (local) Prints the report on a local printer.
Print report (server) Prints the report on another printer than your default.
Print log Prints the log file on a local printer.
Show report printout Opens the Select printout window where select the report you want to view and click OK.
Show report log Shows the technical information about the submitted report once it has been run, i.e. the log file if completed, in a flat file format.

Show XML log Shows the technical information about the submitted report once it has been run, i.e. the log file if completed, in XML format.
Show message Shows you the .agm file that displays a brief message about the location of your lis report.

Note

If you want the report files and log files to reside in another location than the default server location, enter a directory in the fields Rep. printout directory and Log printout directory in the Options window.



Report printout

This screen gives you greater control over report printing. It allows you to choose which printer a report is to be printed out on and to take advantage of the full range of options that the printer offers.


Prerequisites

* At least one report or server process must have been ordered with LOCAL as the Printer value in order for you to be able to print from this screen.


Explanation of fields

User The user ID of the person who ordered the report or server process.
Report The report number.
OrderNo The order number which was automatically assigned when the report was submitted.
Filename The name of the report’s output file.
# The sort order for reports and server processes that have more than one printout.
Status The status of the report or server process. Valid values are:

Printed
Ready to print


Amendments

§ Reports cannot be amended in this screen.

Enquiries

§ Enter the search criteria on the search line above the tablefield and choose the command Find (F7) in the Data menu.

Deletion

§ Reports cannot be deleted in this screen.


Commands in the Tools menu

Print report
For .LIS files:
This command prints out the report that the cursor is positioned on.
For .RPT files:
A preview screen for Crystal Report Output is opened allowing viewing and printing.
For all other file types:
Agresso will launch the application associated with the file type. File associations are handled by the operating system, normally by the setup program for the application.
Show report printout
For *.LIS and *.RPT files:
This command displays a print preview of the report that the cursor is positioned on.
For all other file types:
Agresso will launch the application associated with the file type. File associations are handled by the operating system, normally by the setup program for the application.


Commands in the Data menu

Zoom This command allows you to zoom to a print preview of the report that the cursor is positioned on.

Report variants

This window is used to define variants of standard reports and server processes. In each variant you can set your own default values, change parameter names and set fixed values. Parameters with fixed values will then not be shown when the report is ordered.

Detailed information about ordered reports

When the cursor is positioned on a report, the command Zoom can be used to display the details concerning the submission of the report, including the parameters entered on ordering.

If the report is not processed yet (status is N), you may change details such as the printer, queue, priority and number of copies. You can change these values for reports that you have ordered. If you have amendment access you can change details on any report.

Printing the log file

The report log can be printed on any printer that your workstation has access to. You may find it useful to print the report log when for instance the report has stopped because of an error and you wish to document that error.

The prerequisites and the procedures are the same as for printing the report. See Printing the report for a more detailed description.

Printing the report

Reports can be printed on any printer that your workstation has access to.



Security

The function allowing users to see and print the report in this window requires users to have read access to the disk directory for the report printouts on the server.
The user therefore has the opportunity to read all the files in this disk area using other programs in Windows.
Different server queues should therefore be set up where each server queue prints to its own disk area. In this way sensitive information can be shielded.
Sensitive reports should therefore be ordered with their own server queue, e.g. payroll reports should have their own server queue.

Viewing the log file

The command Show report log on the Tools menu allows you to view the report printout log on-screen.
If an error occurred during the running of the report, the log file may indicate the cause of the problem.

To view the full extent of the log file use the scroll bars.

Note that the reports are cleared after a short while. The frequency of this clearance is set by the system parameter CLEAN_UP in the Common parameters window in AGRESSO System Administration.



Viewing the printout

In the Report printout window, the commands Show report printout on the Tools menu and Print Preview on the File menu allows you to view the actual report result on-screen.

The report will be opened in print preview mode. Use the Next Page and Prev Page buttons to view the full extent of the report.

Note that the reports are cleared after a short while. The frequency of this clearance is set by the system parameter CLEAN_UP in the Common parameters window in AGRESSO System Administration.