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
claimno,billno,billamt"



Mon, 19 Jan 2004 15:07:51 GMT  
 Suppress function in crystal report!
1. Right Click on the field you want to supress
2. select "Format Field" from the pop-up menu
3. select the common tab
4. move down the dialog box and check the "Supress if duplicated" check box
5. Click the OK button.

Hey presto!

HTH

Chris


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 15:55:56 GMT  
 Suppress function in crystal report!
Hello,

-right click the field
-change format
-suppress if duplicated
best regards

Quote:
>-----Original Message-----
>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

- Show quoted text -

Quote:
>and chqamt"

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

>.



Tue, 20 Jan 2004 18:40:38 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 studio.net

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