We're a community of 1076K IT Pros here for help, advice, solutions, professional growth and fun. Join us!
1,075,610 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Start New Discussion Reply to this Discussion

Crystal Report Filtering Problem

hey.can someone help me..???
how can i filter records from the database depending on
the length of each record???

example..i only want to display records with the length
of the fieldname lastname <> 5.

what is the formula for this using crystal report??
im currently using this:

length({tablename.fieldname}) <> 5
but this doesn't work when i use it with not like syntax.

length({tablename.fieldname}) <> 5 and not({tablename.fieldname} like 'a*')

i badly need this..thanks in advance.
im using vb6, mysql and crystal report 8.

1
Contributor
0
Replies
1
View
newbie26
Junior Poster in Training
55 posts since Sep 2011
Reputation Points: 10
Solved Threads: 0
Skill Endorsements: 0

This article has been dead for over three months: Start a new discussion instead

Post: Markdown Syntax: Formatting Help
 
You
 
© 2013 DaniWeb® LLC
Page rendered in 0.0729 seconds using 2.63MB