Table View transposition & max present tavle values

[Artos9]

Hello,
I would like to ask about transposed view of Table.
Is possible to present table as vertical view?
——————————
| ITEM | Channel 1 | Channel 2 |
——————————
Current| 100 | 200 |
00:00 | 300 | 400 |

etc.

In table view period presented data is only two days.
Is possible to extend time range in table?

Thank you.

[Mikhail]

Hello,

There is a lifehack to use Elastic Report, which can generate HTML, to show data as you need. Then use WebPageView to show the report in the explorer tree. I can provide more details if needed.

[Mikhail]

But Elastic Report doesn’t display current values. So you can combine it with Dashboard.

[Artos9]

Then use WebPageView to show the report in the explorer tree. I can provide more details if needed.

If you could it will be very helpful.

Thank you.

[Mikhail]

First, you should install Elastic Report, configure it according the manual and be able to generate a report. Then I will tell how to embed a report in a web page.
Please post a link to a report screenshot when it is ready. It’s needed to clearly explain further steps.

[Artos9]

Thank you.
Elastic Report plugin works correctly.

In link you can find modified report table.
https://imgur.com/xVLRs5I

Is possible to think about more complicated Table plugin in future with custom views (transposition, hour, minute table header, wider date selection)?

[Mikhail]

If you want to add a node in the explorer tree that open the report on a web page:
1. Add a new record in the Interface table.
2. Set
Path to URL of your report
View Type = WebPageView
Title = HelloWorld\My Report (for example)

Is possible to think about more complicated Table plugin in future with custom views (transposition, hour, minute table header, wider date selection)?

In Rapid SCADA 6 we will change the approach of working with historical data. This will cause changes in Elastic Report.

[Artos9]

Hi,
Thanks you for description.

Unfortunately page return Error HTTP 404.7.
ElasticRepExample.xml:1 Failed to load resource: the server responded with a status of 404 (Not Found)

Interface settings.
https://imgur.com/S2RQRG9

[Mikhail]

Hi,

The link should be similar to
http://localhost/scada/plugins/ElasticReport/ElasticRepHtmlOut.aspx?reportID=101

[Mikhail]

You need 2 records in the Interface table: one for the report and the 2nd for the link.

[Artos9]

Hello,
Thank you. It works!
I use additionally argument &period=-30 to show last 30 days report.

[Author]

Posts