# Report binding Nested Query, Sub Table can’t show all rows?

**URL:** <https://forum.inductiveautomation.com/t/report-binding-nested-query-sub-table-can-t-show-all-rows/114140>\
**Category:** Ignition\
**Tags:** ignition81, reporting\
**Created:** [February 24, 2026, 8:44am UTC](https://forum.inductiveautomation.com/t/report-binding-nested-query-sub-table-can-t-show-all-rows/114140 "2026-02-24T08:44:51Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![taohongyu88](https://avatars.discourse-cdn.com/v4/letter/t/f05b48/32.png) [@taohongyu88](https://forum.inductiveautomation.com/u/taohongyu88)\
**Post date:** [February 24, 2026, 8:44am UTC](https://forum.inductiveautomation.com/t/report-binding-nested-query-sub-table-can-t-show-all-rows/114140/1 "2026-02-24T08:44:51Z")

</div>

Version 8.1.24

SQL Query : SELECT id as customerid ,name,addtime FROM customer where state=1 and type=1

Nested Query:SELECT id,no,addtime FROM contract where state=0 and customerid=?

add Parameter {customerid}

Design:

Table + sub Table

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/b/1b0ecac445fb6f682e5a63766b2052c45fd65836.png)

Preview:

 ![1c92549ab7720c9b7997a0180c751aa0](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/b/fbeeee1f00c62446c3f5539b14d9ba87f76f6033.png)

In Preview，I can see Table data and sub Table data;

But in the sub Table ,can’t show all rows?

Table Details height:300  
sub Table height:278

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/0/c096eaaaab1c446359976d6366705dab12b90e8c.png)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [February 24, 2026, 1:27pm UTC](https://forum.inductiveautomation.com/t/report-binding-nested-query-sub-table-can-t-show-all-rows/114140/2 "2026-02-24T13:27:38Z")

</div>

Use table groups. Rows within a table will not do what you are after.

---

<div class="post-metadata">

**Author:** ![taohongyu88](https://avatars.discourse-cdn.com/v4/letter/t/f05b48/32.png) [@taohongyu88](https://forum.inductiveautomation.com/u/taohongyu88)\
**Post date:** [February 26, 2026, 3:00am UTC](https://forum.inductiveautomation.com/t/report-binding-nested-query-sub-table-can-t-show-all-rows/114140/3 "2026-02-26T03:00:30Z")

</div>

Add Table Group

Add Child Table

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/2/2281511801159c1275d1f47b966797ecef745bd7.png)