Ignition – Report Module – How to set dynamic the Data Key in a Timeseries chart

[pturmel]

Report preview in the designer shows the data in XML format in the right sidebar.

If you are trying to produce nested data by script, you need to see this old topic:

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…