need to drop users based on a date

[andreadd]

hello,

Crystal 2008 Visual Advantage, GoldMine 6.7, SQL 2000 sp4

I am writing a report that the record selection is this:
{PAST90.userid} = {?Region - PERSON} and
{PAST90.Ondate} in currentdate -90 to currentdate

which is basically go back 90 days from now and find out what the user selected from parameter did in that time frame. works fabulous but I now must add another layer to it.

There is a table in SQL that controls my user list I have 2 columns emplstatus (ACTIVE or <NULL> are choices) and a termdate column. that is a date cloumn. So all users when entered have ACTIVE in their emplstatus and the termdate is <NULL>. When they leave the company I change the ACTIVE to <NULL> and then put termination date in the termdate column (i.e., 1/1/2009)

So now I need to change the record selection or maybe add a group based on a formula to the top sort of the report that says I want to see all active employees PLUS the ones whose term dates are within my 90 day window. after the 90 day window, do not process them. It would be even greater still if the names could drop off of the paramter that shows userid.

I have a cascading parameter that looks at 2 columns in the user list table. one for region and then the cascade is for user. right now it shows all users - is there a way to conditionally list users in a cascading paramter?

 

[andreadd]

so I have the record selection working well with the following formula:

{PAST90.Ondate} in currentdate -90 to currentdate and
{PAST90.userid} = {?Region - PERSON} and
{ANDIDUN.EMPSTATUS} = "ACTIVE" or {ANDIDUN.TERMDATE} in currentdate -90 to currentdate

at runtime the report displays just great, I would like to get the names off of the parameter ideally.

any ideas?