Also write the code for required frequency (daily, monthly, quarterly, etc.) for the report within the stored procedure.Create the stored procedure without any parameters to show the sales figures.Initialize the report parameters at runtime so that it becomes the report with the required frequency (daily, monthly, quarterly, etc.).Create the stored procedure with parameters to show sales figures.If we take a closer look at the example #3 in which the report developer is asked to develop a daily, monthly, quarterly or yearly sales report, the report developer has the following two options to proceed further: Option #1: Example #3Īnother very common professional reports example is when a report developer is asked to develop a daily, monthly, quarterly or yearly sales report then again it is far better to build a database object such as stored procedure or view to embed this logic rather than writing a T-SQL script behind a report dataset although there are few exceptions to this rule. This saves time and implements a more professional approach to reports development unless otherwise stated. One of the benefits of using a stored procedure is a direct reference to the object (stored procedure) in case of any problem with the functionality of the report rather than opening the report going to the dataset and investigating the script in use. If you receive a business requirement that states that the end user is interested in viewing sales for a specified period, you can either use the query-based approach with parameters in the dataset of the report or you can use a stored procedure with parameters to take the value for a specified period.
If you are given a task to develop an SSRS report to show total sales per day, the first thing you need to begin with is a mapping of these requirements to a database object, such as stored procedure, and then bringing it forward to run behind the required SSRS report. We are going to understand this through some simple examples. It is generally recommended to think of the database object, such as stored procedure, and its functionality from meeting the reports business requirements perspective. About SSRS Report based on Stored Procedure This article also highlights the importance of properly coded report stored procedure as compared to a free form of T-SQL script which is harder to maintain over the passage of time. This article talks about creating a professional SSRS report based on a stored procedure to meet the business specification.Īdditionally, the readers of this article will learn how to implement the report procedure correctly to run a report according to its frequency.
0 kommentar(er)
