Suppress function in crystal report!! 
Author Message
 Suppress function in crystal report!!

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

Mon, 19 Jan 2004 15:11:03 GMT  
 Suppress function in crystal report!!
Right Click the affected field and choose Format
In The Dialog box there should be A "Suppress if Duplicated" check box
Tick it and only the first instance of and entry becomes displayed

David Dewhurst

Mon, 19 Jan 2004 18:01:04 GMT  
 Suppress function in crystal report!!
Although It Wouldnt work for the ChqAmount Field
To Suppress That You Would a formula field Something Like

If Not IsNull({Claims.Chqno}) Then {Claims.Chqamt}

Be Aware That I Am Not Checking The Nullness (that right?) of the Database
Field(ChqNo), In the formula maker I picked the Report Field(ChqNo).

This presumes you did the previous thing of auto suppressing the first two

David Dewhurst

Mon, 19 Jan 2004 18:29:13 GMT  
 [ 3 post ] 

 Relevant Pages 

1. Suppress function in crystal report!

2. Crystal Reports/VB3 Pro - Suppressing message screen ?

3. Crystal Reports Suppressed

4. Printing Crystal Reports without Crystal Control ActiveX or Crystal Reports API call

5. Data Report Object - Suppressing repeated rows in a report column

6. Suppress Main Reports Page Header on sub-report

7. Linking Crystal Report with a stored Procedure -- crystal report for visual

8. Crystal Report 6 and Crystal Report 8

9. Crystal Report 6 and Crystal Report 8

10. Crystal Reports 8.5 (VB6) to Crystal Reports NET (VB.NET) conversion

11. vb .net crystal reports not compatible with Crystal Reports 8.5

12. Passing Parameters from C# to Crystal Report / Crystal Report Viewer


Powered by phpBB® Forum Software