Discard Duplicates on a Report CDD3.1 
Author Message
 Discard Duplicates on a Report CDD3.1

How the heck does one discard duplicates on a report in CDD 3.1

Here is what my report looks like:

Name                          Phone Number
------------------------------------------------------------
Mike                    555-1212 Fax
Mike                             555-1313 Phone
Mike                             555-1414 Data

I want it to look like this:

Name                          Phone Number
------------------------------------------------------------
Mike                    555-1212 Fax
                                    555-1313 Phone
                                    555-1414 Data

In FoxSlow I just hit a button and magic the report removes duplicates.

Thanks for all your help!

Mike Moskal

Systems Administrator for
{*filter*}link Network



Fri, 08 Jan 1999 03:00:00 GMT  
 Discard Duplicates on a Report CDD3.1

----------

Sent:  Monday, July 22, 1996 11:55 PM
To:  Clarion Mailing List
Subject:  Discard Duplicates on a Report CDD3.1

How the heck does one discard duplicates on a report in CDD 3.1

Here is what my report looks like:

Name                          Phone Number
------------------------------------------------------------
Mike                    555-1212 Fax
Mike                             555-1313 Phone
Mike                             555-1414 Data

I want it to look like this:

Name                          Phone Number
------------------------------------------------------------
Mike                    555-1212 Fax
                                    555-1313 Phone=20
                                    555-1414 Data

In FoxSlow I just hit a button and magic the report removes duplicates.

Thanks for all your help!

Mike Moskal

Systems Administrator for
{*filter*}link Network

Mike,=20
Inorder to answer your qwestion, I would have to see what your report =
design is  and how you are coding it.  Is this a report with three =
detail lines, or a single detail line that is refilled?

Terry=20

Prairie 21



Fri, 08 Jan 1999 03:00:00 GMT  
 Discard Duplicates on a Report CDD3.1

My approach is to define two detail lines, the  first (let's call it
DET1) contains the format you show in your first desired line.  The
second, DET2, contains the format for the continuation lines. The code
to make it print the way you desire would look sometihing like this:

PrevName" = ''
Set(PHO:ByName)
Open(Report)
Loop
  Next(Phones)
  If ErrorCode() then Break.
  If Upper(PHO:Name) <> PrevName"
    PrevName" = Upper(PHO:Name)
    Print(RPT:DET1)
  Else
    Print(RPT:DET2)
  End
End
Close(Report)



Sun, 10 Jan 1999 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. CDD3 (DOS): Arbitrary record selection in reports?

2. Duplicate detail section in Report

3. CW4 Report Finds Duplicate Record ???

4. Records duplicated in report

5. Duplicate a browse and report

6. Duplicating report on same page

7. Duplicating certain detail records in Report

8. Duplicate report on same physical page

9. Problem Duplicating Report Procedure Clarion 4

10. REPORTING-Duplicate Strings in files

11. Suppressing duplicate values in reports

12. Why do I get duplicate and extra lines from NI-Report subs

 

 
Powered by phpBB® Forum Software