We continue to develop new FastReport .NET functions. Our team is increasingly expanding the features of our library for generating reports. With a recent update, we have added the function of connecting to MsSQL stored procedures. These stored procedures are a set of instructions that are executed simultaneously. Thus, the stored procedures allow you to streamline complex operations and bring them into a single object.
Previously, you could only connect to them via a database query. Now it is enough to use the standard scheme for connecting to database tables.
Procedure icons will be different. Also, if the procedure has input parameters, a window with its parameters will appear when it is selected. In this window, you need to set parameter values if necessary. If you use the default values, then leave the Expression and Value fields empty.
If the procedure returns output parameters, then they will appear in the “Report Parameters” after creating the connection. Such parameters will be updated only when the information is uploaded into the data source.
Calling the procedure from code:
You can find procedures in the list of tables by comparing them with ProcedureDataSource.
Now it will be faster and easier for FastReport .NET users to use pre-prepared data select scripts in several reports.