如何在报告的详细部分中处理单个记录 [英] How to work with individual records in detail section of report
问题描述
我正在尝试开发一个基于3级分层数据建模系统的报告。每层是它下面的层的总和。当基于顶层打印报告时,报告的模板几乎是以下内容:
项目名称,实际成本,赢得值,计划值
>
我的问题是我创建了一个查询,它可以获取我需要的大部分数据,但是我不能在同一个查询中执行计算。为了计算我需要的值,我相信我需要做一个单独的查询并计算一个值,然后我将其设置为我的计算字段的值。
我该怎么做?
如何在每条记录的基础上创建查询并执行该查询?
I''m trying to develop a report that is based on a 3 level hierarchal data modeling system. Each tier is a summation of the layer below it. When printing a report based on the top level the template for the report is pretty much the following:
project title, actual costs, earned value, planned value
My problem is that I''ve created a query that gets most of the data I need but I can''t perform the calculations in the same query. In order to compute the values I need I believe I need to do a separate query and compute a value that I then set as the value of my computed fields.
How do I do this?
How do I create a query and execute that query on a per record basis?
推荐答案
我们需要知道你试图做什么计算。
We would need to know what calculation you''re trying to do.
计算如下:
SV = EV - PV
CV = EV - AC
CPI = EV / AC
SPI = EV / PV
我不能弄清楚如何进行这些计算并将其与其他记录详细信息一起显示。我创建了一个查询,获取了我需要的大部分信息,但我无法弄清楚如何进行这些计算并将它们显示在各自标题下的行中。我附上了一张图片来展示这份报告应该是什么样子。
The calculation are as such:
SV = EV - PV
CV = EV - AC
CPI = EV / AC
SPI = EV / PV
I can''t figure out how to do these calculations and display them with the other record details. I created a query that gets most of the info I need but I can''t figure out how to do these calculation and show them in the rows under their respective headers. I''ve attached an image to show what this report should look like.
您希望显示SV值的文本框中的公式必须是这样的:
= [EV_FieldName] - [PV_FieldName]
当然你必须更换我的 EV_FieldName 和 PV_FieldName ,包含数据库中的实际字段名称(报告)
The formula in the text boxes where you wish to show the SV value must be something like that:
=[EV_FieldName]-[PV_FieldName]
Of course you must replace my EV_FieldName and PV_FieldName with the real field names in your daatabase (report)
这篇关于如何在报告的详细部分中处理单个记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!