VB Crystal Report >> suppress if duplicate

by William E Voorhees » Sun, 01 May 2005 13:11:11 GMT

I have data fields printing in a group footer, some of which, are repeated.
I have checked the "suppress if duplicated" choice when formatting the field
but the duplicates print any way.
Any thoughts?

for ex.

Job number name total of hours
1 bill 100
1 John 200
1 Bob 250

I would like to print "1" only once.




VB Crystal Report >> suppress if duplicate

by Briscobar » Mon, 02 May 2005 00:39:19 GMT


"Suppress if duplicated" only works within a group. So, since this is the
group footer, and these are each printing in separate groups, then they're
not duplicated. They are, but they're not...if that makes any sense.

--
KB

MCNGP #26


repeated.
field





VB Crystal Report >> suppress if duplicate

by christian kuendig » Mon, 09 May 2005 03:00:32 GMT

Don't know if it helps in your case...

I have dupressed the 1 by adding an expression for "supress" for the
field-object like :

{*myfiled*}=Previous({*myfield*}

Hope this helps

Chris

"William E Voorhees" < XXXX@XXXXX.COM > schrieb im Newsbeitrag





Similar Threads

1. problem using 'Suppress if duplicated' with a field in a Crystal report

I have a field which I do not want to put in the Group Header, but
keep in the Details section.  I selected 'Suppress if duplicated', but
it still duplicates.
Here's an example:

What I want to show in the report details section:


A  1
   2
   3
   4
B  1
   2
   3
   4

What actually shows:

A  1
A  2
A  3
A  4
B  1
B  2
B  3
B  4

like I said, I don't want 'A' and 'B' as Group Headers on a separate
line, I want their first occurence to be on the same line as their
first corresponding detail field ('1')...

thanks in advance...

2. Suppress if duplicated still uses space on the page - VB Crystal Report

3. suppressing near duplicates


i'm interfacing with a hotel database that tracks reservations.
occassionally there is a cancellation or a no-show that shows up, which is
fairly easy to take care of.

my problem at the moment is when the operator inputs a second record for the
same reservation, so that the database shows two records, completely
identical except for the reservation number. how do i check one number
against another, that has the same fields?

for example:

guest number               arrival    departure   room number
56278                        10/11/03   10/2/03   1110
56279                        10/11/03   10/2/03   1110

with this, i'm calculating room nights. and i can only have one room night
per room per night. there is other data available, but i have to use the
guest table because all other data over 120 days gets compiled in this
database and loses a lot of its integrity.

if anyone knows a work around formula, i'd be most obliged.


thanks in advance.

4. Suppress Subreport when duplicated - VB Crystal Report

5. Suppressing if a different field is duplicated

I can suppress one field if duplicated, but what if I want to suppress
another field if the first field is duplicated?  -- and then of course,
suppress then section if blank.There has to be a way. 

TA

6. suppressing duplicate results - VB Crystal Report

7. Suppress field if another field is suppressed

Is there a way to refer to report objects in the formula editor? I'd
like to suppress fields depending upon if another field in that detail
section is suppressed. The original suppressed field is done via the
SUPPRESS IF DUPLICATED checkbox. However, I can't use this option on
the other textboxes since their data may be the same from the previous
line. If you see my example, I suppress the Seq column if duplicated.
Now I want to suppress the State and Case values on that line as well
(the ones in parentheses). I can't suppress if duplicated since the
State from the previous sequence is the same, and it's possible the
Case can match as well.

Seq   State   Case   Desc
------   ---------  --------  ------------------
1        IN       123     asdf
2        IN       234     asdf
         (IN)    (234)     sdfg
3        IN       432     asdf
         (IN)    (432)     sdfsd
4        IN      432      xcvcv


I was hoping in the Suppress rule I could do something like:  Not
txtSequence.Visible
But that gives me an error.

I know I can accomplish this by changing the report source and then use
a subreport for the descriptions, but I was hoping for a less-obtrusive
solution.

Thanks for your time,

Jason

8. suppress section if subreport is suppressed but the section is not empty - VB Crystal Report