Is there a suppress when NOT DUPLICATE for a Group Footer?

[debunky]

I only want to show duplicate group footers (order number) -I don't want to see any other group footer if there is only one for an order number.

Using Previous() in the section visibility area does not work on a group field name.

Anyone have a suggestion?

 

[synapsevampire]

There's no such thing as a duplicate group footer, groups are unique.

Perhaps if you posted example data and expected output someone can help you.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[debunky]

Perhaps I wasn't clear enough. Here is a sample of my data:

Order# Carrier Doc# Ship Date
00000009SA CB Fed Ex Ground 1203803 12/10/2002
00000010SA CB Fed Ex Ground 1204079 12/10/2002
00000011SA CB Fed Ex Ground 1205206 12/10/2002
00000012SA CB Fed Ex Ground 1205434 12/09/2002
00000012SA CB Fed Ex Ground 1207017 12/09/2002

The report is grouped by Order # then Doc# and the above lines are for group footer 2 (doc#). All I want is to suppress order#'s 9, 10, 11 and just show the 2 lines for order# 12 since there are 2 documents for this order (duplicates).

I don't think it can be done but I need someone else to verify that.

Can this be done? Anyone have any suggestions?

Thanks.

 

[synapsevampire]

OK, I think I understand now.

I think that you'll want to prequalify the data, rather than try to accomplish this using the current methodology.

It's best to handle this sort of thing in SQL,

IN CR, try this:

Create a formula which combines the Order+Doc field, and group on this.

Place this field into the details section and create a insert->summary->count for it

Now delete the details field and drag the count of it into the group header.

In the details section place your fields, and build a suppression something like:

Count ({@Combined}, {@Combined}) > 1

That should only display those that have a QTY > 1

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[debunky]

Thanks for the input. I did something similar to what you suggested but without creating another group.

I created a formula that did a distinct count on doc# by order # and put it in the group footer 1. I then did a section format on group footer 1 and group footer 2 and suppressed if the formula (count) is equal to 1.

This worked like a charm..... I guess persistence works out. I was ready to give up.

Again thanks for your input......

 

[chelseatech]

You can supress a section conditionally and by using NEXT and PREVIOUS functions you can achieve what you want.

{table.order}<>NEXT({table.Order}) and
{table.order}<>PREVIOUS({table.Order})

is the condition you need for the conditional section suppress of the group footer. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[dgillz]

Please keep in mind that any suppressed records or subtotals will still evaluate in any grand totals you may have. Consider using the same logic, but a group selection formula to exclude these groups from your report entirely. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com