SELECT EXPERT USING MULTIPLE CRITERIA 2

[FRENCHIEE]

ISSUE #1

HERE IS WHAT I AM TRYING TO DO

INCLUDE all customers that do not have a booked date later then 12/31/03,



ISSUE #2

INCLUDE ALL JOBS THAT ONLY INCLUDE MACHINE 750 AND DO NOT INCLUDE CONFIGURATIONS 710,720,730,740,760

HAVING TROUBLE BECAUSE THE JOBS COULD INCLUDE MULTIPLE CONFIGURATIONS.

PLEASE HELP

 

[synapsevampire]

Please refrain from posting in all caps, it's a little loud.

Posting your Crystal version is also a basic consideration.

What you want is something like:

Group on the Customer (Insert->Group and pick the customer ID field).

Report->Edit Selection Formulas->Group

(
maximum({table.customerbookeddate},{table.customerid}) < cdate(2004,1,1)
)

Then you can use:

Report->Edit Selection Formulas->Record

{table.machine} = 750

Should get you close.

-k

 

[FRENCHIEE]

Thanks Issue #1 is done but issue #2 was maybe unclear.

I need to select data per {Table.JOBN} with only data from {Table.machine} = 750

Some Jobs may have multiple machine numbers. Any other Ideas on this issue. If I select 750 those jobs still may have other machine numbers included with them.

Let me know,

thanks.

 

[lbass]

Do not use a selection criterion on {table.machine}. Instead, create a formula {@mach}:

if {table.machine} = 750 then 1 else
if {table.machine} in [710,720,730,740,760] then 10000 else 0

Then insert a group on {table.jobID} and go to report->edit selection formula->GROUP and enter:

sum({@mach},{table.jobID}) in 1 to 9999

-LB