Evaluate each rec then supress if condition isnt met.

[giggles7840]

here it is......
lets say i have 2 groups of records.

group1
quality
credit
background

group2
credit
background

I only want to show the groups that contain a record of quality and/or credit and background. if the group does not contain a quality record I need to hide those details...

can this be done??? make sense?

 

[lbass]

You could create a formula {@qual}:

if not isnull({table.quality}) then 1 else 0

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

sum({@qual}, {table.group}) > 0 //where {table.group} is your group field

This will return only those groups which have a quality record. But your phrase "...and/or credit and background" is confusing--did you want also to include groups which contained both a credit and a background record, but NOT a quality record?

-LB

 

[giggles7840]

i need only the groups that will look like this....

Group 1
Quality
Credit
Backgroud

Group 2
Quality
Credit

Group 3
Quality
Background

I do not need

Group 4
Credit
Background

is that more clear?

 

[giggles7840]

and quality, credit, and background are actually indiviual records in one field.

so its:
Group A
Detail - Quality
Detail - Credit
Detail - Background

and these are all coming out of the same field.

 

[dgillz]

Create a formula:

If {DatabaseField}="Quality" then 1 else 0

Summarize this field at the group level. You can suppress this if you don't want to see it on your report.

The write a group selection formula:

Sum({databaseField},{GroupByField})>0

This willhave the effect of showing only those groups than have at least 1 "quality" record.





Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[giggles7840]

a running total can not be created for the group selection formula.....

 

[giggles7840]

ok never mind i got it. thanks guys!

 

[giggles7840]

Ok now the next problem with this is i need to evaluate the records that are kept from the above formula and compare dates of the Quality records to the others that fall under them.

These are Detail lines....For instance...
D1 - Quality 12/16/03
D2 - Credit 12/15/03
D3 - Credit 12/17/03

In this example i need to keep D1 and D3. D2 does not belong..... How do i supress that record?