Select Expert Help or Alternative

[paulcook]

I am creating a report based off an answer provided by lbass to my colleague in this forum thread767-622321. I am stuck on another portion of the report.

The report needs to show clients whose follow up results are equal to '8' or '9' in any one of four follow-ups. The Details section is suppressed. There are four records in the table for each client. I started out by setting up a Select Expert on the Max of @4thQtrResult field that is in the Group Footer #1.

No records show up when I preview the results although there are records with '8' and '9' in that field before I set up the Select.

TIA,

Paul
P.S.
I am new to Crystal and this forum so please be gentle.

 

[lbass]

If you only want to show those clients whose results include an 8 or a 9, then the following should work. I'm assuming that there is only one results field. If this is the case, then create a formula {@8or9}:

if {table.result} in [8,9] then 1 else 0

Then in the group select statement (report->edit selection formula->GROUP) put:

sum({@8or9},{table.client}) > 0

This assumes you have a group on {table.client}. This will return all results for clients who have an 8 or a 9 as one of their results.

Let me know if this isn't what you were looking for.

-LB

 

[paulcook]

lbass,

Thank you for your time but I discovered the reason the Select wasn't working is because I was giving it the wrong parameters.

I am slightly embarrassed to admit this but I was using 8 & 9 instead of 08 & 09.

Thanks again,

Paul