Reporting: Dynamic chart timespan

Hi all,

We have a database table (traceability) that contains a single row of data for every piece we manufacture. This table contains batch number, timestamp when the manufacturing started and when it ended and…

In our report we would like to print a row of data from the traceability table and include the matching time series graph for that particular piece and this for every piece of the requested batch.

So far we managed to;
The user passes the batch number to the parameters of the report.
The query is made and returns one row on every page.
The time series graph we made uses the historian datasource with parameters {StartBatch} and {EndBatch}

Needless to say, the chart is repeated every page with the full timespan from {StartBatch} to {EndBatch}

Is there a way to link the {StartBatch} and {EndBatch} parameters directly to the database table fields that contain the actual start and end time?

Best regards,

I would uses a script data source in the report to extract the appropriate subsets of the historion dataset and attach them to the traceability dataset as child keys (nested). Then you can use these child keys in the per-piece chart. This topic should help you do this:

Thanks for your reply Pturmel, I will give it a go and get back to you.