View Single Post
Old 07-31-2019, 07:38 AM   #1
Just Livin the Dream!
Join Date: Mar 2012
Posts: 135
Thanks: 31
Thanked 9 Times in 9 Posts
jedder18 is on a distinguished road
rpt runs with 2 parameters that must be true

The field admin_nbr_value is a multiselect.

I want the report to run only if there is an "Initial" and "Termination" selected from admin_nbr_value field; which means the client filled out 2 separate forms.

Each form has data associated with it that is being aggregated to show increase/decrease in findings.

If there is no Termination form, I don't want the Initial form and value fields to show.

The below only will show the Term data
Using Crystal 13

IF ({cc_parent_rating.p_survey_admin_nbr_Value}) = "Termination" THEN

{cc_parent_rating.p_survey_admin_nbr_Value} in ["Initial", "Termination"] and

{cc_parent_rating.p_rating_date} in {?StartTermDate} to {?EndTermDate}

All suggestions welcome...

jedder18 is offline   Reply With Quote