Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Let me try this another way Group selection formula

Status
Not open for further replies.

Newbi1

Programmer
Apr 4, 2005
64
US
Is there a way to get a group slection formula where it will not display unless at least 1 record has a due date less than today? If it does, I need all records to dispplay if it does not nothing can display including the group headers and details.

How do I evaluate this?
 
Create a formula {@due<today}:

if {table.duedate} < currentdate then 1 else 0

Then go to report->edit selection formula->GROUP and enter:

sum({@due<today},{table.groupfield}) > 0

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top