Crystal Report - Display Group outside of Date range parameter

[Former Member]

Hello everyone,

I have a report that is grouped by Clinician and then Client as second group. The details are showing appointment dates, appointment time, and service for the client. I have parameters to select clinician and a Date range parameter. The problem is when a Client doesn't have an appointment within that date range, that client isn't shown. Is there a way to still display those clients without a a schedule appointment? In select expert my formulas look like this:
{v_case_clinician.add_client_Value} = {?Practitioner} and {appt_data.appointment_date} in {?Begin Date} to {?End Date}

Please help!
Thanks

[abhilash_kumar]

Hi Andrew,

How are the Clinician, Client and Appointment tables joined?

Could you please post a screenshot?

-Abhilash