python slicer_报表筛选：Excel Slicer与SQL Server Reporting Services（SSRS）参数

python slicer

This article explores the report filtering using Excel Slicer and SQL Server Reporting Services.

本文探讨了使用Excel Slicer和SQL Server Reporting Services进行报表筛选。

At the heart of interactive reporting is the ability for end-users to filter report datasets according to their preference. Therefore, a great data visualization tool is the one that caters for report filtering. Some of the popular data visualization tools used by some of my clients to consume my Business Intelligence solutions usually include SQL Server Reporting Services (SSRS) and Microsoft Excel. Although these tools share a similar publisher, Microsoft, they have several differences on their report usage and configuration. One difference they seem to share is in the way they are configured to enable report filtering, which is the focus of this article.

交互式报告的核心是最终用户能够根据其偏好过滤报告数据集的能力。 因此，一种出色的数据可视化工具是迎合报表筛选的工具。 一些客户用来使用我的商业智能解决方案的流行数据可视化工具通常包括SQL Server Reporting Services（SSRS）和Microsoft Excel。 尽管这些工具与Microsoft发行商相似，但是它们在报表使用和配置方面存在一些差异。 他们似乎共享的一个区别是它们配置为启用报表筛选的方式，这是本文的重点。

案例分析 (Case study)

Likewise, proper discussions surrounding topics relating to SQL Server are better explained through technical demonstrations. Consequently, the dataset that will be used to produce SSRS and Excel reports will be based on the dummy data that was imported as part of the demo in my article, Working with Ragged Right Formatted Files in SSIS. For the purposes of this article, I have further transformed this data and represented it in a form of a SQL Server View titled, FruitSales.

同样，可以通过技术演示更好地解释有关SQL Server主题的适当讨论。 因此，将用于生成SSRS和Excel报告的数据集将基于在我的文章《在SSIS中处理不正确的右格式的文件》中作为演示的一部分导入的虚拟数据。 出于本文的目的，我进一步转换了此数据，并以标题为FruitSalesSQL Server视图的形式表示了该数据。

The definition of the view can be downloaded here.

视图的定义可以在此处下载。

Figure 1 shows the execution results of a SELECT T-SQL command against the FruitSales view.

图1显示了针对FruitSales视图的SELECT T-SQL命令的执行结果。

A typical business case with such a dataset could be as follows:

具有此类数据集的典型业务案例如下：

• As a business user, I would like to see breakdown of customers by the total