Get date range

[BettyJ]

I need help with a report.

Patients are considered to be of a specific type say, XXX when they have an value of Yes in ObsID 999999(dummy). They will have Yes for a while. Then they can be a regular patient (Obs will be No). After sometime they can again have Yes in Obs.

Sample values (Grouped by Pt)
Pt ObsDate Obs ObsID

AAA 08/09/2012 Yes 999999
AAA 11/01/2013 No 999999
AAA 12/26/2013 Yes 999999

BBB 1/18/2013 Yes 999999
BBB 11/04/2013 No 999999

CCC 08/03/2012 Yes 999999

First value of a pt is supposed to be Yes always. Values are supposed to alternate between Yes and No.

I am trying to create a report that list the appointments pts of XXX type had with a selected provider (parameter) within a specified date range (Parameters – DateFrom and DateTo.)

Can someone please help me with this. First, I need to get the dates when the pts were of XXX type.

Thanks in advance.

 

[Charliy]

Select formula:
{ObsDate} in {?DateFrom} to {?DateTo} and {Obs} = "YES