#291 - XLReporter Connector Setup

The most important setting is the Connector and the selection of the correct Data Sources.

In the settings connect the data connector to the source SQL database:

In Database Manager, check the connector is pulling the correct data.

Configure the DSN:

Example of report for fixed tags, and configurable start date:

The start date and time will be automatically linked, a trick is to delete the XML report file (e.g., Report 1.XML) in the Input folder to make it recreate the connectors.

The other functions in this report can be easily done through standard excel formulas, such as: average=IF($H$5<1,"",ROUND(AVERAGE(INDEX($C:$C,17):INDEX($C:$C,17+$H$5-1)),2)), minimum=IF($H$5<1,"",ROUND(MIN(INDEX($C:$C,17):INDEX($C:$C,17+$H$5-1)),2)), maximal=IF($H$5<1,"",ROUND(MAX(INDEX($C:$C,17):INDEX($C:$C,17+$H$5-1)),2)), sample counts (=COUNT($B$17:$B$10002)), and trends.

Example of report for selectable tags, and configurable start and end dates and times: