12 Like 0 Dislike
SSRS 2008 R2 -- A demo on Multiple Valued Parameter. This demo also includes on how to create a shared dataset and how to copy and reuse an existing report.
In this video of SSRS Tutorial, You will be learning How to create Stored Procedure with Multi value parameter How to configure Multi value parameter in SSRS Report How to provide values to Parameter by using Query link to the post for Stored Procedure used in the demo Use Stored Procedure with Multi value Parameter in SSRS Report Step by Step SSRS Tutorial by Tech Brothers http://www.techbrothersit.com/2015/07/ssrs-video-tutorial.html
This video explains passing multiple parameters to SSRS reports. Step 1: Populate all parameters with an option for user to select product Step 2: Applying filter to get only those products which has been selected from the Multiple select dropdown list.
Parameter/s in reports are used to filter data. Multi Value parameter is one that can accept more than one value. Let's say if we would like to create report with RegionName Parameter that should be able to accept more than one Region value. Our T-SQL will use IN clause and small parenthesis around Parameter Name. SELECT Col1Name ,Col2Name ,Col3Name FROM dbo.MyTableName WHERE Region IN (@RegionName) We can also write a Stored Procedure with Multi Value Parameter. To create multi value parameter, We need IN clause and each value in IN Clause should have (single quotes) around. When SSRS pass multiple values to parameter, it separate them by comma ( ,). We need to replace the comma with single quotes and comma as you can see in highlighted code. After that we can write our Dynamic SQL Query to use the value of Parameter. Create Procedure dbo.sp_TotalSale @Region VARCHAR(500) AS BEGIN Declare @var_Region VARCHAR(500) SET @var_Region=Replace(@Region,',',''',''') --print @var_Region Declare @SQL NVARCHAR(MAX) SET @SQL =' Select [SalePersonFName] ,[SalePersonLName] ,[ProductName] ,[ItemsSold] ,[SoldPrice] ,[SoldDate] ,[City] ,[State] ,[Country] ,[Region] into ##Temp from dbo.TotalSale where Region in ('''+@var_Region+''')' --Print @SQL Execute( @SQL ) Select * From ##Temp drop table ##Temp END Execute dbo.sp_TotalSale 'Asia,Europe' Check out our website for Different Technology tutorials and interview questions http://www.techbrothersit.com/
Multi - Value Parameter Report, ssrs multiple parameters
ssrs multi value parameter join
ssrs multi value parameter stored procedure
ssrs multi value parameter expression
ssrs parameter multiple values default select all
ssrs multiple parameters not working
how to pass multiple values in a single parameter sql
ssrs display multi value parameter in textbox