Selecting information in a date range

[trivalent]

Hello everyone. Currently using Crystal report 11. I am currently creating a report and I have it Grouped like this.
history_diagnosis.PatID
history_diagnosis. date_of_diagnosis.

In the details section I have the following fields
date_Of_service, GuarantorID, guarantor_liability.

What I am trying to do is capture all dates of service for a date range. I am using two parameters, Start Date and End date.

My problem is a client has a primary Diagnosis, that Diagnosis can changed. Example client 123 is given a diagnosis of X on 1/11/2008 and then on 6/6/2008 client 123 diagnosis is changed to a diagnosis of Y. Then on 9/1/2008 client 123 diagnosis is changed or updated again to a diagnosis of Z.
I want to print the dates of service for the diagnosis that covers the dates between Start Date and End Date. Currently all dates of service are printing for all the gouped diagnosis's.
Thanks for you help.

 

[kskid]

What do you have in your record selection? It should contain the following

{history_diagnosis.date_of_diagnosis} in [{?StartDate} to {?EndDate}]

 

[trivalent]

In the record selection I have this:
{billing_tx_history_2004.date_of_service} in {?Start Date} to {?End Date}
because I am trying to capture the dates of service. this is what I want but when the report prints is printing for all of the dates of Diagnosis. so if the client has lets say 3 different Diagnosis. The report is printing the dates of service 3X's. I just want to print the dates of service once.

 

[kskid]

If multiple dates exists for a patient, which one do you want listed?

Delete the date group.

you can enter the following in the group selection formula

{history_diagnosis.date_of_diagnosis} = maximum({history_diagnosis.date_of_diagnosis}, {history_diagnosis.PatID})