Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: eliminating results Post Reply Post New Topic
Author Message
smccomish
Newbie
Newbie
Avatar

Joined: 10 Sep 2013
Location: United States
Online Status: Offline
Posts: 13
Quote smccomish Replybullet Topic: eliminating results
    Posted: 10 Sep 2014 at 5:34am
I need some help writing a formula.

I am pulling data that matches:

{FSSetup.Description} like ["Policy Complete*", "Policy typed*", "Sirva Insuring*"]

These fields can be marked "NA" which equals 1

{FSLog.NotApplicable} = 0

I am trying to create a formula that says

IF "Policy complete*" or "Policy typed*" = 1
AND
"Sirva Insuring*" = 0
Then don't show.


Does this make sense?

Also, i believe i will need to convert the number of 0 & 1 to a string.

THanks for the help!!!!

Edited by smccomish - 10 Sep 2014 at 9:24am
Thanks for your help!!
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 10 Sep 2014 at 9:41am
Is this happening at group level (reviewing multiple rows for data) or is all evaluation happening in a single row?

Edited by DBlank - 10 Sep 2014 at 9:41am
IP IP Logged
smccomish
Newbie
Newbie
Avatar

Joined: 10 Sep 2013
Location: United States
Online Status: Offline
Posts: 13
Quote smccomish Replybullet Posted: 10 Sep 2014 at 10:07am
Sorry, i am not sure what that means. Here is an example of a file that shows up twice on my report.

File No.   Comp.By     Comp.Date N/A? Description
3098Rsec   Jeremy K    4/15/14     1   Policy complete
3098Rsec   Jaclyn D    4/15/14     0   Sirva Insuring
Thanks for your help!!
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 10 Sep 2014 at 12:00pm
I think I understand basically what yuo want to do. YOu need to get rid of both rows based on the criteria across multipel rows.
Youc an do this in a stored proc before getting the data into the report or you can handle this in group select criteria.
basically you need to create a group on the primary field for the records (file No field), create "flag" formulas that allow you to determine based on the summary of the flags which groups to keep and which to discard.
example:
//flag1
IF description in ("Policy complete*","Policy typed*") and N/A= 1 then 1
//flag2
If description = "Sirva Insuring*"  and N/A=0  then 1
 
now sum flag 1 and flag 2 at your group footer.
If both sums are > 0 then this is a group to discard so use that logi in the group select criteria
NOT(SUM(flag1,fileno)>0 and sum(flag2,fileno)>0)
 
 
//flag


Edited by DBlank - 10 Sep 2014 at 12:02pm
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.031 seconds.