Skip to Content

Crystal Report - Display Group outside of Date range parameter

Oct 06, 2017 at 04:48 PM


avatar image
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!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Abhilash Kumar
Oct 06, 2017 at 05:04 PM

Hi Andrew,

How are the Clinician, Client and Appointment tables joined?

Could you please post a screenshot?


10 |10000 characters needed characters left characters exceeded