Select People missing certain licenses 1

[Fadius]

I am writing a report and only want people displayed which are missing either a state license or a federal license. The people in the database can have multiple licenses. State, Federal, Drivers, CDL, CPR, Etc.

How do I get it to only display a person if they are missing either a state or a federal license. The Licenses are types.


Thank you,

 

[lbass]

Allow all license types into the report. Then insert a group on {table.person}. Create formulas like these:

//{@hasst}:
if isnull({table.license}) or
{table.license} <> "State" then
0 else 1

//{@hasfed}:
if isnull({table.license}) or
{table.license} <> "Federal" then
0 else 1

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

sum({@hasst},{table.person} = 0 or
sum({@hasfed},{table.person} = 0

-LB

 

[Fadius]

Thank you lbass. That worked perfectly.