How to supress entire row (not only column)
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20806
Printed Date: 07 May 2024 at 3:32pm
Topic: How to supress entire row (not only column)
Posted By: Beso90
Subject: How to supress entire row (not only column)
Date Posted: 12 Jun 2014 at 12:02pm
Hi there.. I use SAP Crystal Reports
I'm working on a report that has a running total field.
the columns are:
Date - Invoice # - Invoice Total - Manifest #
the report keeps repeating each line four times..
my table linking is correct, I'm 100% sure.
It repeats the rows because I'm pulling the manifest number which exists on each line item of every invoice...
I want some formula to suppress any duplicate invoice number...
I tried suppress if duplicate, but that only suppresses the column for the invoice # - it doesn't suppess the whole row which is what I want - because the running total keeps repeating and that throws off the whole report...
PLEASE HELP :(
|
Replies:
Posted By: Gurbs
Date Posted: 13 Jun 2014 at 12:34am
|
Can't you group it by invoice #?
|
Posted By: DBlank
Date Posted: 13 Jun 2014 at 6:39am
|
you can do as Gurbs suggests but note that a Running Total does not stop evaluating just because something is suppressed. You need to alter the evaluation condition in the RT itself, like using on change of a field and choose the invoice#
|
Posted By: hello
Date Posted: 17 Jun 2014 at 10:28am
For the detail section, place a check mark in the suppress box, click on X2, then:
{table.invoicenumber} = previous {table.invoicenumber}
|
Posted By: Beso90
Date Posted: 19 Jun 2014 at 5:24am
Gurbs: it helped a LITTLE by navigating what's duplicate and how many duplicates do I have - it's a temporary solution..
DBlank: Thank you for the note.
hello:
that didn't work, it says:
"The remaining text does not appear to be part of the formula."
This is what I have..
{V_CASHREC_DETAIL_ARINVOICE.INVOICE_NO} = previous {V_CASHREC_DETAIL_ARINVOICE.INVOICE_NO}
Thank you guys..
|
Posted By: hello
Date Posted: 19 Jun 2014 at 8:34am
Try this:
{V_CASHREC_DETAIL_ARINVOICE.INVOICE_NO} = previous ({V_CASHREC_DETAIL_ARINVOICE.INVOICE_NO})
|
Posted By: Beso90
Date Posted: 19 Jun 2014 at 11:12am
That worked! thanks SO MUCH!!!!!!!!!!!!!!!!!!
but now, the running total, as DBlank mentioned - is still counting the suppressed fields. Any idea how to stop that? and only count 1 line?
|
Posted By: kevlray
Date Posted: 20 Jun 2014 at 5:36am
If you are using a running total, then have it evaluate only when the fields are not suppressed ( {V_CASHREC_DETAIL_ARINVOICE.INVOICE_NO} <> previous ({V_CASHREC_DETAIL_ARINVOICE.INVOICE_NO})
)
|
|