Print Page | Close Window

Selective suppresion

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=2510
Printed Date: 01 May 2024 at 7:23pm


Topic: Selective suppresion
Posted By: stevbren
Subject: Selective suppresion
Date Posted: 04 Mar 2008 at 11:05am
I have a formula that is located in the detail section that is looking for information by form# A job can have sevaeral forms or only one. If a job has several forms and has duplicate data on a certain field in that form, I want to suppress all duplication.
It works fine on the field, but not the entire section.
Example Form #1 = 4/4,   Form #2 = 4/4. 
To the person doing the work, this is redundant and takes up space. Cyrstal does not see it that way because of form #1 and form #2, but it is the 4/4 that I want to target. There are 4 fields that make up this line in the details section.
 
Any ideas.


Replies:
Posted By: BrianBischof
Date Posted: 04 Mar 2008 at 1:41pm
Have you tried using the PreviousValue({field}) function to test if the previous record has the same value as the current record (and then suppress it).

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: stevbren
Date Posted: 06 Mar 2008 at 6:10am
Brian,
I did. I know I must not be writing the formula correctly or using the correct location to enter. This seems like what I need though.
Where would it go, and what would this type of formula look like


-------------


Print Page | Close Window