Stored Procedure

Stored Procedure

In the Pro 9 function scheduled reports stored procedures can be used to help making a selection from the database to be used in the report.

Stored procedures are useful when you want to make a dynamic selection, e.g. to generate a report for the previous period, and not have to define a specific period or to generate one report for each cost center and send it to the manager of that cost center. The stored procedures can also be used to dynamically name the report file that is generated by the subscription, to not replace the previously generated report every time a new file is generated.

Stored procedures are always customized for specific customers and reports by technical consultants from Enghouse.