I’m having an issue with Nested Queries and I’m not sure how to resolve it. My parent query is shown below with it’s Parameter being a where clause which is being populated correctly
The results of this query when entered into the Query Browser return as a single column. For example;
The sub query is shown below
I would expect the Sub Query to execute for each row returned in the Parent query, however, when I run the report and examine the XML, it is only running for the first row returned and then stopping. Here’s the resulting XML
<?xml version="1.0" ?> N/A N/A N/A N/A 2020-04-20 19:36:19.006 All N/A N/A null PSM4-Development Project Status Report (1) Project Status Report (1) 2020-04-20 19:36:19.006 2020-04-20 11:36:19.006 0.0 2217, 2254, 2880 0.0 0.0 2217 466 3201-2015-1 Line 10 - Groninger Capper 3 2217 2015-05-22 00:00:00.000 1112 1 1 444.0 444.0 0.0 0.0 0.0 0.0 0.0 31.08 444.0 0.08 475.08 0.0 0.0 0 2460 2566 L'Oreal Piscataway Plant P O Box 1529, Mail Stop 813 Bountiful, UT 84011-1529 2510 81 New England Avenue Piscataway, NJ 08854 2511 1 2 null 0.0 1 1 null null null null null null 0 0 0 0 0 0 0 null null null null null 0 null 1 536 247 466 247 2100157469 Line 10 - Groninger Capper 3 1 2217 5 2015-05-22 00:00:00.000 1112 L'Oreal/Piscataway/Packaging - UP2 - Treatment/Line 10 - Groninger Capper, 3201/Line 10 - Groninger Capper, 3201 2460 2566 1 1 444.0 31.08 475.08 0 2217 3201 Line 10 - Groninger Capper 1933 2593 L'Oreal 3230 Piscataway 69 Packaging - UP2 - Treatment 1933 Line 10 - Groninger Capper 1 1 true true 1 1112 1116 3201-2016-1 Line 10 - Groninger Capper - 2016-10-26 thru 2016-10-28 3 2217 2016-11-02 00:00:00.000 1112 1 1 3726.45 0.0 0.0 0.0 0.0 0.0 0.0 260.85 3726.45 0.52 3987.3 0.0 0.0 0 2460 -1 L'Oreal Piscataway Plant P O Box 1529, Mail Stop 813 Bountiful, UT 84011-1529 2510 81 New England Avenue Piscataway, NJ 08854 2511 1 2 null 0.0 1 1 null null null null null null 0 0 0 0 0 0 0 null null null null null 0 null 1 3132 641 1116 641 2100195434 Line 10 - Groninger Capper 3 1 2217 5 2016-11-10 00:00:00.000 1112 2460 -1 1 1 3726.45 260.85 3987.3 0 2217 3201 Line 10 - Groninger Capper 1933 2593 L'Oreal 3230 Piscataway 69 Packaging - UP2 - Treatment 1933 Line 10 - Groninger Capper 1 1 true true 1 1112 2992 3201-2019-1 Line 10 - Groninger Capper - 2019-12-03 3 2217 2019-12-10 00:00:00.000 1112 3 0 1710.0 0.0 0.0 0.0 0.0 0.0 0.0 113.29 855.0 0.0 1823.29 0.0 0.0 0 2460 -1 L'Oreal Piscataway Plant P O Box 1529, Mail Stop 813 Bountiful, UT 84011-1529 2510 81 New England Avenue Piscataway, NJ 08854 2511 1 2 null 0.0 1 1 null null null null null null 0 0 0 0 0 0 1 1 0 1 0 -1 0 0 0 10798 1665 2992 1665 2200045044 Line 37 ESS Case Packer 3 1 2858 5 2019-12-10 00:00:00.000 1112 Air Liquide 2283 -1 1 2 10577.0 0.0 10577.0 0 2217 3201 Line 10 - Groninger Capper 1933 2593 L'Oreal 3230 Piscataway 69 Packaging - UP2 - Treatment 1933 Line 10 - Groninger Capper 1 1 true true 1 1112 0.0As you can see, it only returns results for the first row with value of “2217”.
Does anybody see an error in my configuration?
Thanks in advance