Reporting - how to get multiple data keys in table details? Also calculations for nested queries?

[pturmel]

For the nested scripting data, you might find this topic useful:

Report with Scripted Nested Data

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

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