# Table group / nested query problem

**URL:** <https://forum.inductiveautomation.com/t/table-group-nested-query-problem/33287>\
**Category:** Ignition\
**Tags:** ignition80\
**Created:** [March 21, 2020, 1:10am UTC](https://forum.inductiveautomation.com/t/table-group-nested-query-problem/33287 "2020-03-21T01:10:54Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![wpmccormick](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/wpmccormick/32/13940_2.png) [@wpmccormick](https://forum.inductiveautomation.com/u/wpmccormick)\
**Post date:** [March 21, 2020, 1:10am UTC](https://forum.inductiveautomation.com/t/table-group-nested-query-problem/33287/1 "2020-03-21T01:10:54Z")

</div>

I have a problem using table groups with a nested query back-end. It seems that trying to print each new row of the parent table on a new page (_New page per row_ option) stops the first time the child table has no data. So if I have 10 rows in the parent table, I expect to get 10 pages (assuming that all the child data fits on a single page; it does). However, when there are **not** linked rows in the child table for a given parent table record, the report stops at this record and, obviously, less than 10 pages.

Cheers!

---

<div class="post-metadata">

**Author:** ![Steve\_Laubach](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/steve_laubach/32/60900_2.png) [@Steve\_Laubach](https://forum.inductiveautomation.com/u/Steve_Laubach)\
**Post date:** [August 7, 2020, 1:50pm UTC](https://forum.inductiveautomation.com/t/table-group-nested-query-problem/33287/2 "2020-08-07T13:50:24Z")

</div>

I am having the same problem. Did you find a solution?

---

<div class="post-metadata">

**Author:** ![wpmccormick](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/wpmccormick/32/13940_2.png) [@wpmccormick](https://forum.inductiveautomation.com/u/wpmccormick)\
**Post date:** [August 7, 2020, 2:12pm UTC](https://forum.inductiveautomation.com/t/table-group-nested-query-problem/33287/3 "2020-08-07T14:12:25Z")

</div>

Sorry I just saw this. Yes, I don’t have the application loaded, and it’s been a while since I looked at it but I think the solution comes down to how the tables are nested. I think there might be another forum thread with more detail. Try looking at some of my other posts, and if you still can’t get it I might be able to spend a little more time with you, depending on what your application is.

---

<div class="post-metadata">

**Author:** ![Steve\_Laubach](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/steve_laubach/32/60900_2.png) [@Steve\_Laubach](https://forum.inductiveautomation.com/u/Steve_Laubach)\
**Post date:** [August 7, 2020, 4:59pm UTC](https://forum.inductiveautomation.com/t/table-group-nested-query-problem/33287/4 "2020-08-07T16:59:25Z")

</div>

It’s ok. It was more of a convenience and I have to transition to other tasks. I just figured I’d ask in case there was something silly that fixes it.
