Best method to display all values greater than x in a certain period?

[pturmel]

Consider using your tag historian query to collect all the raw data you need, then use a script data source to reprocess that data into the nested data keys you need. Your report's charts and tables (and/or nested tables) would use the reprocessed data. This post might help you:

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…