Elastic Report Flexibility

[dinop]

Hello,

So far I made this. But I want to get a report based on shifts. Can you explain me how to set reading hour from 0:00 to 8:00, from 8:00 to 16:00 and from 16:00 to 0:00.

Example:

<Section>
<SectionOptions>
<ID>Section3</ID>
<SectionType>DataData</SectionType>
<Subheading>Consumption by sfifts</Subheading>
<SubheadingVisible>true</SubheadingVisible>
</SectionOptions>
<Table>
<ColumnGroup name=”Consumption”>
<Column name=”Radna” />
<Column name=”Jalova” />
<Column name=”Prividna” />
</ColumnGroup>
<RowGroup name=”Shifts” calcTotal=”true” calcAvg=”true”>
<Row name=”1.Shift (0:00-8:00)” rowStyle=”row-lg”>
<Cell cnlNum=”104″ calcType=”Val”/>
<Cell cnlNum=”105″ calcType=”Val”/>
<Cell cnlNum=”106″ calcType=”Val”/>
</Row>
<Row name=”2.Shift (8:00-16:00)” calcType=”Val” calcTotal=”true” calcAvg=”true” rowStyle=”row-lg”>
<Cell cnlNum=”107″ calcType=”Val” />
<Cell cnlNum=”108″ calcType=”Val” />
<Cell cnlNum=”109″ calcType=”Val” />
</Row>
<Row name=”3.Shift (16:00-0:00)” calcType=”Val” calcTotal=”true” calcAvg=”true” rowStyle=”row-lg”>
<Cell cnlNum=”110″ calcType=”Val” />
<Cell cnlNum=”111″ calcType=”Val” />
<Cell cnlNum=”112″ calcType=”Val” />
</Row>
</RowGroup>
</Table>
</Section>

Picture:
https://ibb.co/2dTzBWV

[Mikhail]

Hello,

Now I understand what do you need to show in the report.
Elastic Report doesn’t directly cover this case.
May be you could print all values from 0:00 to 23:00, and then use Excel formulas (that can be inserted in the report) to calculate the required values.

[dinop]

Hello,

Can you provide an example of how to do it?

[Mikhail]

Hello,

The default report example contains Excel formulas that refer other cells:
<Field calcType="Formula" value="=R[-5]C-R[-5]C[1]" cellStyle="cell-tot" />

Alternatively, you could try to develop formulas that calculates the required values for the input channels. And then use the result in the report.

[Mikhail]

If you need to realize Excel formulas syntax, you should enter a formula in Excel and save the workbook as XML Table 2003.

[manyan2028]

hello Mikhail, I receive you reply about the ElasticReport, press the F12, I get the follow infomation.
Failed to load resource:the Server Responded with a status of 404（not found）。the file report-args.min.css ， report-args.js connot found in my PC。

[Mikhail]

Hello,
Did you copy that files when installed the plugin?

[manyan2028]

Hello, the ElasticReport File donnot contain the above Files. can you privide the new Link to me。thanks

[Mikhail]

You should download the plugin for proper version of Rapid SCADA.

[manyan2028]

https://rapidscada.org/download-all-files/download-elastic-report-plugin/
I downLoad the file from the Above link。But it doesnot contain the files:report-args.min.css ， report-args.js.

[Mikhail]

Right, there are 2 links: the plugins for Rapid SCADA 5 and Rapid SCADA 6.
Which one do you use?

[Mikhail]

That’s true, the reuired files are missing in the archive.
It will be fixed the next week. Please wait for an update.
Thank you for reporting the issue.

[manyan2028]

I want to use the RapidScada 6 ,thanks。

[Mikhail]

I will post the update in this topic.

[Mikhail]

Elastic Report was fixed and uploaded to the website. To use it, you should upgrade Rapid SCADA to 6.1.3.

[Author]

Posts