Stored Procedure: Difference between revisions
Jump to navigation
Jump to search
(Created page with "<translate> === Stored Procedure === In the Pro 9 function [[{{Link}}Agent_PushReportSubscriptions|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...") |
(Marked this version for translation) |
||
| Line 1: | Line 1: | ||
<translate> | <translate> | ||
=== Stored Procedure === | === Stored Procedure === <!--T:1--> | ||
<!--T:2--> | |||
In the Pro 9 function [[{{Link}}Agent_PushReportSubscriptions|scheduled reports]] stored procedures can be used to help making a selection from the database to be used in the report. | In the Pro 9 function [[{{Link}}Agent_PushReportSubscriptions|scheduled reports]] stored procedures can be used to help making a selection from the database to be used in the report. | ||
<!--T:3--> | |||
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 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. | ||
<!--T:4--> | |||
Stored procedures are always customized for specific customers and reports by technical consultants from Enghouse. | Stored procedures are always customized for specific customers and reports by technical consultants from Enghouse. | ||
Latest revision as of 08:45, 2 March 2023
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.