Hey,
I am trying to only show groups that are within a total range that the user is passing it. In this case I am prompting the user to enter a minimum and maximum amount. I want my report to show only the groups that have a sum in that range. I tried putting the following code in the group suppression expression builder, I don't get any errors but I do get totals showing up that aren't in the range.
Code:{?Minimum Amount} > Sum ({Order_Header.Order_Header_Total_Retail}, {Order_Header.Order_Header_Agent_Number}) or {?Maximum Amount} < Sum ({Order_Header.Order_Header_Total_Retail}, {Order_Header.Order_Header_Agent_Number})




Reply With Quote