隐藏Crystal Reports交叉表中的行 [英] Hide row in Crystal Reports Crosstab

问题描述

是否可以在水晶报表交叉表中隐藏一行？

Is it possible to hide a row in a crystal reports crosstab?

我有两行只用于计算第三行，我想隐藏他们只有结果对用户可见。

I have two rows that are only used to calculate a third row and I would like to hide them so only the result is visible to the user.

推荐答案

不直接。我建议您按自定义公式分组。

Not directly. I recommend grouping by a custom formula.

例如，假设您有一个按 StoreName 分组的交叉表。 StoreName 具有值组A，B和C。您要合并B和C。

For example, let's say you have a crosstab that is grouped by StoreName. StoreName has values groups "A", "B", and "C". You want to combine "B" and "C".

1. 创建一个新的公式字段。称为 StoreName_Combined 。在新公式中输入：
   
   如果{StoreName} =B或{StoreName} =C，则B + Celse {StoreName}

1. Make a new formula field. Call it StoreName_Combined. In your new formula, enter:
   If {StoreName}="B" or {StoreName}="C" then "B+C" else {StoreName}

在您的交叉表中，使用 StoreName_Combined 而不是 StoreName / li>

In your crosstab, use StoreName_Combined instead of StoreName.

编辑

如果你仔细观察一下，使用交叉表专家 - >组选项 - >选项 - >使用公式作为组名称，但我无法使其工作。这些行保持分开，它们只有相同的名称，这不是真的帮助。

Edit

If you look around a little, you may also think about using Cross-Tab Expert->Group Options->Options->Use a Formula as a Group Name, but I couldn't get it to work. The rows stay separate, they just have the same name, which doesn't really help.

这篇关于隐藏Crystal Reports交叉表中的行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！