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!

Not a formula wizard. Please help 1

Status
Not open for further replies.

Aestas

IS-IT--Management
Apr 26, 2006
7
US
I have a report that I would like to omit records if the line is a closed release on a job. It's a Boolean field. I just want to drop the record from the selection.
Any suggestions?

Something like if {OrderRel.OpenRelease} = "False" then ???
 
Go to Report->Selection Formula->Record and placed:

not({OrderRel.OpenRelease})

That would include the False ones, or if you want to eliminate the False ones, use:

{OrderRel.OpenRelease}

If the above gives an error then try:

{OrderRel.OpenRelease} = true

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top