Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Problem using OR statements to get correct data to Post Reply Post New Topic
Author Message
BadBoyHouse
Newbie
Newbie


Joined: 25 May 2010
Online Status: Offline
Posts: 20
Quote BadBoyHouse Replybullet Topic: Problem using OR statements to get correct data to
    Posted: 07 Feb 2013 at 5:39am
Hi guys wondering if anyone can help me on this.

I've created a report which has four columns: Client Name, Newsletter Choice 1, Newsletter Choice 2 and Newsletter Choice 3.

The Newsletter Choice fields are True/False fields from an SQL database.

For any given client on the database they may have a True in one, two, or three of the Newsletter Choice fields.  

I need the report to pick out clients where one or more of the Newsletter Choice fields is True.

In the Selection Formula's section I've tried the following which didn't work:

(
{tblDataTable.Newsletter_Choice_1} = True
or
{tblDataTable.Newsletter_Choice_2} = True
or
{tblDataTable.Newsletter_Choice_3} = True
)

Appreciate any pointers anyone could give me.

Cheers
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 07 Feb 2013 at 5:53am
Your select statement looks fine.
do you have nulls instead of False?
if so that would kill your statement on those rows if it hits a null before a true.
inside the select statement editor use hte drop down on how to handle nulls and set it for 'use default values for nulls'
IP IP Logged
BadBoyHouse
Newbie
Newbie


Joined: 25 May 2010
Online Status: Offline
Posts: 20
Quote BadBoyHouse Replybullet Posted: 08 Feb 2013 at 12:59am
Thanks DBlank - that fixed it.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2025 Brian Bischof. All Rights Reserved.