如何在Crystal报表中获取单行中每个项目的总计数？ [英] How Do I Get The Total No. Of Count Of Each Item In A Single Row In A Crystal Report?

问题描述

嗨朋友们，

我是水晶报告的新成员。我有这个月的员工报告，我想算一下特定员工的现在和缺席天数。

我可以安排在31行的单行中，并为当天和缺席日创建两个额外的列。



请帮我计算总数那一天没有几天。



我也可以使用正在运行的字段，但它不起作用。

请帮助我

Hi friends,
I am new in crystal report.I have this months presenty report of employees & i want to count the present days and absent days for particular employee.
I can arrange there presenty in a single row with 31 columns and create two extra columns for present days and absent days.

please help me to count the total present and absent days in that row.

I can also use the running fields but it doesn't work.
please help me

推荐答案

如果运行字段不是一个选项（为什么不运行，它怎么办？）...



创建用于对值进行求和的公式字段。在公式中，您可以查询其他字段并仅仅对符合某些条件的值进行sumarize。



我的新工作场所没有安装CR，但是说明有些事情是这样的：



对于简单摘要：右键单击该字段，选择公式/摘要或类似的东西并选择操作SUM，字段present_days



对于公式，在左侧（通常）的文档布局中展开公式，右键单击并选择新公式，为其命名并编写代码。



以下是最常见的公式示例的综合教程[ ^ ]





如果这有帮助，请花时间接受解决方案。谢谢。

If running fields aren't an option (why not, how does it not work?)...

Create a formula field for summing the values. In the formula, you can query other fields and sumarize only the values that meet some criteria.

I don't have CR installed at my new workplace, but the instructions are something along the lines:

For plain summary: right click the field, select formula / summary or something like that and select the operation SUM, field present_days

For formula, expand formula in the document layout on the left side (usually), right click and select new formula, give it a name and write your code.

Here is comprehensive tutorial with most common formula examples[^]


If this helps please take time to accept the solution. Thank you.

这篇关于如何在Crystal报表中获取单行中每个项目的总计数？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！