AnsweredAssumed Answered

Filtered Report to include fields from various tables

Question asked by DouglasCourter on Aug 6, 2014
Latest reply on Aug 11, 2014 by philmodjunk

Title

Filtered Report to include fields from various tables

Post

     I am trying to create a report that will only list children who have been sponsored by a particular church. I have a Church ID field in the main child information table. I set up a global field for Church ID. I navigate to a layout where I pick a church from a dropdown which sets the value in the global field. From there a button runs the report/layout in which a script is run to perform the correct find/filter. I've attached several snippets. I have searched throughout the forums, but can't find a solution. Here are my problems: I want to be able to display the church's name, city and state on the report in the header. I then want to list all the children (various fields) who are sponsored by that church. I've tried portals. I've tried using various tables as the basis of the layout, but I can't get this to work. Any help would be appreciated.

Relationships.PNG

Outcomes