Formula workshop – using AND/OR

5 pts.
Tags:
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} <> "")

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following