Skip to Content
0

Crystal Report - Display Group outside of Date range parameter

Oct 06, 2017 at 04:48 PM

26

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!
Thanks

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
0

Hi Andrew,

How are the Clinician, Client and Appointment tables joined?

Could you please post a screenshot?

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded