Similar to fetching data from a database table or view for reports, you can also fetch data using the stored procedures in the database. Canvas Studio enables you to create reports by configuring stored procedure for pre-computation. You can also pass parameters to the stored procedure, so that filtration of data can be done based on the passed parameter value(s).
Prerequisites
To create a stored procedure datasource, you must have already created a connection in Canvas Studio to the database where the stored procedure is available. Refer Create a Database Connection – 19.1 for more information on creating a connection.
Refer the following pages:
| Page Tree | ||
|---|---|---|
|