Accessing related records in a Feature Report

Kara_Shindle

I know there is a post on this already that was marked as solved, but that option is not working and that is listed in the post comments here

I have set up a set of related tables and a feature service, and I am trying to access all of them in some fashion in a feature report.

I have tried multiple formats, and I have limited success running the feature report on the parent table.  However, I need to filter based on the child feature service, and that is where the feature reports do not access the related records.  It's like it is only going in one direction....

Any help would be appreciated!

 

Agencies (table, Parent 1:M)

  Programs (table, child to Agencies, parent to services, 1:M)

    Services (feature service with location geometry, child to programs)

The idea is that an agency can have multiple programs, and each program has multiple services with different locations and attributes associated with each.

I want to create a feature report that shows me the Programs with all of their associated services.  

However, I want to conditionally filter based on an attribute in the Services layer, called Categories.

Essentially, I want to create a report for each service category.  

Below is what is on my template:

${#HSPrograms}

${#Services}

Program: ${HSPrograms.PrName}           

Service: ${Service_Name}

${if Main_Phone}Contact: ${Main_Phone}${/}

 ${ServDescrp}

${/}${/}

JamesTedrick

As mentioned in the Additional Syntax section of the report query documentation, you can use a where clause in the repeat tag to limit the repeat records that are printed in a repeat section.

${#Services | where="Categories='Cat1'"}