# Reporting - how to get multiple data keys in table details? Also calculations for nested queries? **URL:** \ **Category:** Ignition\ **Tags:** ignition80\ **Created:** [February 29, 2020, 12:43am UTC](https://forum.inductiveautomation.com/t/reporting-how-to-get-multiple-data-keys-in-table-details-also-calculations-for-nested-queries/32711 "2020-02-29T00:43:02Z")\ **Posts on this page:** 1\ **Showing post:** 2
**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 29, 2020, 2:33am UTC](https://forum.inductiveautomation.com/t/reporting-how-to-get-multiple-data-keys-in-table-details-also-calculations-for-nested-queries/32711/2 "2020-02-29T02:33:52Z")
For the nested scripting data, you might find this topic useful: > [@Report with Scripted Nested Data](http://forum.inductiveautomation.com/t/report-with-scripted-nested-data/11801): > > The report datasource scripting examples explain how to access the nested data in another key for use constructing a custom dataset. What I don’t see is how to construct nested data that would be suitable for use with a child table in a table group. I have a parent dataset that I’m constructing via script due to annoying limitations of an ancient SQL Server 2000 instance. I need a subquery for each row that could be done with a normal query, but there’s no way to add a regular subquery to a s… For the nested reporting part, try this topic: > [@Ignition Reporting Dynamic Charts](http://forum.inductiveautomation.com/t/ignition-reporting-dynamic-charts/32324): > > Hi, I have a project with multiple sites configured, with potential for more. I would like to show two charts per site configured, in the reporting module. I know there are table groups, which does something similar to what I want, however I would like to be showing charts instead of tables. How would I go about doing this? Thanks, Andrew --- _[View the full topic](https://forum.inductiveautomation.com/t/reporting-how-to-get-multiple-data-keys-in-table-details-also-calculations-for-nested-queries/32711)._