I want my report to display customers whose order totals fall into certain ranges, but the order totals are a calculation (the orders are on the database as separately, but I'm using a formula to get the total of the orders). I need to create a parameter based on that formula, so that I can use conditional formatting to only show customers whose order totals fall into the selected ranges.

 

How could I do this in a different way?

 

My formula looks like this:

 

({?Range Select}="< 101" and Sum ({HORDHDR.ORDERTOTAL},{HORDHDR.CUSTNO}) >100.99)
or
({?Range Select}="101-1000" and Sum ({HORDHDR.ORDERTOTAL},{HORDHDR.CUSTNO})  <> 101 to 1000.99)
or
({?Range Select}="1001-2500" and Sum ({HORDHDR.ORDERTOTAL},{HORDHDR.CUSTNO})  <> 1001 to 2500.99)

etc.

 

So the formula is saying: suppress this section when the parameter chosen is "< 101," and the totals come to more than 101, so all the totals I want are shown. But when I select more than one range, they cancel one another out and no values are shown. How can I fix this?