I.T. Discussion Community!
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

April Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardParadox Setup, Vista, etc. Topic   Print This     

Complex report filter

Complex report filter in Paradox Setup, Vista, etc. topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: Complex   Complex report   Complex report filter  
KBNV
Sierra Screening Services
Carson City, NV USA

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 86 days ago (Thread Starter)
Comment Quote
About KBNV -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
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=78
Last Reply Posted 1/19/2021 8:28:54 AM)
Location=Carson City, NV USA 
Joined=36 months ago   MB Posts=6  
Moderator
Steven.G
Myrtle Beach, SC USA

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 85 days ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
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 
Joined=55 months ago   MB Posts=461  
KBNV
Sierra Screening Services
Carson City, NV USA

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 85 days ago (Thread Starter)
Comment Quote
About KBNV -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
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 
Joined=36 months ago   MB Posts=6  
KBNV
Sierra Screening Services
Carson City, NV USA

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 85 days ago (Thread Starter)
Comment Quote
About KBNV -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
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 
Joined=36 months ago   MB Posts=6  
Moderator
Steven.G
Myrtle Beach, SC USA

> 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 83 days ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
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 
Joined=55 months ago   MB Posts=461  
KBNV
Sierra Screening Services
Carson City, NV USA

Thanks.  I figured it out.

 Posted 83 days ago (Thread Starter)
Comment Quote
About KBNV -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
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 
Joined=36 months ago   MB Posts=6  
Most Recent Post
Moderator
Steven.G
Myrtle Beach, SC USA

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 82 days ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
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 
Joined=55 months ago   MB Posts=461  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1111A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #18358 Counter
78
Since 1/15/2021

Follow PrestwoodBoards on: 


©1995-2021 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech