我已经看过各种方法,但似乎无法正确实现它。
我在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 @Ward2nd dataset for local authority
@County varchar (5) SELECT DISTINCT LocalAuthority, county FROM table1 WHERE [County] = @Countyand a final dataset for Ward
@LocalAuthority (max) SELECT DISTINCT Ward, LocalAuthority FROM table1 WHERE [LocalAuthority] = @LocalAuthorityMany Thanks
最满意答案
如果您想通过存储过程获取数据集,请尝试使用@ward中的ward;
CHARINDEX(','+ward+',', ','+@ward+',') > 0Try this instead of ward in @ward if you wanted to get the dataset via stored procedure:
CHARINDEX(','+ward+',', ','+@ward+',') > 0更多推荐
发布评论