Sometimes for the report creation there is a necessity to use stored procedures that are stored on the database server. Stored procedures can have one or more input parameters. As a result of their execution you can get one value as well as the whole data set (for example, the result of the execution of the internal expression «SELECT»).

Program XL Report Builder allows to call stored procedures and to use the result of their execution during the report execution process. For this you should use the following code in the SQL property of any object Query:

SELECT * FROM ProcedureName(Parameter1,…,ParameterN);

In this example ProcedureName is a name of the stored procedure, Parameter1,…,ParameterN are input parameters of the procedure (if there are any). To specify in the file-template where to output the result of the procedure execution in the future report, you should know what values this procedure returns.

If, for example, object Query1 calls a procedure Proc1, which returns columns Column1 and Column2, then for output of these values into the report you need to use formulas:

«=Query1_Column1»

«=Query1_Column2»

At calling of the stored procedures you can use usual constants as well as report parameters, described in the object Parameters, qua procedure parameters. For this you should put a colon before the parameter name in the SQL-script. For example:

SELECT Column1,Column2 FROM ProcedureName(:Param1,:Param2);

Parameters Param1 and Param2 can be usual parameters as well as parameters of the «DB Combobox» type.

Unfortunately, among the examples, delivered with the program, there is no example that shows how to call stored procedures at the report execution. It’s because the databases of the dBase type don’t allow to contain stored procedures. But we hope, you won’t have any problems with this.

[ Back to Table of Contents ]