Parenths...question

[erikhertzel]

All

Progress Database CR 8.5

I had a similiar question a few days ago. I am trying a report that has three parameters:

A product group
Date range
Customer ID

Here is my formula

{OrderDtl.UnitPrice} <> 0.00

and

(
(
{OrderHed.OrderDate} = {?Month}
)
or
(
{OrderDtl.ProdCode} = {?ProductGroup}
)
or
(
{Customer.CustID} = {?CustomerID}
)

)

My expected results are if I pick any of the three, 1/3, 2/3, and all three

So, if I had a group of A and a range between May and June and Cust ID = 1 and put all these in then I would get my 1 result. But, if I only choose 1 or 2, I get a bunch more records. If I put and's in instead of the or's, then it works except when I don't input all three.

I am a slow learned at these parenthesis issues

Thanks,

Erik

 

[erikhertzel]

I am sorry....here is the entire formula

{OrderDtl.UnitPrice} <> 0.00

and

(
(
{OrderHed.OrderDate} = {?Month}
)
and
(
{OrderDtl.ProdCode} = {?ProductGroup}
)
and
(
{Customer.CustID} = {?CustomerID}
)

)

Thanks

Erik

 

[erikhertzel]

I am sorry. Disregard my last post. The entire post was fine and the 2nd post was not.

Regards.

Erik