Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Sales Orders having 2 different fields Post Reply Post New Topic
Author Message
customreport
Newbie
Newbie


Joined: 26 Jan 2011
Location: United States
Online Status: Offline
Posts: 28
Quote customreport Replybullet Topic: Sales Orders having 2 different fields
     Posted: 06 Apr 2011 at 4:58am
I am trying to filter a report to include sales orders having two specific items.  My report needs to show all open sales orders having doors and lite kits.  I have filtered the report to only include doors and litekits and have grouped the report by sales order number with a count summary and filtered the count to be greater than 1.  This almost worked, but some orders have more than one door on the order and no lite kits.  The distinct count summary will return the same result because the they are different type doors.  Ex. DR Foam-H, DR Foam-UL.  Any ideas of how to resolve this?
customreport
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 06 Apr 2011 at 5:38am
create 2 formulas to flag each type and use the SUM of these at the group level
kitflag
if field = kit criteria then 1
doorflag
if field = door criteria then 1
group select criteria as
SUM(@kitflag,order#)>0 and SUM(@doorflag,order#)>0
IP IP Logged
customreport
Newbie
Newbie


Joined: 26 Jan 2011
Location: United States
Online Status: Offline
Posts: 28
Quote customreport Replybullet Posted: 07 Apr 2011 at 8:10am
Thank you that solved my problem
customreport
IP IP Logged
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