Solved

Filemaker:  Filtering a Report Without Using Find

Posted on 2010-11-17
4
1,238 Views
Last Modified: 2012-05-10
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
Comment
Question by:rvfowler2
  • 3
4 Comments
 
LVL 2

Assisted Solution

by:rvfowler2
rvfowler2 earned 0 total points
ID: 34157567
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
 
LVL 6

Accepted Solution

by:
ThomDroz earned 50 total points
ID: 34158974
I was going to tell you just that
change the found set
0
 
LVL 2

Author Comment

by:rvfowler2
ID: 34173274
Thanks.
0
 
LVL 2

Author Closing Comment

by:rvfowler2
ID: 34186442
Though I figured it out, thanks for confirming.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question