Asked: Apr 23 2008 7:09 PM GMT
Asked by: LouJ
Formula workshop - using AND/OR
Crystal Reports,
Formula Workshop
Using the formula workshop, I am trying to display all records from 10am to 11am that have EITHER data in "field A" OR data in "field B". What is returned are records in the correct time frame (10am-11am), that have data in the "field A", however the records that have no data in "field A" but do in "field B" are not returned. If I switch the order of both these fields then I only get records if there is data in "field B".
Whichever field I place after the OR is not working.
Does anyone have any ideas? Thanks!
Here is the formula with the actual field names:
({Termination_Call_Detail.DateTime} in DateTime (2008, 04, 21, 10, 00, 00) to DateTime (2008, 04, 21, 11, 00, 00))
and
({Termination_Call_Detail.SourceAgentPeripheralNumber} <> ""
or
{Termination_Call_Detail.AgentPeripheralNumber} <> "")