 Complex report filter
|
|
|
KBNV
Sierra Screening Services
|
Hello again,
I need to create a filter for a report from a client list. The records I want to filter have a string that's common in all the fields I want to filter. I want to filter on that specific string using the filter function in the report. I've tried several operators and either come up with nothing, everything, almost everything and then some or everything but. I even tried the ..*** used in search strings within a table.
I'm sure I'm missing something.
Thanks,
Karen
kbalter@sierraonsite.com |
|
Posted 5 years ago (Thread Starter)
|
|
| About KBNV |
|
Membership pending.
Member subscribes to this thread with a verified email.
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #18358, 7 replies
Thread Started 1/15/2021 4:54:49 PM
View Counter=854
Last Reply Posted 5/6/2026 1:25:15 PM)
|
|
|
|
Location=Carson City, NV USA
|
|
| |
|
|
| Moderator |
|
Steven.G
|
are you filtering in the table itself? using the basic Tools/Filter function? using SetGenFilter? an index? a query?
Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN
Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
|
|
Posted 5 years ago
|
|
| About Steven.G |
|
Approved member.
Member subscribes to this thread with a verified email.
|
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
|
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #18362 (Level 2)
and Parent is 18358
Reply Posted 1/16/2021 6:55:21 AM
|
|
|
|
Location=Myrtle Beach, SC USA
|
|
| |
|
|
|
KBNV
Sierra Screening Services
|
I'm trying to filter a particular field within a report using the basic filter function. I have a customer ID that contains "FDAT . . ." with FDAT being followed by other data. So FDAT is common in each record. I do this with other reports, but looking for one specific string. This one has several entries that begin with FDAT. I was trying to figure out wildcards--i.e. FDAT {a-z} or something to this effect.
Hope this helps. |
|
Posted 5 years ago (Thread Starter)
|
|
| About KBNV |
|
Membership pending.
Member subscribes to this thread with a verified email.
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #18364 (Level 3)
and Parent is 18358
Reply Posted 1/16/2021 10:58:46 AM
|
|
|
|
Location=Carson City, NV USA
|
|
| |
|
|
|
KBNV
Sierra Screening Services
|
I'm trying to filter a particular field within a report using the basic filter function. I have a customer ID that contains "FDAT . . ." with FDAT being followed by other data. So FDAT is common in each record. I do this with other reports, but looking for one specific string. This one has several entries that begin with FDAT. I was trying to figure out wildcards--i.e. FDAT {a-z} or something to this effect.
Hope this helps. |
|
Posted 5 years ago (Thread Starter)
|
|
| About KBNV |
|
Membership pending.
Member subscribes to this thread with a verified email.
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #18365 (Level 4)
and Parent is 18358
Reply Posted 1/16/2021 10:58:46 AM
|
|
|
|
Location=Carson City, NV USA
|
|
| |
|
|
| Moderator |
|
|
Steven.G
|
> using the basic filter function
as previously asked, which kind of function are you describing? interactively? in your app?
Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN
Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
|
|
Posted 5 years ago
|
|
| About Steven.G |
|
Approved member.
Member subscribes to this thread with a verified email.
|
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
|
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #18366 (Level 5)
and Parent is 18358
Reply Posted 1/18/2021 5:49:29 AM
|
|
|
|
Location=Myrtle Beach, SC USA
|
|
 |
|
|
|
KBNV
Sierra Screening Services
|
Thanks. I figured it out. |
|
Posted 5 years ago (Thread Starter)
|
|
| About KBNV |
|
Membership pending.
Member subscribes to this thread with a verified email.
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #18369 (Level 1.1)
Reply to 18366
and Parent is 18358
Thread Started 1/18/2021 4:10:14 PM
|
|
|
|
Location=Carson City, NV USA
|
|
| |
|
|
| Moderator |
|
|
Steven.G
|
awesome.. if you want to post the exact problem and exact solution, for others, that would be great.. thanks
Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN
Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
|
|
Posted 5 years ago
|
|
| About Steven.G |
|
Approved member.
Member subscribes to this thread with a verified email.
|
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
|
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #18374 (Level 6)
and Parent is 18358
Reply Posted 1/19/2021 8:28:10 AM
|
|
|
|
Location=Myrtle Beach, SC USA
|
|
| |
Most Recent Post
|
|
|
PS_5337
|
|
|
|
Posted 34 days ago
|
|
| About PS_5337 |
|
Membership pending.
Member subscribes to this thread with a verified email.
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #21799 (Level 7)
and Parent is 18358
Reply Posted 5/6/2026 1:19:47 PM
|
|
|
|
Location=-- USA
|
|
| Thread #18358 Counter |
| 854 |
|
Since 1/15/2021
|
|
|
|
Paradox
Print This
