rpt runs with 2 parameters that must be true (1 Viewer)

jedder18

Just Livin the Dream!
Local time
Today, 02:36
Joined
Mar 28, 2012
Messages
135
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...
 

Ranman256

Well-known member
Local time
Today, 05:36
Joined
Apr 9, 2015
Messages
4,337
you can put the values on the form and not let users see them. set visible= false
then the report is:

if txtTermination.value and txtInitial.value then docmd.openreport "rMyReport"
 

nuduniz

New member
Local time
Today, 14:36
Joined
Oct 25, 2021
Messages
1
i love this
 

Users who are viewing this thread

Top Bottom