Forum Home › Forums › Runtime Bugs › About Elastic Report Month Period
- This topic has 13 replies, 2 voices, and was last updated 3 years, 1 month ago by kcks66.
-
AuthorPosts
-
January 30, 2021 at 6:15 am #8201kcks66Participant
Hi Mikhail,
I am trying Elastic Report plugin to generate monthly report. I modified to become monthly period from the ElasticRepExample.xml. However, I got error.
My modified xml code as below:
<?xml version=”1.0″ encoding=”utf-8″?>
<ElasticReportConfig>
<!– Report may contain only one sheet to support different output formats –>
<Sheet>
<SheetOptions>
<!– Heading of the report –>
<Heading>Monthly Report Example</Heading>
<!– Defines how the period is specified. Possible values: None, Day, Month –>
<PeriodUnit>Month</PeriodUnit>
<!– Hour of daily meter readings –>
<ReadingHour>24</ReadingHour>
<!– Day of monthly meter readings –>
<ReadingDay>190</ReadingDay>
<!– Allow to use readings at the next or the previous hour if the readings at ReadingHour are undefined –>
<AllowNextHour>true</AllowNextHour>
<!– Prepend additional day before the report begin date –>
<PrependDay>true</PrependDay>
<!– Append additional day after the report end date –>
<AppendDay>false</AppendDay>
</SheetOptions><!– Output options work for PDF format only –>
<OutputOptions>
<!– Page format: A0, A1, A2, A3, A4, A5, A6, B5, Letter, Legal, Ledger or P11x17 –>
<PageFormat>A4</PageFormat>
<!– Page orientation: Portrait or Landscape –>
<Orientation>Landscape</Orientation>
</OutputOptions><!–
Section of TimeData type example.
Supported calculation types: Val, Diff, DiffNext, Const, Formula.
–>
<Section>
<SectionOptions>
<!– The unique section ID. Use Latin characters without spaces –>
<ID>Section1</ID>
<!– Type defines the form of the section. Possible values: TimeData, TimeTime, DataData, Fields –>
<SectionType>TimeData</SectionType>
<!– Subheading of the section –>
<Subheading>Monthly Energy Consumption</Subheading>
<!– Show or hide subheading –>
<SubheadingVisible>false</SubheadingVisible>
<!– Detailing of the time. Possible values: Hour, Day, Month, BeginEnd –>
<TimeDetailing>Month</TimeDetailing>
<!– Skip the first time point of the working period –>
<SkipFirstRow>false</SkipFirstRow>
</SectionOptions><!– Specification of the columns and data binding is below –>
<Table>
<ColumnGroup name=”Monthly Energy Consumption (kWh)”>
<Column name=”Test Room 1″ cnlNum=”117″ calcType=”Val” />
<Column name=”Test Room 2″ cnlNum=”217″ calcType=”Val” />
<Column name=”Test Room 3″ cnlNum=”417″ calcType=”Val” />
<Column name=”Test Room 4″ cnlNum=”517″ calcType=”Val” />
<Column name=”Test Room 5″ cnlNum=”617″ calcType=”Val” />
</ColumnGroup>
</Table>
</Section>
</Sheet>
</ElasticReportConfig>Pls advice and thank you.
Pls take note that I do not have full month everyday files in ArchiveDAT.- This topic was modified 3 years, 2 months ago by Mikhail.
January 31, 2021 at 7:25 am #8209MikhailModeratorHi,
Please send the detailed error information that is written in C:\SCADA\ScadaWeb\log\ScadaWeb.log
January 31, 2021 at 7:26 am #8210MikhailModeratorIf you select Excel or PDF, is the error the same?
January 31, 2021 at 1:16 pm #8212kcks66ParticipantHi Mikhail,
The error was the same if I selected Excel or PDF. The error information from the log:
2021-01-31 21:11:45 <MAC-WIN10><DefaultAppPool><ACT> Generate “Elastic report” report by the user admin
2021-01-31 21:11:45 <MAC-WIN10><DefaultAppPool><EXC> Application error:
System.ArgumentOutOfRangeException: Hour, Minute, and Second parameters describe an un-representable DateTime.
at System.DateTime.TimeToTicks(Int32 hour, Int32 minute, Int32 second)
at Scada.Web.Plugins.ElasticReport.Model.Builder.DocContext.InitWorkPeriod(DateTime startDate, DateTime endDate, Boolean prependDay, Boolean appendDay)
at Scada.Web.Plugins.ElasticReport.Model.Builder.DocBuilder.GenerateDocument(ElasticRepConfig config, DateTime startDate, DateTime endDate, BuildOptions buildOptions)
at Scada.Web.Plugins.ElasticReport.ElasticRepHtmlBuilder.GenerateHtml(ElasticRepConfig config, DateTime startDate, DateTime endDate, String& title)
at Scada.Web.Plugins.ElasticReport.WFrmElasticRepHtmlOut.Page_Load(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Page: http://localhost/Scada/plugins/ElasticReport/ElasticRepHtmlOut.aspx?reportID=50&startDate=2021-01-01&endDate=2021-01-01
User: adminFebruary 1, 2021 at 1:05 pm #8226MikhailModerator<!– Day of monthly meter readings –> <ReadingDay>190</ReadingDay>
This parameter is a day of month. Set it to 1, for example.
February 1, 2021 at 1:56 pm #8231kcks66ParticipantHi Mikhail,
I set it to 1, but I still having the same error.
February 3, 2021 at 1:19 pm #8239MikhailModeratorHi,
<ReadingHour>24</ReadingHour>
also can’t be 24. It’ in 0…23February 4, 2021 at 1:56 am #8241kcks66ParticipantHi Mikhail,
I changed to 12 and it worked.
Thank you.March 16, 2021 at 2:18 pm #8515kcks66ParticipantHi Mikhail,
I am now working on yearly report. Is the Elastic Report able to generate something like this example?
Date Total Usage (kWh)
01/01/2017 123456789
01/01/2018 123456789
01/01/2019 123456789
01/01/2020 123456789
01/01/2021 123456789Thank you.
March 17, 2021 at 11:39 am #8520MikhailModeratorHi,
You should check a report example on Live Demo. But a year step is not supported, max. step is 1 month.March 22, 2021 at 8:57 am #8546kcks66ParticipantHi Mikhail,
Noted with thx.
March 22, 2021 at 9:18 am #8547kcks66ParticipantHi Mikhail,
I have question to ask; how I am going to change the Subtitle as below to desired name?
2. Elastic report –> Other name 1
3. Elastic report –> Other name 2My configuration:
Thank you.
March 22, 2021 at 2:00 pm #8552MikhailModeratorHi,
Enter a title in the Interface table in the Title column.
March 22, 2021 at 2:54 pm #8555kcks66ParticipantHi Mikhail,
Done. Thank you.
-
AuthorPosts
- You must be logged in to reply to this topic.