ComponentOne FlexReport for WinForms
Retrieving Data from a Stored Procedure
Working with FlexReport > Data Binding in FlexReport > Retrieving Data from a Stored Procedure

Stored procedures (or sprocs) can assist you in achieving a consistent implementation of logic across applications, improve performance, and shield users from needing to know the details of the tables in the database. One of the major advantages of stored procedures is you can pass in parameters to have the database filter the recordset. This returns a smaller set of data, which is quicker and easier for the report to manipulate.

You can populate a report from a stored procedure in the C1FlexReport Wizard. To open the C1FlexReport Wizard complete one of the following:

For more information on accessing the Edit Report link, see Design-Time Support.

Populating a report from a stored procedure is no different than using SQL statements or straight tables. In the first screen of the C1FlexReport Wizard, click the ellipsis button to choose a datasource. Then choose a Stored Procedure from the list of available Data sources:

FlexReport Wizard showing Stored Procedures

Select Next and continue through the wizard.

As with loading other forms of data, you have two options: