Filemaker: Filtering a Report Without Using Find

Created a basic Subsummary report that breaks by each of our Property Codes.  We show totals for referral source such as Signs or Newspaper, etc.  The basic report worked fine; however, now I want to only show data and totals for properties that are actually for sale.  

I thought this would be easy:  I already have a relationship from our Sales Leads db ("Sales") to the Properties For Sale db ("UPC_Sales").  I just simply added another TO of the "Sales" table ("SalesProps4Sale") downstream from UPC_Sales (see attached).  I thought the result would be that the SalesProps4Sale TO would only contain Sales Leads info on Properties actually for sale (which are listed in the "Sales" table).  

However, when I ran the report, it contained nothing.  I tried copying one instance each of the filter and count fields (see attached), but still nothing.  Maybe I was relating the wrong fields, so I created a new list layout based on SalesProps4Sale.  However, instead of having nothing, it had ALL Leads info, which it shouldn't since it is downstream from the UPC_Sales table.  So, I either get nothing or everything.  Obviously I'm doing something wrong.  Any suggestions?
-FilteringReportIssue.doc
LVL 2
rvfowler2Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
ThomDrozConnect With a Mentor Commented:
I was going to tell you just that
change the found set
0
 
rvfowler2Connect With a Mentor Author Commented:
As soon as I clicked submit, I realized that I might be confusing a downstream relationship, which works for portals and possibly doesn't work for reports.  Reports seem to work off a Found Set, so possibly I could just create a calculation field in Sales where IF a property code exists in UPC_Sales (where properties that are actually for sale are listed), put a "1" in this calc field.  Then I could do a Found Set on only those Sales Leads that have a "1" in this field and then run the report.  Would that do it or is there a better way?  Thanks.
0
 
rvfowler2Author Commented:
Thanks.
0
 
rvfowler2Author Commented:
Though I figured it out, thanks for confirming.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.