Suppress all groups except the first

[SpankyDave]

Is it possible to print and total on only the first of a set of groups which are being returned in a Crystal report. I have data such as below, detail lines which group on user10.

project acct selected_1
user10 Actamt_Eligible
735-00 LABOR 01-HWY S 273.52 1
735-00 LABOR 01-HWY S 674.04 1
735-00 LABOR 01-HWY S 482.76 1
735-00 LABOR 01-HWY S 68.32 1
735-00 LABOR 01-HWY S 250.08 1
01-HWY SPEC 1,748.72

735-00 LABOR 02-P-PRO 273.52 1
735-00 LABOR 02-P-PRO 674.04 1
735-00 LABOR 02-P-PRO 482.76 1
735-00 LABOR 02-P-PRO 68.32 1
735-00 LABOR 02-P-PRO 250.08 1
02-P-PROG-37 1,748.72

As the items are repeat when I get to the next group, I wish to suppress the second and all following groups. I need to display and total the unique items represented only by those presented in the first group.

What function in Crystal accomplishes this in CR 8.5?
Thanks, very much.

 

[kchaudhry]

SpankyDave,

If there are no other conditions, then you can go to design view and right click on the Group you want to suppress and select "supress-no drill down".

Kchaudhry

 

[lbass]

You could go to format section->details (and other group sections that you don't want to appear)->suppress->x+2 and enter:

groupnumber <> 1

But, it looks like you have a group 2 on whatever field includes &quot;01-HWY S&quot; and &quot;02-P-PRO&quot;. If you really don't need these, you could delete that group and the field, and then you might not need to use a suppression formula.

-LB

 

[SpankyDave]

Kchaudry,
If I do that, however, all instances of the group are suppressed. I want the first group to print, but no others.

 

[kchaudhry]

In that case you should use the supression formula that Lbass has mentioned in his post.

Kchaudhry

 

[SpankyDave]

lbass:

That's very helpful. It moves me forward.
thanks.

 

[synapsevampire]

Hard to say the most efficient means without more information, but it might be as simple as selecting Report->Edit Selection Formula->Record and placing:

{table.MyGroup} = &quot;01-HWY SPEC&quot;

Then you don't suppress (which doesn't prevent aggregate functions from using them), and the report might be quite a bit faster.

-k

 

[SpankyDave]

synapsevampire:

I guess I can't use {table.MyGroup} = &quot;01-HWY SPEC&quot; in Report > Edit Selection Formula > Record because the next project (the project in the example above is 735-00) might not have 01-HWY SPEC, as one of the groupings on that project, but will probably have totally different group id's. Again, I want just the list of detail lines from the first group for the next project.

thanks for the suggestion.