SSRS级联参数 | SSRS级联参数

本文介绍了SSRS级联参数的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

大家好。

我需要使用SQL Server 2014显示数据库中大量数据的报告。

我一直在寻找一种方法我从第一个存储过程中检索的相同数据，并按下一个参数对其进行过滤。

愚蠢的例子：

age &NBSP; &NBSP; &NBSP; 1 &NBSP; &NBSP; &NBSP; &NBSP; 2 &NBSP; &NBSP; &NBSP; 3

name &NBSP; &NBSP; A &NBSP; &NBSP; &NBSP; &NBSP; B &NBSP; &NBSP; &NBSP; C

姓氏 X &NBSP; &NBSP; &NBSP; &NBSP; Y &NBSP; &NBSP; &NBSP; Z

我需要过滤第一个年龄= 1，然后名字= A，最后一个姓氏= X但是此刻我需要在相同的初始大数据上执行3个SP。 / p>

解决方案

Hi everybody.

I need to display a report from a large amount of data in my DB using SQL Server 2014 .

I also need to filter my result by 3-4 parameters in cascade but, due to the quantity of rows and calculations, it's really slow.

I was looking for a way to use the same data I retrieve from the first stored procedure and filter it by the next parameters.

stupid example:

age 1 2 3

name A B C

surname X Y Z

I need to filter first age=1, then name=A, last surname=X but at the moment I need to execute 3 SP on the same initial big data.

解决方案

这篇关于SSRS级联参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！