级联参数(Cascading Parameters)

级联参数(Cascading Parameters)

我已经看过各种方法，但似乎无法正确实现它。

我在SSRS中有一个3参数报告

@County @LocalAuthority @Ward

我希望这些参数级联。 因此，当选择@county时，@ LocalAuthority仅显示该县内的地方当局。 当选择地方当局时，只有那些当局的病房出现。

县到地方当局正在工作，但地方当局对沃德不是。 正确的病房显示在下拉参数中，但它们不是在实际报告中按病毒过滤。

我正在使用存储过程。 这是我的主要数据集

@County varchar (5), @LocalAuthority varchar (max), @Ward varchar (max) SELECT [DateTimeOfCall] ,HourOfDay ,[ConcatAddress] ,[LocalAuthority] ,[Ward] ,[County] ,[PropertyType] FROM table1 WHERE [County] = @County AND [LocalAuthority] = @LocalAuthority and [Ward] in @Ward

地方当局的第二个数据集

@County varchar (5) SELECT DISTINCT LocalAuthority, county FROM table1 WHERE [County] = @County

和Ward的最终数据集

@LocalAuthority (max) SELECT DISTINCT Ward, LocalAuthority FROM table1 WHERE [LocalAuthority] = @LocalAuthority

非常感谢

I have looked at various ways of doing this but cant seem to implement it correctly.

I have a 3 parameter report in SSRS

@County @LocalAuthority @Ward

I want these parameters cascading. So when @county is chosen @LocalAuthority only displays local authorities within that county. And when local authorities are chosen only the wards in those authorities appear.

the County to Local Authority is working but Local Authority to Ward isn't. The correct wards are showing in the drop down parameter but they are not filtering by ward in the actual report.

I am using stored procedures. This is my main dataset

@County varchar (5), @LocalAuthority varchar (max), @Ward varchar (max) SELECT [DateTimeOfCall] ,HourOfDay ,[ConcatAddress] ,[LocalAuthority] ,[Ward] ,[County] ,[PropertyType] FROM table1 WHERE [County] = @County AND [LocalAuthority] = @LocalAuthority and [Ward] in @Ward

2nd dataset for local authority

@County varchar (5) SELECT DISTINCT LocalAuthority, county FROM table1 WHERE [County] = @County

and a final dataset for Ward

@LocalAuthority (max) SELECT DISTINCT Ward, LocalAuthority FROM table1 WHERE [LocalAuthority] = @LocalAuthority

Many Thanks

最满意答案

如果您想通过存储过程获取数据集，请尝试使用@ward中的ward;

CHARINDEX(','+ward+',', ','+@ward+',') > 0

Try this instead of ward in @ward if you wanted to get the dataset via stored procedure:

CHARINDEX(','+ward+',', ','+@ward+',') > 0