如何隐藏每个组的最后一行？ [英] How can I hide the last row from each group?

问题描述

使用VB 6和Crystal Report 8.5，如何隐藏每个组的最后一行？我需要使用Crystal Report公式吗？我不想显示每个组的最后一行。

Using VB 6 and Crystal Report 8.5, how can I hide the last row from each group? Do I need to use a Crystal Report formula? I don't want to display a last row from the each group.

如何写这个公式，我应该在哪里写呢？

How can I write this formula, and where should I write it?

推荐答案

您可以为要分组的字段创建一个组，然后在压缩公式（x + 2）中使用以下公式

You can create a group for the field that you want it grouped by and then use the following formula in the suppress formula (x+2) on the details section in the Section Expert.

下面是一个假设报表按用户分组的示例。

Below is an example assuming the report is grouped by user.

if OnLastRecord then
    true
else
    {Test;1.user} <> next({Test;1.user})

第一部分将隐藏最后一行，因为没有要比较的行，else部分将评估每一行并将其与下一行进行比较。

The first part will hide the last row since there is no row to compare against and the else part will evaluate each row and compare it with the next row.

这篇关于如何隐藏每个组的最后一行？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！