Suppress duplicate records! 
Author Message
 Suppress duplicate records!

My current report display like this:-
Claimno    Chqno     Chqamt       billno    billamt
-----------------------------------------------
123         00001     $150          C0001  $50
123         00001     $150          C0002  $50
123         00001     $150          C0003  $50
456         00002     $50            B0001  $500
456         00003     $450          B0001  $500

How to switch my report become like this:-
Claimno   Chqno     Chqamt       billno    billamt
-----------------------------------------------
123         00001     $150          C0001  $50
                                                C0002  $50
                                                C0003  $50
456         00002     $50            B0001  $500
               00003     $450

Can anyone teach me how to suppress the record as below condition:-

1)If "duplicate claimno " and "duplicate chqno" then "suppress claimno,chqno
and chqamt"

2)If "duplicate claimno" and "duplicate billno" then "suppress
claimno,billno,billamt"



Mon, 19 Jan 2004 15:07:07 GMT  
 Suppress duplicate records!
1)  Right-click 'claimno' and click the 'x+2' button to the right of
'Suppress.'  Write the formula:
        Claimno = Previous(Claimno) and Chqno = Previous(Chqno)
    Copy this into the suppression formulas for the 'Chqno' and 'Chqamt'
fields.
2)  Follow the same process as described in step 1.

Bob Holmes


Quote:
> My current report display like this:-
> Claimno    Chqno     Chqamt       billno    billamt
> -----------------------------------------------
> 123         00001     $150          C0001  $50
> 123         00001     $150          C0002  $50
> 123         00001     $150          C0003  $50
> 456         00002     $50            B0001  $500
> 456         00003     $450          B0001  $500

> How to switch my report become like this:-
> Claimno   Chqno     Chqamt       billno    billamt
> -----------------------------------------------
> 123         00001     $150          C0001  $50
>                                                 C0002  $50
>                                                 C0003  $50
> 456         00002     $50            B0001  $500
>                00003     $450

> Can anyone teach me how to suppress the record as below condition:-

> 1)If "duplicate claimno " and "duplicate chqno" then "suppress
claimno,chqno
> and chqamt"

> 2)If "duplicate claimno" and "duplicate billno" then "suppress
> claimno,billno,billamt"



Mon, 19 Jan 2004 20:01:29 GMT  
 Suppress duplicate records!
Hey Essay, What's happenin man! (sorry ... couldn't help it)

   When you right click the field in question, there is an option in
"format field" called "surpess duplicates" ... just click the check
box.  I'm not sure is this is exactly the answer you are looking for
... but it may be a good start.

Good Luck Homes...

Jamie

Quote:

> My current report display like this:-
> Claimno    Chqno     Chqamt       billno    billamt
> -----------------------------------------------
> 123         00001     $150          C0001  $50
> 123         00001     $150          C0002  $50
> 123         00001     $150          C0003  $50
> 456         00002     $50            B0001  $500
> 456         00003     $450          B0001  $500

> How to switch my report become like this:-
> Claimno   Chqno     Chqamt       billno    billamt
> -----------------------------------------------
> 123         00001     $150          C0001  $50
>                                                 C0002  $50
>                                                 C0003  $50
> 456         00002     $50            B0001  $500
>                00003     $450

> Can anyone teach me how to suppress the record as below condition:-

> 1)If "duplicate claimno " and "duplicate chqno" then "suppress claimno,chqno
> and chqamt"

> 2)If "duplicate claimno" and "duplicate billno" then "suppress
> claimno,billno,billamt"



Tue, 20 Jan 2004 03:06:09 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. How to suppress duplicate records

2. Crystal: duplicate data in table need to filter with record selection not suppress field

3. I am getting duplicate records, I mean everything is duplicate even Access record number

4. Data Report - Suppress Field If Duplicate

5. Suppress If Duplicated

6. Suppress if duplicated doesn't work MK II

7. Suppressing duplicates

8. Suppress if duplicated - Multi-line fields

9. suppress error 3021 no current record message

10. Suppressing Groups but the records are still grouped

11. Conditional Suppressing record

12. Suppressing Records

 

 
Powered by phpBB® Forum Software