Complex reporting Across Arms + Events

[Shreenidhi Sharma]

Hi all, 

I am working on building a complex report that should pull students across 3 arms (different schools) and events (grades (6th/7th/9th/etc)). The criteria for the report is 

1) Parent consent received (contact_releaseform) 

2) Survey was completed at least 90 days ago [calc_xx_dd]

3) They haven't completed a follow up [fu_complete]

The issue I am running into is that the report is viewing the data at the ID level instead of the row level. For an example, if a student was screened in 6th grade and was followed up with but also in a couple years was not screened for grade 9 they are pulled into the report. Ideally only their grade 9 row would populate in the report. I have attached an image to show you outputs from the report. 

I have tried checking off the "Show data for all repeating events or repeating instruments for each record returned" in Step  3 and that returns "No records found". I have also put a live filter on report using the follow up variable and using the "blank value" option for the filter, it still pulls all records. 

Here is my code: 

( ([contact_arm_1][contact_releaseform] = '1'

    AND

    ( ([contact_arm_1][calc_nat6_dd]  >= 90 AND [6th_arm_1][fu_complete]  <> '1')

      OR ([contact_arm_1][calc_nat7_dd]  >= 90 AND [7th_arm_1][fu_complete]  <> '1')

      OR ([contact_arm_1][calc_nat9_dd]  >= 90 AND [9th_arm_1][fu_complete]  <> '1')

      OR ([contact_arm_1][calc_nat10_dd] >= 90 AND [10th_arm_1][fu_complete] <> '1')

      OR ([contact_arm_1][calc_nat11_dd] >= 90 AND [11th_arm_1][fu_complete] <> '1')

   ) )

  OR

  ([contact_arm_2][contact_releaseform] = '1'

    AND

    (([contact_arm_2][calc_hol7_dd]  >= 90 AND [7th_arm_2][fu_complete]  <> '1')

      OR ([contact_arm_2][calc_hol9_dd]  >= 90 AND [9th_arm_2][fu_complete]  <> '1')

      OR ([contact_arm_2][calc_hol11_dd] >= 90 AND [11th_arm_2][fu_complete] <> '1')

    ))

  OR

  ([contact_arm_3][contact_releaseform] = '1'

    AND

    (([contact_arm_3][calc_fra7_dd]  >= 90 AND [7th_arm_3][fu_complete]  <> '1')

      OR ([contact_arm_3][calc_fra8_dd]  >= 90 AND [8th_arm_3][fu_complete]  <> '1')

      OR ([contact_arm_3][calc_fra9_dd]  >= 90 AND [9th_arm_3][fu_complete]  <> '1')

      OR ([contact_arm_3][calc_fra10_dd] >= 90 AND [10th_arm_3][fu_complete] <> '1')

      OR ([contact_arm_3][calc_fra11_dd] >= 90 AND [11th_arm_3][fu_complete] <> '1')

    ) ))

I have also used = ' ' for the follow up complete sections. 

Any thoughts?? 

Thanks so much in advance for your help!! 

Shreenidhi