Print Page | Close Window

Filtering out the Group records on a condition 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=22634 Printed Date: 01 May 2024 at 8:08pm Topic: Filtering out the Group records on a condition Posted By: Nav522 Subject: Filtering out the Group records on a condition Date Posted: 28 Jun 2018 at 8:01am I have a report where i'm trying to filter out the records in a group but the formula is not working Selection Formula(Group) I have now in Group record filter is ProcessDt in ProcessDt and SUM(CALCAMT) = SUM(RETAMT) Data is below I have grouping on PID Scenario#1 Detail :ProcessDt PID TransID CALCAMT RETAMT DIFF            5/25     1234   DU   1500    3000               5/25 1234    RC    0      3000                          5/25   1234   DU    1500    3000 Data I wanna see on GF is below GF          5/25   1234       $3000 $3000 $0      Scenario#2 Detail :ProcessDt PID TransID CALCAMT RETAMT DIFF            5/28     7658   DU     390      190               5/28 7658      RC    0     190                          5/28   7658    DU     190    190            5/28    7658   DU    0       190 Data I wanna see on GF is below GF     5/28    7658        $190    $190    $0        Replies: Posted By: Sastry Date Posted: 24 Jul 2018 at 12:52am Hi Go in Report-- Group selection formulas and try below SUM(CALCAMT,{PID}) = SUM(RETAMT,{PID}) Also not getting how you want to filter on ProcessDt, it is a column and you can't compare values in a column without previous() or Next(). Thanks, Sastry ------------- Thanks, Sastry

Print Page | Close Window