Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1302
  • Last Modified:

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
0
rvfowler2
Asked:
rvfowler2
  • 3
2 Solutions
 
rvfowler2Author 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
 
ThomDrozCommented:
I was going to tell you just that
change the found set
0
 
rvfowler2Author Commented:
Thanks.
0
 
rvfowler2Author Commented:
Though I figured it out, thanks for confirming.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now