Visual Basic/VB, Suppress function in crystal report!

sa
#1 / 3

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

Chris Ames
#2 / 3

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

jose simoe
#3 / 3

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