Specific Selection Parameters

[donnarenia]

I have a report that gives me the commisions on a salesperson. I use the following Selection formula:

{CLNTCUS.~Custom3} = {?Employee} and
{@DatesRemaining} < 13.00 and
{AR.InvoiceDate} = {?Invoice Date} and
{AR.Type} = "I"

I want to add a second salesperson field {CLNTCUS.~Custom21) and receive the same information except Salesperson 2 has a different commission rate. I added the fileds into Details B but I am receiving duplicate information. I only want to see Salesperson 2 if it is available.

Can anyone please help me with this?

 

[Madawc]

If the first salesperson is always there, then you are on the right lines. When you need to do is suppress the extra detail line using a formula, probably

isnull({CLNTCUS.~Custom21})
or {CLNTCUS.~Custom21} = 0

Right-click on the section and choose Section Expert. Then choose the formula icon (x+2 and a pencil) for suppression.


Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP