Print Page | Close Window

Filtering Data

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=14978
Printed Date: 27 Apr 2024 at 4:29am


Topic: Filtering Data
Posted By: katfoxus
Subject: Filtering Data
Date Posted: 18 Nov 2011 at 9:31am
I am fairly new to Crystal reports and have a report in which I need to filter out some of the products. All of the products i need to omit from the report start with AC and I am looking for a way to write a formula or filter that will allow me to possibly use the Mid()function as there are over 50 products. Any suggestions?


Replies:
Posted By: lockwelle
Date Posted: 18 Nov 2011 at 9:40am
instr({table.field}, "AC") <> 1
 
this will only omit records that start AC.
 
HTH
 
 

Posted By: kostya1122
Date Posted: 18 Nov 2011 at 10:32am
this should work too

not({table.field} startswith "AC*")


Print Page | Close Window