如何在运行时过滤图表？ [英] How to filter chart at runtime?
问题描述
我根据项目ID（groupby）在报表上有一个图表。
每个项目及其详细信息都显示在单独的页面上。
我的图表显示测试执行状态（已通过，失败，无运行，未完成），该状态取自与项目ID相同的表格。
我想要此图表根据页面上的项目ID显示测试执行状态。
因此每个页面将显示不同的项目ID及其测试执行统计信息。
我试图在select查询中传递参数并将其放在RowSource中，但它显示所有项目的相同（第一个项目）统计信息。
任何帮助解决这个问题都将受到高度赞赏。
TIA
SFL
Hi,
I have a chart on a report based on project id (groupby).
Each project and its details is displayed on separate page.
My chart displays test execution status (passed, failed, no run, not completed) which is taken from the same table as the project id.
I want this chart to display test execution status based on the project id on the page.
So each page will display different project id and its test execution stats.
I tried to pass parameter in the select query and put it in RowSource but it displays same (first project) stats for all the projects.
Any help to resolve this would be highly appreciated.
TIA
SFL
推荐答案
请阅读发布前（VBA或SQL）代码，然后发布您尝试过的内容。我建议您阅读的另一个链接是如何提出好的问题。
Please read Before Post (VBA or SQL) Code and then post what you have tried. Another link I recommend that you read is How to ask good questions.
您好Seth，
这是图表的RowSource属性中的sql。
Hi Seth,
Here is the sql present in the RowSource property of the chart.
发布代码时请使用 [CODE /] 按钮。这使得它更容易阅读。这是在我发布的第一个链接中说明的。
但是，我可以看到为什么你得到所有相同的值。在WHERE子句中，您需要删除 [PlanView ID]。[Value] 并将其替换为对报表的引用。这是这样完成的：
Please use the [CODE/] button when posting code. It makes it a ton easier to read. This was stated in the first link that I posted.
However, I can see why you are getting all the same values. In your WHERE clause, you need remove the [PlanView ID].[Value] and replace it with a reference to your report. This is done like this:
这篇关于如何在运行时过滤图表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
