Suppressing Group Headers

[SDS100UK]

Hi,
I am using CR 7
I have a report with 2 groups and a detail section

When the report opens group 1 only is visible because group 2 and details are suppressed(drill down ok)
but when I drill into group 1 and get group 2 I get the labels for the details section repeating all the way down the group section.

Obviously these labels dont mean anything until the details have been drilled into.

How do i stop the labels showing if group is suppressed and show only when details have been drilled??/

Hope this makes sense

TIA

Steven

 

[hilfy]

Put the labels in their own detail section and make it the first details section. In the suppress formula for this detail section put something like:

{group2field} = previous({group2field})
and {group1field} = previous({group1field})

Use the actual field name or formula for your groups.

This will suppress the label line if the current value of both group fields is the same as the previous value of those fields. You can take out the second line if there is no possiblity that your group 1 will change without group 2 changing as well.

For example, Group1 = last name, Group2 = first name. If your data looks like this:

LastName       FirstName
--------       ---------
Smith          Bob
Taylor         Bob

you won't get a set of field labels between the groups if you delete the second line of the suppression formula.

-D