PARAMETERS WON'T WORK 1

[marabou]

I hope someone could help me with this as I am completely stuck.

I have a report which displays one group when a particular variable is true and another when it is false. However, I also need to put parameters based on both groups which I have, and which work.

But, any other parameters I have put in do not work, it is as if they are not there.

Here is my record selection criteria

{PRODUCTS.NAME} = {?Product(s)} and
{CUSTOMERS.NAME} = {?Customer(s)} or
{CUSTOMERS.NAME} = {?Agent(s)} or
{CUSTOMERS_AGENTS.NAME} = {?Agent(s)} or
{CUSTOMERS_AGENTS.NAME} = {?Customer(s)} and
{LICENCES.EXPIRYDATE} in {?Beginning of period} to
{?End of period} or
{LICENCES.EXPIRYDATE} = {?Beginning of period} and
{LICENCES.EXPIRYDATE} = {?End of period}

The part about the customers and the agents works, as does the products (the product grouping is above the agent/customer groups, and the licence expiry date are in details, if that is any help), but the licences expiry date doesn't, as is the same with anything else I have put in there.

I have tried doing it every which way, in every order, but it still doesn't work.

The Customers/Agents name selection only works that way, so I can't change that.

Hope somebody can help

Thanks, in advance

 

[kenhamady]

When you mix "And " and "OR" like you have, you will probably need parenthesis to keep them in the right logical order. Otherwise the logic is ambiguous.

Take the two groups of conditions that are connected by an "OR" and put each of these two groups in a pair of parenthesis:

A and
(B or C or D or E) and
(F or G) and
H
Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[marabou]

Thankyou very much, that worked!