Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Filtering Data Post Reply Post New Topic
Author Message
katfoxus
Newbie
Newbie
Avatar

Joined: 17 Oct 2011
Location: United States
Online Status: Offline
Posts: 19
Quote katfoxus Replybullet Topic: Filtering Data
    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?
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 18 Nov 2011 at 9:40am
instr({table.field}, "AC") <> 1
 
this will only omit records that start AC.
 
HTH
 
 
IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 18 Nov 2011 at 10:32am
this should work too

not({table.field} startswith "AC*")
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.