Programmatically Check/Uncheck checkboxes of SSRS Multi-value Parameter

Question

I have a report in SSRS 2005 that has a Multi-value parameter. When you run the report, is it possible to programmatically check or uncheck the checkboxes depending on what checkbox you check? In other words, is there a way to have event code run when you check or uncheck the checkboxes?

Mike

ceth ceth · Accepted Answer · 2012-01-22T08:46:29

It is possible to set range of values of Parameter B depends of selected value of Parameter A. It is named a cascading parameters.

Create Parameter A and set list of values for it - for example, the table Continents.

Create Parameter B and set next stored procedure as list of avaliable values:

CREATE PROCEDURE [dbo].[countries](@continent int)
AS
SET NOCOUNT ON

SELECT * FROM countries WHERE id IN
   (SELECT country_id FROM continents WHERE continent_id = @continent)

On the properties of Parameter B (Tab - Parameters) set the first Parameter A to link our parameters together.

Programmatically Check/Uncheck checkboxes of SSRS Multi-value Parameter

1 Answers