The Use of a Stored Procedure in Stimulsoft Reporting Tools (2022)
Channel: Stimulsoft
Date: 2022-07-29

#storedprocedure #reportingtool #sql #dataanalytics 

A stored procedure is a SQL instruction that allows you to execute a set of different queries sequentially. It’s convenient to use when creating reports and dashboards when the same SQL query is duplicated all the time in various data sources. That’s why, for example, when some queries need to be edited, they should be changed in all reports. In this case, it will be logical to create a stored procedure in the storage and just call only this procedure when creating a data source in reports. Flexible use is the first advantage of stored procedures.   

Using a stored procedure increases productivity compared to a simple sequence of SQL instructions. This is because the procedure code is compiled once on the data storage server when it's first running and after it is saved in a compiled form. In addition, the use of stored procedures considerably increases security. Since when calling a procedure over the network, you can see only a call to execute the procedure. The names of table and database objects are not available, and, accordingly, it is much more difficult to perform SQL injections.

This video demonstrates using a stored procedure when creating reports.

0:00 - Introduction: Using Stored Procedure in Reports
1:59 - Stored Procedure with Parameters
3:29 - Variables as Parameters

_____________
You can find examples for various platforms at https://demo.stimulsoft.com

You can also download our product at https://www.stimulsoft.com/en/downloads. 

If you have specific tech questions, please send them to support@stimulsoft.com.

Stimulsoft provides reporting tools and business intelligence components. 
Our software support many technologies and platforms: Javascript, .NET, HTML5, PHP, Wpf, Java, Web, Angular, Blazor, ASP.NET Core, ASP.NET MVC.

You can visualize your business data, using charts, gauges, maps, shapes, barcodes, images and other components.

We offer a vast list of supported data servers – MS SQL, Oracle, Firebird, MySQL, PostgreSQL, NoSQL: MongoDB, and others.

Our reporting tools support Google services: BigQuery, Firebase, Google Sheets, Google Analytics, Online services: Data.World, Quickbooks, and
Azure storages: CosmosDB, Azure SQL, Azure Table Storage, Azure Blob Storage.

We support all standard types of ADO.NET, OData protocol, multi-level business objects. You can get data from XML, JSON, Excel, and other files.