Suppress-conditional formatting

[hbussell]

Is there any way to get a total of the non-suppressed records when using the format section conditional formatting. For example I may have a record count of 3600 but after suppression duplicate record types I may only show 600. I need a way to show that 600 printed.

hbussell

 

[IdoMillet]

Simply use a Running Total... )

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[hbussell]

Thanks, I was able to do what I needed.

 

[lhendrickson]

What feature would you use to Sum up only the visible data and not the duplicate row amounts?

LHendrickson

 

[IdoMillet]

No need for any special features. Running Totals would ignore the suppressed cases.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[lbass]

An addiitional comment--

To use the running totals with suppressed data, you need to add in the reverse of the suppression conditions in the "evalute based on formula" section in the running total editor, e.g., if you were suppressing all records with {table.ID} = 3, then your running total condition would be
{table.ID} <> 3.

For group selected data, you do not need to do this--the running totals will ignore non-group selected data.

-LB

 

[lhendrickson]

I am using the following formula in the formatting formulas section of the detail section:
IF{@Duplicate Flag}=&quot;Flag&quot; then True

When I put the following condition:
{@Duplicate Flag}<>&quot;Flag&quot;
in the &quot;Evaluate&quot; formula area in a running total I get the following message:
&quot;a running total cannot refer to a print time formula Details: @Duplicate Flag&quot;

Do you guys have a quick solution to get around this error?

LH

 

[Ngolem]

show us what is in @DuplicateFlag

My feeling is that there is a &quot;WhilePrintingRecords&quot; line in it...if so remove it...if not show us the formula

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!

 

[lhendrickson]

@Duplicate Flag =
IF Previous ({@Concatenate Fields})=({@Concatenate Fields})then&quot;Flag&quot; Else&quot;Not Duplicate&quot;

@Concatenate Fields =
({APDISTRIB.COMPANY}&{APDISTRIB.VENDOR}&{APDISTRIB.INVOICE}&{APDISTRIB.DIST_SEQ_NBR})

The Concatenated fields determines if it is a unique or duplicate record.

I solved my problem by using the feature within Running Totals of Evaluate on change of field &quot;@Concatenate Fields&quot;. The data is already sorted properly to allow the duplicate flag formula to work.

Thanks for your patience!

LH