conditionally suppressing a section

[crywrite]

I'm try to conditionally format my detail section. I only want to show the first shipment on a multiple shipped order.
For example, there are four lines of data for one order:

order# release# dateshipped qtyshipped
500 1 9/1/02 300
500 1 9/3/02 200
500 1 9/8/02 1000
500 1 9/13/02 100

I only want to pull the 9/1 shipment. I have suppressed duplicates on the release# field, and did a suppress section formula where isnull(release#). The last three release#s are blank, but it is still pulling all four lines. How else can I go about this?

 

[dgillz]

Sort your report so that the desires record is on top of the group, drag the database field in question to the group header, and hide the detail section. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[crywrite]

If possible, I would like to narrow down my selection rather than just what's showed, becuase I have a few summary fields.
Is there a way to take a minumim(field, group) in the selection expert? There are transaction numbers for each line and I would like to take the minimum trx number for each order number. I keep getting "This function cannot be used because it must be evaluated later". Is there a different way to go about this?

 

[dgillz]

Minimum(filed,group) is a summary function and can only be used in the group selection formula. Are you putting it in the recoed selection formula in error?

Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[synapsevampire]

You can turn on the perform grouping on server and design your report accordingly to return only the min based on grouping all other fields.

Or if you're using CR 9, you can just build SQL to do this.

Or you can do this within a View or a Stored Procedure.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[crywrite]

I went to selection expert, button-holed "Group Selection", then put in the formula as Mininum(feild,group) and got the message "Result of selection formula must be a boolean". Where am I going wrong?

 

[dgillz]

A boolean is a true/false formula. Does your formula evaluate to true or false? Please post your formula in its entirety to this forum so we can see. it.

Also, consider using the group selection formula instead of the select expert. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[crywrite]

I decided to go a different way. I put the fields in the header of the group and used a running total to get my totals based on the change of order number.

Thank you for all your help!