Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: How to determine specific records in the suppress Post Reply Post New Topic
Author Message
Nav522
Senior Member
Senior Member


Joined: 25 Aug 2009
Location: United States
Online Status: Offline
Posts: 166
Quote Nav522 Replybullet Topic: How to determine specific records in the suppress
    Posted: 10 Apr 2018 at 8:53am
How do I conditionally filter the details data so that I can only see output below..

The Record selection formula for the whole report is this
REVERSALCODE in ["R","S"]

Current data

SRCCOD AGTID       POL      REVERSAlCODE    AMOUNT

VF      2021640     35727382     R            0
VF      2036540     35727382     R            436
VF      2036540     35727382     R            327

VF      000038624    35727445     R          4350
VF      000038624    35727445     S          -4350

VF      000002453   35727486      S           264
VF      000002436   35727486      S           456     

OUTPUT REQUIRED: Only want to see the policies that have both "R" and "S" and ignore the rest.

VF      000038624    35727445     R          4350
VF      000038624    35727445     S          -4350
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 11 Apr 2018 at 2:44am
Group on the policy
Create two formula fields to
//HasR
if REVERSALCODE = 'R' then 1 else 0
//HasS
if REVERSALCODE = 'S' then 1 else 0
create two group summaries of these formula fields
now any group that has a sum>0 for both summaries is your condition so add a group select condition
sum(@HasR,AGTID)>0 and sum(@HasS,AGTID)>0
IP IP Logged
Nav522
Senior Member
Senior Member


Joined: 25 Aug 2009
Location: United States
Online Status: Offline
Posts: 166
Quote Nav522 Replybullet Posted: 12 Apr 2018 at 4:52am
Hi there thanks for the explanation of the formulas.

It worked like a charm.

Edited by Nav522 - 12 Apr 2018 at 5:32am
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.