tying to show the client once even when the client has had multiple co 2

[willpp]

if isNull({CLCONT.Type}) THEN "UDES"
ELSE 'BLANK'

what i am trying to do is show clients that have not had a "UDES"({CLCONT.Type}) when i put paramiter of does not = UDES the reports shows all the other contacts that the client has had how do you show the client once

 

[Madawc]

To clarify, you want to see clients who have had at least one record, but no record where {CLCONT.Type} is null?

To see that, group by client. Suppress the group header and details, showing the client information in the group footer.

Create a running total that counts the number of records where {CLCONT.Type} is null, and is reset for each group.

Conditionally suppress the group footer. Right-click on the section and choose Section Expert. Choose the formula icon (x+2 and a pencil) for suppression. Enter a formula that checks the count for being greater than zero, so those cases will not be shown.

If you're not already familiar with Crystal's automated totals, see FAQ767-6524.



Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[willpp]

Hi sorry

what i am trying to to is

if client has a 'UDES' CONTACT TYPE show clients
and if client has not had this contact show as blank
only problem at present when binging in the contact type field it shows all the contact that the client has had
ie
paul has had a 'UDES' CODE and also a 'INF' CODE is shows like this
paul has had a 'UDES' CODE
paul has had a 'INF' CODE

John has had a 'inf' code and also
John has had a 'pin' code

what i am trying to do is show Paul with a 'UDES' CODE and
John that has had contact but not a 'UDES' CODE but show this as a blank

this can be done by a subreport but i would like to not use a subreport

 

[lbass]

Create a formula like this:

if isnull({CLCONT.Type}) or
{CLCONT.Type} <> "UDES" then
"" else
{CLCONT.Type}

Do not use this for record selection, but instead, use it in place of your code field. Formate the fields in the detail section with "suppress if duplicated".

-LB