Group Select

[enbw]

I am fairly new to crystal reports. I am using Crystal 8.5 with an odbc connection to a progress sql db.

I have two tables Partopr and Partmtl which are joined, left outer, through partnum, revision number and relatedop. For each record in the Partopr there could one or more related records in the Partmtl table

Part Opr Table

PartNum Revision oprSeq
6666/0 1 10

Partmtl
PartNum Revision RelatedOprSeq MatPartnum
6666/0 1 10 BSAND
6666/0 1 10 SL1
6666/0 1 20 TG1

I have created a report which groups on the Partnum in the Partopr table and details contains the related Partmtl records.

I want to just select the groups where BSAND is not listed against the partnum in partopr. I have tried creating a group selection formula, partmtl.matpartnum <> "BSAND", but this doesn't seem to work properly.

Thanks in advance

 

[lbass]

Create a formula {@hasBSAND}:

if {PartMtl.MatPartnum} = "BSAND" then 1 else 0

Then go to report->edit selection formula->GROUP and enter:

sum({@hasBSAND},{PartOpr.PartNum}) = 0

This assumes you have a group on {PartOpr.PartNum}.

-LB

 

[enbw]

Thanks