Supressing + conditions 1

[stuckonCrystal]

Hi all,

I need some help with creating a report that takes in values to display different content.

Here are the 2 conditions of the report:
1.Report takes in a value and check to see if it has a future appt date, then display certain blob of text
2.Report takes in a value and no future appt date is scheduled, then display blob of text.

I am setting my blob of text in 4 differnt grouped footer areas. I have also created the conditions of checking to see if certain value is passed in. However, I am not sure how to check the future appt date with the current appt date time.

Am i on the right track? Should I be using subreports? I am trying to eliminate subreport.

Any help is wanted. Thank you in advance.

stuckonCrystal

 

[lbass]

Try comparing {Table.apptdate} with the currentdate, as in the following suppression formulas:

maximum({table.apptdate},{table.groupfield}) <= currentdate //or

maximum({table.apptdate},{table.groupfield}) > currentdate

-LB

 

[stuckonCrystal]

Hi LB,

What is the table.groupfield are you referring to? Is it the table.field from : of Group footer name?

Thank you for your quick response.

stuckonCrystal

 

[lbass]

You said your text objects were in a group footer, so you would substitute your group field for {table.groupfield}. Similarly, you would substitute your actual appointment date field for {table.apptdate}. I'm guessing your group field is something like a patient or customer ID.

-LB