Single value parameter ssrs

Single value parameter ssrs. [Details] 'Monday'. select 'xyz'. Click the fx button next to the parameter value field and then use this expression. END. Aug 22, 2019 · My data set has the following where clause: WHERE a11. -Click the OK button. You need to set up a filter similar to the following: Where the expression is: =IIf(Parameters!FilterColumn. So I recreated Dataset1, but did not use the stored procedure. In a dataset query, query syntax must test for inclusion of one value in a set of values. Mar 30, 2018 · 2. The DataSet for this tablix should be, like you outlined: SELECT *. Then, change your condition to. Count Returns the integer value 1. However, when calling both values, only the first one is returned. Boolean. Pass the multivalue parameter from you parent report as a string using the join method. =Join(Parameters!TerritoryMulti. Value = "Shipments", 1, 0), "YourDataSetName") Remember SSRS is case sensitive so put your dataset name and Field names correctly. When I check only value'2 from multivalue drop down - I see that in SQL Profiler such parameter is passed @Value=N'value''2' -- Two single quotes When I check both values in profiler I see @Value=N'value1,value''''2' -- Four single quotes Sep 14, 2013 · When I use the stored procedure, I can't seem to select multiple values. Length-Parameters!User. First, we need to create a Data Source for the report. Dec 11, 2017 · 0. organization o inner join dbo. Check whether "Select All" is selected. Jan 11, 2021 · I am trying to write a hidden column expression in SSRS. First, let’s look at the defined parameter: So pretty basic stuff here, I have a parameter called ‘CustomerType’ with values for ‘Suspect’, ‘Customer’, and ‘All’. If I pass in a single value from the field, it works, but if I pass a csv list from the field then the report Jul 20, 2016 · There are several ways of doing it. In the case of matching '205' to '20500', you need to pad each parameter value up to 5 characters with zeroes on the right side and match that against the left 5 In this situation the user can manually enter one providerid, which works. Once you click on Add parameters. No space is required before an expression. mean_name, o. com Feb 25, 2012 · Usage of a single parameter value is controlled by two things: 1. Aug 23, 2018 · In the backend, the selected multiple parameter values are passed onto the report stored procedure as one long delimited string as shown in Script 1 . Value,", ") + ")" BEGIN. If you will always only have two values that need selecting, the easiest way of implementing this would be to have two single value parameters labelled as Value 1 and Value 2 which are then both referenced in your report query. Aug 11, 2015 · Or for scenarios where you only wish to process each unique value once, you can just use a DELETE (no need for additional identity attribute): DECLARE @A NVARCHAR(MAX) WHILE EXISTS (SELECT * FROM @Params P) BEGIN. To set "Select All" as the default value, I have made similar changes for both report parameters. You are responsible for splitting these back out into something that you can join on. The following example uses the Join function to concatenate the selected values of the parameter MySelection into a single string that can be set as an Jul 27, 2015 · In the Report Parameter Properties window, make the following entries and selections. Step 5: Look over the report. Dec 11, 2013 · 4. Adding the parameter to the report dataset. Furthermore, they can be populated from a set of constant values or a they can be based off the When testing the multi-value flag directly in the stored procedure: WHERE [Flag] IN ('A', 'B', 'C') The stored procedure works correctly. A multivalued parameter is an array of values. Another reason to let the report create the parameter for you is that it will automatically create another hidden Dataset to populate the available values of the parameter. Feb 18, 2023 · Right-click on the parameter inside the Parameters folder in the Report Data window of the report and choose Parameter Properties. SELECT Id FROM Client WHERE name in (@Name) END. First of all, I would suggest using the Parameter checkbox in the Query Designer and let SSRS build the MDX for you. Using multi-valued parameters Sep 22, 2017 · here is what you can do, you need to handle the query condition formatting and parameter values correctly. Oct 20, 2015 · When you have a multiple select parameter, SSRS should send a comma separated list of values to your stored procedure. See this --> Passing multiple values for a single parameter in Reporting Services. edit: Since SQL Server 2016 you can To add Multiple Parameters in SSRS, right-click on the Parameters Folder present in the Report Data tab will open the Context Menu to select Add parameters. The parameter is populated by a Dataset - sql query. But it does not do this with all the multi-value parameters. =Parameters! <ParameterName SSRS Tutorial 30 - How to create Date Parameters w SSRS Tutorial 29 - How to Create Multi Value Param SSRS Tutorial 28 - Create Single Value Parameter w SSRS Tutorial 27- How to Create Static Values Para SSRS Tutorial 26 - Add Row Number to rows in SSRS SSRS Tutorial 25 - Add Running Total by Group and Mar 31, 2017 · If you make the @Account parameter multi-value, you can simply type each entry followed by [Enter], no commas, just your required value, one on each row of the parameter drop down. Value, ",") In SQL Server, you need a table-value function that can split a comma-delimited string back out into a mini table (eg see here ). Switch to Design view. , '001, 002, 003'). Value="ID","") Click ok. There are many ways to achieve this. Step 3: Modify the value expression for such Dataset parameter. Now that the tablix is bound to the dataset, it will create one row for each record returned from the "dates" dataset, each row will have a Jul 27, 2013 · Set it to 'Hidden'. The database is splitting them into a table of integers then inner joining on the values. For the Available Values and Default Values, point it to the same TableA DataSet, but have it use the CountyID field for its values/labels. You may be interested in the documentation for multi value parameters in SSRS, which states: SELECT ‘ ALL’ AS Layout_Code. When the parameter does not allow nulls, SSRS will not run the report if a value for the parameter is not supplied. To do that you need to add the below codes to the existing datasets: UNION. Aug 27, 2015 · 8. Add a new parameter to the Parameters folder (with name NewParam). 0. Oct 8, 2018 · Add the following filter. DELETE @Params WHERE A = @A. To add SSRS Report Parameters, Right Click on the Parameters Folder present in the Report Data tab will open the Context Menu to select Add parameters. organization_id and i. Put a value in each row. market <> 3 BEGIN. -Select Allow multiple values from the drop-down menu. That SP then uses a split function in the WHERE clause to read the values. which is right on topic, and basically says: Create a new tablix report whose query returns a (unique) set of possible values for the parameter. , "Include". Oct 28, 2019 · I want to set the default of that parameter with a where clause. In a report expression, expression syntax must access an array of values instead of an individual value. I want to set the Default Values as "Select" When I select the No Default Value, the output message I see is is * select a value" Jan 11, 2018 · Again, that’s because we’d use the parameter caption. Make the Parameters on your sub report non-multivalue, remove any 'Available values' set. When I try to run it with a single v Jul 18, 2018 · In SSRS report I have 2 parameters ClassName and StudentName both are allow to select multiple values. Value & Fields(Parameter!ColumnData. =Parameters! <ParameterName> . status You need three things: In the SSRS dataset properties, pass the multi-value param to the stored procedure as a comma-delimited string. May 7, 2015 · The datasets referred by Class1, Name2 and Name3 should contain the value All Selected. Right click on Size report parameter and click on Parameter Properties, it will open the Report Parameter Properties window. Go into the properties for the parameter and select Default Values from the list on the left. [rpt_spDemo] ' Chelsea,Arsenal. Group by that set. Now it displays just Value1 and Value2 in the tablix. You need to pass an array of values to the parameter so try this as the parameter value. Label: Returns the parameter label, frequently used as the display name in a list of available values. edited Jan 25, 2022 at 22:13. This method can pass a parameter but does not hide it as it is visible in the URL. SSRS passes '1,2' into the query parameter to be used in the WHERE clause. May 19, 2017 · This is not possible. Method 2. Displaying a single parameter value is pretty straightforward. =Join(Parameters!Emp_ID,",") The EMP_ID parameter will be set to a comma delimited list, which is what a multivalue parameter sends to the query. Please provide a valid Name, Prompt May 13, 2014 · I'm using SSRS 2008R2 and i try to get single value from dataset to use it as default value of report's parameter. Substring(Parameters!User. Parameter Value to Show or Hide Table Columns. I'm only able to select single values, otherwise the report goes blank. You'd then need to pass the @CountyID parameter into your subreport. Add a couple of parameters in SSRS say, FromDate and ToDate and make its data type as Date/Time. Nov 2, 2015 · How can I limit the number of characters a user can type for a parameter in SSRS? For example, if the Data Type is set to TEXT, how to limit the user to type only 6 characters after Default value of "CL/" OR limit to total of 9 characters. 4. Oct 27, 2020 · In SSRS, I'm trying to setup a parameter query on the dataset with single-value variable (x) and multi-value variable (y). on the report layout view, right click and select parameters from the pop up menu. WHERE PortfolioId IN (SELECT ID FROM #TempTable) EDIT. 7. Feb 28, 2023 · Table-valued parameters are declared by using user-defined table types. Available values - Label and Value are both set to Field1 Default values - Value is set to Field1. Value, ", ") When this gets passed to the stored proc it seems to be passing a string formatted like this: 'U1234, U5678, U6789' Feb 1, 2017 · You would need to change your query in an expression and concatenate the condition using the JOIN expression on your parameter values. Change the parameter order to make Control on the VERY TOP, no matter ID or Name comes for the 2nd, but Control should be in the 1st Jun 7, 2021 · This is a Microsoft SSRS tutorial demonstrating how to filter the options on a parameter based on a value of another parameter. If i am passing one value output is Coming: Like this i am passing: EXEC [dbo]. The report works, but if I change the parameter properties to allow multiple values then I get an error: Query execution failed for dataset 'DataSetDtRcvd'. Value = "Value2". To pass a parameter using Action = Go to URL, set expression to: Be sure to have a space after an expression if followed by & (a line break is isn't enough). Sep 18, 2019 · Create a new Dataset with a query. Click OK when done. . test_table1 where f1 in (?). BEGIN. Value(0) = 3, false, true) Jan 22, 2021 · If I understand correctly, it might perhaps be better to return "All" with your result set and/or add an expression. You’ll see why in a moment. Value,",") At the end of the Main Query I filter the results: Sep 25, 2015 · You will then need to add the parameter in the query designer as you would normally in SSRS. Value). Value but when the parameter is multiple, Parameter!ColumnData. You can specify the default values for these parameters using DateAdd functions and samples give below: Today: =Today() last week from today: =DateAdd(DateInterval. In SSRS a multi-value parameter cannot include a NULL value, so users can't filter the data for NULL values. ssrs. My parameter @POID properties are set to single value. EXEC [dbo]. That's why I use cascading parameter. In the query the WHERE clause will be look like this: I think the better way is to use a Multi-Value parameter and letting SSRS do the actual work. So the problem is not the stored procedure, but how SSRS is passing the multi-valued values to the @Flag parameter. PDPOID LIKE '%' + @POID + '%'. Multiple value parameter ssrs. status = s. Use Reports as Parameter Value. Value) Apr 25, 2018 · The query from SSRS side is like select * from xyz. Your requirements state a need to be able to filter the data for Mar 26, 2015 · Step 1 (B): Add Parameter Dataset. Parameters are able to be utilized for everything from criteria in a query to filters for a Tablix to controlling visibility of objects on a report. Changing the data model may also be a better option if you can do it. Click on the Default Values tab and make the below changes. 1 Answer. Here is an example that may be similar to what you need: SSRS Multi Value Parameter. Value(0)). Instead I just wrote the SQL statement in the text editor, and I'm able to select the multiple values just fine. answered May 7, 2015 at 15:44. or Parameters!FilterColumn. Datasource for me in this case is a hive table. It is possible to have a drop Sep 23, 2014 · I am having a multivalued parameter 'client',i have almost 60 values in the client parameter,my requirement is display the selected client values in the header text box but when i select 'SELECT ALL' option in the parameter i should display just 'ALL' rather than displaying all the 60 values. The default I want to set: SELECT USER_ID, USER_NAME FROM USERS WHERE STATUS = 'ACTIVE' I create 2 separate dataset with the above query, the 1st one is set as the available values, the 2nd one is set as the default values, it could work. Solutions Tried Feb 1, 2012 · According to Microsoft's SSRS help search: =Parameters!<ParameterName>. For a single-value parameter, the count is always 1. 'Value. Value = Fields!Category. IndexOf("\")+1, Parameters!User. union all. Select multiple parameter values from a drop-down list. organization_id = o. SELECT @renderType = REPLACE (@renderType , ',', ''',''') set @script = 'select In order for Select All to be the default option, the Available Values dataset must contain at least 2 columns: value and label. =Fields!MyField. Notice that Allow null value is checked. On some of the parameters the SSRS SP uses the Join(Parameters!field. Let me know if this works, my DAX is a bit rusty! In this video of SSRS Tutorial, You will be learning Create Stored Procedure with Single Input Parameter Use Stored Procedure to create DataSet for Re May 18, 2015 · Your SQL Server Reporting Services (SSRS) report has a multi value parameter, but it doesn't show NULL in the parameter drop down along with the other parameter values. You don't have a dataset for the values associated with the parameter do you? – ShellNinja. Usage of an = within the source query. This is the last line in my Dataset query: WHERE x = ? and y in (@programs) For the Parameter setting of the Dataset Properties: Parameter Name / Parameter Value: @programs / expression: =Join (Parameters!programs. I need to involve a multi-value parameter. Now open the main DAX report query and switch to Jan 22, 2014 · Creating a report with SSRS that iterates over a parameter. ‘Suspect’ and ‘Customer’ both map to actual The stored proc option is best because the SSRS can handle the parameters for stored procs to both SQL Server and Oracle very cleanly, but if that is not an option you can use this expression: ="select column1, column2, a from table A where A. Next, ensure that the “Allow multiple values” check option is selected in the parameter attributes. There is no detail row, but in the group footer/header add a subreport. =SPLIT("Roll,CutSheet", ",") I've just tested this and it seems to work fine. Script 1. Value, ",") In other words, the report is concatenating the values into a comma-separated list. Dataset filled with this query: select distinct o. Mar 27, 2017 · First, after users choose @time_from and @time_to, the other parameters will be enabled. If you want to stick with the comma separated string, you can find many string split functions online using CLR, CTE, XML, Sep 4, 2019 · This video tutorial covers the below topics in SQL Server Reporting Services (SSRS) - 1) Creating report parameters and configuring them for multiple selecti Aug 13, 2013 · 5. There are several answers on SO related to passing multi-valued parameters to a dataset query in SSRS. Something like this: =IIF(Parameters!RecsIncl. Step 4: Add Tablix to a mix. Value,",") He wants to be able to type the values into a textbox for a parameter, not select them from a list, not display the joined list on the report. 1. Jan 9, 2015 · I've made an SSRS report which has a text field parameter where users will enter a comma separated list of string values. Value would return a list and I need to use like that: ==Fields(Parameter!ColumnData. Here's something important- The 'Active' field is a bit data type, so this is where the problem most likely lies. Change a parameter from single to multivalued. Then your original query will work, SSRS will automatically convert the multi-value list into a comma separated list and inject it into your SQL. Table-valued parameters are like parameter arrays in OLE DB and ODBC Overview. Single Value parameter in SSRS i Oct 16, 2017 · The first is to pass in a single value for Close or Open and then add some logic to the dataset DECLARE @s TABLE(status char(10)) IF @states = 0 -- Closed BEGIN INSERT INTO @s VALUES('c'),('p') END ELSE BEGIN INSERT INTO @s VALUES('o') END select * from myTable a JOIN @s s on a. If multi-value parameter has a certain value in it, I want a column to show - else have it be hidden. This dataset will be used to return a list of available values for the Product report parameter. SELECT [Funding] Oct 26, 2020 · In your subreport object's parameters, set the value for the Year parameter to the [myYear] field in your dataset by selecting it from the drop down or using =Fields!myYear. You can use table-valued parameters to send multiple rows of data to a Transact-SQL statement or a routine, such as a stored procedure or function, without creating a temporary table or many parameters. Feb 19, 2013 · The result will be a single-value string that can be passed to the report (i. ALTER PROCEDURE [dbo]. The ID and Name expression are correct, not set wrong. INSERT INTO #Temptable VALUES CAST(<Part until next comma> AS INT) SET @PortfolioID = <Everything after the next comma>. That list will be fed into a SQL query in the report's Dataset which has a: WHERE TheField in (@myCSVParam). Go to the Fields tab of the dataset properties for manually adding the Fields Name and Fields Source. I assume you already know that you need to use the DMX option in the query designer to execute DAX in SSRS. But is it possible for the user to leave the providerid parameter blank and then by default the report will run for all records? Feb 21, 2018 · I have the following query SELECT * FROM A WHERE Id IN (@Input) where the @Input is a multi-value parameter from SSRS and Id is an integer on the database. Allow multiple values on a parameter selection. [USP_RptRC] @Active VARCHAR(1) AS. option, it will open a new window called Report parameter Properties to configure the parameter properties. Value as the expression. Count: Returns the integer value 1. Value = "Value1" Or Fields!MyField. Go to the properties of the main dataset, flip to the Parameters tab and change the expression to concatenate the parameter values with a pipe “|”, such as =Join (Parameters!DateFiscalYear. . Aug 12, 2019 · I have an SSRS expression that i need to change the values in based on a passed parameter. A multi-select parameter is that and just that: a parameter that lets you select multiple values. The last thing we need to do is to add the new parameter is a filter to our report dataset and this looks like that. May 25, 2017 · In other parameters, I use the expression: [column_name] IN =IIF(Parameters!parameter. Share. Go to Name parameter setting page, go to Default Values, choose Specify values, click fx, type this: =Switch(Parameters!Control. =join (Parameters!parameterName. For example: Multi-value parameter: @Country. , "Exclude") This matches the row Category based on the parameter value, or, if the value = All products, will include all rows. The following are options for selecting parameter values in the report. Comma separated parameters. SET @A = (SELECT TOP 1 A FROM FROM @Params P) -- Perform any work. Jan 25, 2022 · 2. Value,Parameters!Param. Check the "Allow multiple values" checkbox. Feb 19, 2016 · In a SSRS report, is it possible to return a collection of values when a single value parameter is chosen? For example, I want to have a parameter Team , with options: "Cardinals, Orioles, Blue Jays". Select a value from a drop-down list for one parameter, which determines the values that are available in the drop-down list for another parameter. Click the Add button to add a row to the value list. a in (" + Join(Parameters!parameter. This is because SSRS treats all comma separated values as a single string value and it passes all comma separated values as a single string value into the query parameter. Dec 13, 2013 at 21:50. Copy and paste the dynamic SQL query into the dataset query textbox as shown below: Set the timeout value to a reasonable number, for example 600 seconds. StudentName parameter react according to ClassName parameter's value. select 'lmnop'. Value,",") in order to properly pass the string values to SQL. Mar 21, 2023 · =Parameters!User. But if I don't select order_id, I cannot select @material, @batch, and @sscc because Apr 25, 2024 · If False, the parameter is single-value and is a single object. Parameters in SQL Server Reporting Services (SSRS) add a level of interactivity to reports. organization_id, o. You can set up your expression something like this. Value,Parameters!parameter_name. Let’s look at how to implement a multi-value parameter step by step. see below example. short_name from dbo. Jul 16, 2015 · In this video of SSRS Tutorial, you will learnHow to create Tabular Report with Single Value ParameterHow to provide values to Parameter from QueryHow to Set Jul 16, 2015 · If you're using a Stored Procedure (SQL Query to a db) to get your list of items in your parameter, you can add this to the top of your query, and it will add the new option to the list (make sure you add the same columns to this part of the query as you have in your table's query): SELECT 0 AS Id , 'ALL' AS Name UNION SELECT DISTINCT Id, Name Jan 21, 2013 · Anothter option to filter data when using a multi-value parameter to a query is by using the CHARINDEX function in the WHERE clause. This way you will be able to set the main dataset of the report. They can return the same data, but their names have to be different. Let's preview the report. Add the parameter to the "Main Query" and set the value with this expression: =Join(Parameters!NewParam. By telling the report to allow nulls, SSRS will run the report regardless. For example, suppose I enter 1,2 in the user input report parameter and view the report. Dataset Query for Stored Procedure: *declare @renderType nvarchar (max) declare @script nvarchar (max) --set @renderType = 'txt,dump'. It then becomes the responsibility of the report stored procedure to be able to break down the long delimited-string into multiple rows so Right click on the subreport control and select Subreport Properties : For the report, select the subreport we created previously: Then go to the Parameters tab, select from the dropdown the report parameter you created, and for the value, the field that contains the key to filter, and then click OK. In the report itself, you don't get the list of values in a nicely wrapped up string for displaying. In the fourth condition; @material, @batch and @sscc depends on order_id. 2. Nov 6, 2018 · In the dataset properties set the query type to text. select ProductName from Product I set these values using the 'Available Values' option. You would just need to change where you use the parameter to use it as a multi-value parameter (change = @PARAMETER to IN (@PARAMETER)). Set the default value for each of your parameters, Layout_Code and Layout_Group, to the value ALL. Value),Fields!Field. For the Default values, use the same value field as was used for the Available Values. Aug 8, 2012 · Union all. This works as expected with single valued parameters. Method 1. Value(0) = "",Fields!column_name. The Default Values dataset will then use value column and then Select All will be the default value. Just replace the Values with your parameter values: 'Expression. I verified this does indeed work, check the integer returned for the built-in parameter count field. incorrect syntax near ','. For instance, if you create a report based on the Adventureworks 2014 database you could add a parameter like this: With some values that appear in the table: Jul 19, 2013 · =Fields(Parameter!ColumnData. Value Dec 28, 2015 · SSRS Interview Questions : What is Single Value parameter in SSRS Report?Parameter/s in reports are used to filter the data. Jun 3, 2016 · The parameter works in SSRS when calling a single value. The SSRS will send the following string to the query 'Israel, England, Spain'. always use @ before param_name. See full list on mssqltips. update the query of the dataset by adding the parameter. option. e. Select a single parameter value from a drop-down list. But rhe fourth case breaks down the first three conditions. True. g. We can set report parameter's default value to the dataset, whic Apr 3, 2023 · Step 2: Using just a Stored Procedure, add the dataset. Be sure to put a space before the A if you are using this method to sort your list in Step 1. Value) This provides me with the correct results when checking against a single column. The subreport will be the report you already are Dec 2, 2015 · set Allow multiple values property value to true of report parameter property and use following code as a expression inside the textbox. Sep 9, 2017 · Video talks about MULTI VALUED PARAMETERIZED REPORT Multi Value Parameter in SSRSWhat is Multi Value parameterSelect multiple values for that parameter and Dec 2, 2014 · In the dataset that uses the stored procedure I have set up a parameter, @pnum, and in the Parameter Value field I have created an expression using the Join statement like this: Join(Parameters!pnum. This tells SSRS it’s a single-value parameter. The SSRS Multi Value Parameter allows the users to select More than one value from a list, and filter the Report data using the user-selected values. 'Format. =SUM(IIf(Fields!Doc_Type. Dec 14, 2013 · 1. I am using a SSRS Parameter for my reports. Jun 2, 2019 · But that “All” option requires some additional SSRS custom code and logic for the parameter field value. Sorted by: 3. For Two values Like this : If i am passing two value output not is Coming: To get this in which way i need to send parameter currently I am passing Two parameter like This. User selection on the parameter is a multivalued parameter which is what I expect to be substituted as where in ('value1','value2') when query is executed. parameter. e. Value. Day, -7,Today()) Oct 14, 2021 · This video shows how we can set default selection to ALL for multi-select parameter in SSRS. But instead, I'm seeing all of them selected. In this article, we will show you how to add a Multi Then in the dataset properties, under the parameters tab, use an expression like this to concatenate the values: =Join(Parameters!Keys. IndexOf("\")-1) Display the selected values from a multivalue parameter. If the Jan 7, 2013 · There are two ways to set defaults for a multiselect parameter. Nov 20, 2017 · 2. Parameter Values. You also need to add the parameter at a report level globally as you normally would. FROM TableB. Mar 11, 2013 · After adding a parameter to your report and checking 'Allow Null Value',you can then add a filter to the dataset where the below expression is added to the value field for the filter =IIf(IsNothing(Parameters!Param. ORDER BY Layout_Code. order by Field1. Value,”|”). FILTER(Values( 'City' [Country Jan 4, 2017 · 6. Then put the default value of all your required parameters to "All Selected". identifier i on i. The second option in the list, "Specify Values" will allow you to hard code values. Value = "All products". As you know our recently created dataset has one @Product query parameter which can accept multiple values, so we have to create a new dataset for our Product report parameter. the parameters list will automatically has the param_name without the @ sign. SSRS Multi Value Parameter. Value(1)). option, a new window called Report parameter Properties is opened to Apr 25, 2017 · The reports pass multi-value parameters to a SQL stored procedure. SET YOUR PARAMETER DEFAULTS TO ALL. SELECT 'ALL SELECTED' as DefaultValue. Ensuring the “Allow multiple values” checkbox within the Parameter properties is left un checked. I would expect only the 'Abc' to be selected by default and the rest unselected. Here's a screenshot in case you missed it. Or, SSRS Multi Value Parameter enables the users to to Filter the Reports using more than one value Dynamically. Value but it's not what I want as I need to indicate the index manually SELECT 'value1' AS Value UNION SELECT 'value''2' I bind this DS to multivalue parameter. I haven't been able to figure out a way to translate this into what I need to do with the other parameter Aug 4, 2017 · Filter Parameter: You have the concept of this already obviously and should be able to add more complex logic (preferably isolated in a stored procedure) to meet your requirements. ei tk fn za pp jn rz wj ah hg