Report based on date of appt.

[wgechter]

How would I create a report that said I want a list of patients that had an apptdate in 1/1/2005 to 12/31/2006 but don't display them if they've had an apptdate in 1/1/2007 to currentdate. I'm not sure where to put the formulas or how to group it. For example if

John Smith - 1/10/2005 and a 1/12/2007 I don't want to see him in my list
Lucy smith - 3/15/2005 and 4/16/2006 I want to see in my list...once.

I'm sure you all need more information, let me know. wendi

 

[lbass]

Set up your record selection formula like this:

{table.date} >= date(2005,1,1)

Then create a formula {@in2007}:

if {table.date} >= date(2007,1,1) then 1

Insert a group on {table.patientID} and then go to report->selection formula->GROUP and enter:

sum({@in2007},{table.patientID}) = 0

Suppress the detail section and just show the group header with the patient's name.

-LB

 

[wgechter]

BRILLIANT, Works perfectly. Thanks much