How to determine specific records in the suppress
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22573
Printed Date: 29 Apr 2024 at 7:31pm
Topic: How to determine specific records in the suppress
Posted By: Nav522
Subject: How to determine specific records in the suppress
Date 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
|
Replies:
Posted By: DBlank
Date 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
|
Posted By: Nav522
Date Posted: 12 Apr 2018 at 4:52am
Hi there thanks for the explanation of the formulas.
It worked like a charm.
|
|