# Report just show one row of table **URL:** \ **Category:** Ignition\ **Created:** [December 5, 2023, 7:30pm UTC](https://forum.inductiveautomation.com/t/report-just-show-one-row-of-table/82737 "2023-12-05T19:30:18Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![marco\_alvarez](https://avatars.discourse-cdn.com/v4/letter/m/9d8465/32.png) [@marco\_alvarez](https://forum.inductiveautomation.com/u/marco_alvarez)\ **Post date:** [December 5, 2023, 7:30pm UTC](https://forum.inductiveautomation.com/t/report-just-show-one-row-of-table/82737/1 "2023-12-05T19:30:18Z")
Hi, I have a report that use data from a nested query. The nested query work fine because checking the XML file, I have all the right data. In my case just two of the instances of the nested query should bring data, usually 4 rows for both cases. but in reality Im just displaying one row on each instance meaning that I should have the wrong data but the xml file have the right data. I try putting a table inside the Details area and try to putting a static query as data source to check if the config of the table was wrong but with the static data everything worked fine. ---
**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:** [December 5, 2023, 7:36pm UTC](https://forum.inductiveautomation.com/t/report-just-show-one-row-of-table/82737/2 "2023-12-05T19:36:38Z")
This is commonly caused by dragging a fully-qualified data key from the key browser into a table row, where the table is expecting its row data keys to be just the final `@columnName@` element. ---
**Author:** ![marco\_alvarez](https://avatars.discourse-cdn.com/v4/letter/m/9d8465/32.png) [@marco\_alvarez](https://forum.inductiveautomation.com/u/marco_alvarez)\ **Post date:** [December 5, 2023, 8:02pm UTC](https://forum.inductiveautomation.com/t/report-just-show-one-row-of-table/82737/3 "2023-12-05T20:02:48Z")
I try that and I got N/A. this is my structure. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/a/eab6f996af1cc8e9391a68d12aa1acbd150af052.png) I'm getting "number" from the first query, using that number to run the subquery with that parameter. Inside the table I'm using the following link @query.sub\_query.name@ ---
**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:** [December 5, 2023, 8:03pm UTC](https://forum.inductiveautomation.com/t/report-just-show-one-row-of-table/82737/4 "2023-12-05T20:03:29Z")
> [@marco\_alvarez](#): > > Inside the table I'm using the following link @query.sub\_query.name@ It needs to be just `@name@`. ---
**Author:** ![marco\_alvarez](https://avatars.discourse-cdn.com/v4/letter/m/9d8465/32.png) [@marco\_alvarez](https://forum.inductiveautomation.com/u/marco_alvarez)\ **Post date:** [December 5, 2023, 8:10pm UTC](https://forum.inductiveautomation.com/t/report-just-show-one-row-of-table/82737/5 "2023-12-05T20:10:50Z")
I think I try all the combinations, @query.sub\_query.name@ /@sub\_query.name@ /@name@, just the first one work, the rest I get N/A ---
**Author:** ![marco\_alvarez](https://avatars.discourse-cdn.com/v4/letter/m/9d8465/32.png) [@marco\_alvarez](https://forum.inductiveautomation.com/u/marco_alvarez)\ **Post date:** [December 6, 2023, 9:36pm UTC](https://forum.inductiveautomation.com/t/report-just-show-one-row-of-table/82737/6 "2023-12-06T21:36:48Z")
At the end I fix the issue adding another table inside the table, and linked the table to the sub\_query, then I just use @name@, not sure why worked but it work.