May 21, 2014 at 3:51 pm
In a new ssrs 2008 r2 report, I am obtaining parameter values to pass to the main query of the report by setting up individual
datasets that look like the following for each value in the temp table called #year:
declare @user int = 1
IF OBJECT_ID('tempdb..#year') IS NOT NULL
DROP table #year
CREATE TABLE #year(
Year varchar(10)
, School varchar(40)
, Calendar varchar(30)
, taskID int)
INSERT #year
EXEC [text].[dbo].[procQCParam] @user
select distinct year from #year
IF OBJECT_ID('tempdb..#year') IS NOT NULL
DROP table #year
I am told by the users that each parameter value will be displayed independently by each parameter. In other words once the user selects year, then the values for school are displayed. Once the values for school are selected, then the values are can be selected for Calendar. These I believe are called cascading parameters.
Based upon what I described above, can you show me the sql for the cascading parameters and explain how to link the parameters together?
May 21, 2014 at 3:55 pm
The title of the topic should be ssrs 2008 r2 using cascading parameters. I could not figure out how to edit the heading.
May 21, 2014 at 4:40 pm
You filter the second (cascaded) parameter based on the first parameter.
Given @param1 and @param2, the value list for @param2 is usually
SELECT somecolumn
FROM someTable
WHERE someField = @param1;
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply