I would like to create dynamic report using Reporting module. Similar to the Ad-hoc chart, instead of chart component, I would like report table there. I am using 8.1.43.
I have tag browser tree component from which I am selecting tags to configure for report, I am using dataset parameter of the report. Using script, Datasource I am able to get tag history data. However, I am not able to pass that dataset to report table. I have also tried with Crosstab.
If my dataset contains values of Mutiple tags for certain period of time. When passed to the report table, how can I dynamically bind the Datasource keys to the single report table?
Also, there is any alternate way to do this. Please advise.
The reporting module's table and chart components require preset column names for any data they display. But can indirectly show any desired column headers. Dynamic data can also hide columns that aren't used.
So, create your table with the number of columns you want to support, and configure them to use simple column names like Tag1, Tag2, et cetera. And also use data keys for Tag1_Show, Tag1_Header, Tag2_Show, Tag2_Header, and use them in key bindings to control the column display.
Then, in your scripted data source, alter your history dataset to have the column names the table needs, and move the desired information to the header keys and visibility keys.
