 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 43 days 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, 6 replies
Thread Started 1/15/2021 4:54:49 PM
View Counter=54
Last Reply Posted 1/19/2021 8:28:54 AM)
|
|
|
|
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 42 days ago
|
|
| About Steven.G |
|
Approved member.
Member subscribes to this thread with a verified email.
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 42 days 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 42 days 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 40 days ago
|
|
| About Steven.G |
|
Approved member.
Member subscribes to this thread with a verified email.
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 40 days 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
|
|
| |
Most Recent Post
|
|
| 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 39 days ago
|
|
| About Steven.G |
|
Approved member.
Member subscribes to this thread with a verified email.
Post ID #18374 (Level 6)
and Parent is 18358
Reply Posted 1/19/2021 8:28:10 AM
|
|
|
|
Location=Myrtle Beach, SC USA
|
|
| Thread #18358 Counter |
| 54 |
|
Since 1/15/2021
|
|
|
|
Paradox
Print This
