Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: 2008 Alert (Doesn't match) Post Reply Post New Topic
Author Message
jclinton
Newbie
Newbie
Avatar

Joined: 24 Sep 2015
Location: United States
Online Status: Offline
Posts: 6
Quote jclinton Replybullet Topic: 2008 Alert (Doesn't match)
    Posted: 06 Oct 2015 at 8:45am
Hello everyone,
 
  I am brand new to Crystal Reports. I am using 2008 and am stuck on an alert I am trying to create. I want the alert to look at 2 database fields and show me the records that do not match. Each field will have a Y or an N. They need to be the same. So if they are not I want the alert to show me those. Is there a match funcaiton or something similar that I can't find? I have looked through the help and on here, but didn't find what I was looking for.
 
Thanks for any assistance.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 07 Oct 2015 at 3:01am
I am not sure you want an alert for this but rather a resulting report. Alerts are a 'pop up' message to 'alert' the user to something specific about that report, not really a feature for showing a resulting set of report rows.
IP IP Logged
jclinton
Newbie
Newbie
Avatar

Joined: 24 Sep 2015
Location: United States
Online Status: Offline
Posts: 6
Quote jclinton Replybullet Posted: 07 Oct 2015 at 4:47am
  Well I have this report that is used for various reasons and by different people. It also has the information in it that I am creating this alert off of. So I figured when running this report it would alert me if these two feilds ever do not match when I run this report. Then I can choose to view the records. This will give me the list that I need to correct through the systems frontend.
 
  It currently has 2 other alerts that save the user from having to do mulitple groups to narrow down what they want. When they open the report, they click on those records if they want to narrow down the information as per the alert's conditions or just view the report as a whole if they choose.
 
   
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 07 Oct 2015 at 9:10am
so you are referencing using the 'view records' button in alert the pop up?
just use the formula
NOT(table.field1 = table.field2)

Edited by DBlank - 07 Oct 2015 at 9:10am
IP IP Logged
jclinton
Newbie
Newbie
Avatar

Joined: 24 Sep 2015
Location: United States
Online Status: Offline
Posts: 6
Quote jclinton Replybullet Posted: 07 Oct 2015 at 10:08am
Thanks that worked. I actually ended up making a seperate report just for this data. Then I created an alert with (table.field1) <> (table.field2). I also got rid of my nulls. I read on here someone was having an issue with that so I am not sure if that helped or not.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 07 Oct 2015 at 10:22am
unless you tell it how to handle NULL values it will exclude the result so
NULL <> 'Y' would be exclude from the evaluation results.
As a rule of thumb, when creating a formula there is a drop down choice on how to handle null values. Set it to 'use default values for nulls' and it eliminates the above exclusionary issue.
IP IP Logged
jclinton
Newbie
Newbie
Avatar

Joined: 24 Sep 2015
Location: United States
Online Status: Offline
Posts: 6
Quote jclinton Replybullet Posted: 08 Oct 2015 at 1:58am
Okay great. Thanks.
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.023 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.