Multiple Records - Selection Criteria 2

[govmule]

Hello Everyone,

I've got Crystal Reports 8.5 connected to an Informix Dynamic Server7.3. It'sconnected via an ODBC driver.

I'm making some mailing labels for clients who have not completed our yearly follow up cycle. The followup table (wia_folup) can have up to four records in it, one for each quarter. The field follow up result (wia_folup.folup_type) can have a 1, 2, 3 or 4 identifying the proper quarter.

I tried selecting 'wia_folup.folup_type <> '4' but that's not going to work because I need to know if the;ve missed any.

As always, your help is very appreciated.

Thanks,

Jack

 

[synapsevampire]

A bit vague for me.

Please post example data and expected output.

-k

 

[lbass]

If you are trying to select only those customers who do not have a fourth quarter followup, then do not exclude customers based on followup type. Instead, group on {table.customerID} and then create a formula {@4thqtr} for the details section:

if {wia_folup.folup_type} = '4' then 1 else 0

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

sum({@4thqtr}, {table.customerID}) = 0

This should return only those customers without a 4th quarter followup. Workforce Investment Act, yes?

-LB

 

[govmule]

Hey lbass,

I was going over some old posts and noticed your comment regarding Workforce Investment Act. Yes it is. I'm working in Orange County California with the State's Job Training Automation System.

Thanks for the help,

Jack

 

[lbass]

You're welcome--and I'm with the WIB, Cambridge, MA...

-LB