Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional Suppressing

Status
Not open for further replies.
Shloimy

Shloimy

Programmer
May 11, 2001
9
0
0
US
I have records coming from a SQL stored procedure. In my report I want to suppress the details section if the first two fields are the same. So if it looks like this:

12:00 John Doe sdfsadfsd
12:00 John Doe aaaaaaaaa

I dont want to see the second record.

How can I do this?

Please help!
 
Sort by date Sort by votes
Put the condition in the record selection formula like :

not (previous(field1) = field1 and previous(field2) = field2)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

khan82
  • Locked
  • Question
Suppressing a Blank field
Replies
3
Views
44
khan82
khan82
jpeters01
  • Locked
  • Question
Need help suppressing duplicate row
Replies
1
Views
34
lbass
lbass
pungy
  • Locked
  • Question
Conditional Printing using Crystal Reports 1
Replies
3
Views
5
pungy
pungy
sodakotahusker
  • Locked
  • Question
Suppressing page header on a page one
Replies
2
Views
14
sodakotahusker
sodakotahusker
bunnycat
  • Locked
  • Question
Conditionally sort LIST OF VALUES
Replies
7
Views
15
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top