Filtering data within fields
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=390
Printed Date: 03 May 2025 at 8:03pm
Topic: Filtering data within fields
Posted By: lions_share
Subject: Filtering data within fields
Date Posted: 23 Mar 2007 at 10:08am
I presently work in the banking industry and I am putting together a report where one of the fields in our DB is a "comment" field. The tellers enter comments about the customers such as "bill payer active" or "spouse deceased", etc.
A customer may have several of these fields under his customer number to encompass all of the comments. For example a CR with the comment field may look something like this:
Bill Smith 0112233 This customer presently
Bill Smith 0112233 has a debit card and his
Bill Smith 0112233 car loan .... etc.
My question is this. Is there a way to find a string within these fields and display those records? Using the above example, a search on "debit card" should return the second record. I tried several different things but I've only been successful at returning entire fields. If anyone can offer any input it will be greatly appreciated.
-- Crystal Newbie
|
Replies:
Posted By: BrianBischof
Date Posted: 23 Mar 2007 at 10:46am
Well it would help to know some things you tried but didn't work. I recommend checking the different string functions. You have functions which will find a string within a string, Mid(), and this is good for filtering. You can use the Left() and Right() function.
-------------
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>
|
|