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