Skip to Content
avatar image
Former Member

Crystal Report - Display Group outside of Date range parameter

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 06, 2017 at 05:04 PM

    Hi Andrew,

    How are the Clinician, Client and Appointment tables joined?

    Could you please post a screenshot?

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded