Filtered Report to include fields from various tables
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.