Hide row in Crystal Reports Crosstab

Question

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.

Answer 1

Not directly. I recommend grouping by a custom formula.

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. 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}

2. 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.