My report returns 1106 records in 00:00:00.01 of a second. This is the constant. I'm using C# and the MVC HTML5 viewer as such
If I have no groups the report renders in 1.5 seconds with the following debug outputs (whatever they mean)
But, are we're talking a Kim Kardashian sized but here, if I put the three required groups on the report the report now takes 19 seconds before I even see the first page and it generates 12511 events in the debug window, so many in fact that I've included a paste bin URL for you
http://pastebin.com/rBv10mJw
The groups are headers only, i.e. hidden footers, they have a single text box on them and the group expression is a simple =Fields.WhatEverGroupFieldIsRequired
Also I've noticed that with or without groups my constructor is hit 3 times before it fetches data??
Can someone explain just what is happening and why it should take so long? Please, this is an urgent matter (I know I'm only on a trial license but please take pity on me I'm quite happy to sacrifice a goat or give over my first born if that will help??)
Mark
@{
var typeReportSource =
new
TypeReportSource() { TypeName = Model.ReportQualifiedAssemblyDetail };
foreach
(var parameter
in
Model.ReportData.Parameters)
{
typeReportSource.Parameters.Add(
new
Parameter(parameter.Name, parameter.Value));
}
@(Html.TelerikReporting().ReportViewer()
.Id(
"ReportViewer"
)
.ServiceUrl(
"/api/reporting/"
)
.TemplateUrl(
"/ReportViewer/templates/CustomReportViewerTemplate.html"
)
.ReportSource(typeReportSource)
.ViewMode(ViewModes.PRINT_PREVIEW)
.ScaleMode(ScaleModes.FIT_PAGE_WIDTH))
}
If I have no groups the report renders in 1.5 seconds with the following debug outputs (whatever they mean)
*** ReportProcessor.ProcessReport STARTED ***
*** ProcessReport #0 STARTED ***
*** Report Processing STARTED ***
*** Report Processing DONE in 00:00:00.3665425 ***
*** ProcessReport #0 DONE in 00:00:00.3777970 ***
*** ReportProcessor.ProcessReport DONE in 00:00:00.3996569 ***
*** Get HTML5 Rendering Extension STARTED ***
*** Get HTML5 Rendering Extension DONE in 00:00:00.3654471 ***
*** RenderReport #0 STARTED ***
*** Measure Report STARTED ***
*** Measure Report STARTED ***
*** Measure Report STARTED ***
*** Measure Report DONE in 00:00:00.3463936 ***
*** Measure Report DONE in 00:00:00.3492620 ***
*** Measure Report DONE in 00:00:00.3523046 ***
*** Arrange Report STARTED ***
*** Arrange Report STARTED ***
*** Arrange Report STARTED ***
*** Arrange Report DONE in 00:00:00.0082247 ***
*** Arrange Report DONE in 00:00:00.0107413 ***
*** Arrange Report DONE in 00:00:00.0128169 ***
*** RenderReport #0 DONE in 00:00:01.5407080 ***
*** ProcessReport #0 STARTED ***
*** Report Processing STARTED ***
*** Report Processing DONE in 00:00:00.3665425 ***
*** ProcessReport #0 DONE in 00:00:00.3777970 ***
*** ReportProcessor.ProcessReport DONE in 00:00:00.3996569 ***
*** Get HTML5 Rendering Extension STARTED ***
*** Get HTML5 Rendering Extension DONE in 00:00:00.3654471 ***
*** RenderReport #0 STARTED ***
*** Measure Report STARTED ***
*** Measure Report STARTED ***
*** Measure Report STARTED ***
*** Measure Report DONE in 00:00:00.3463936 ***
*** Measure Report DONE in 00:00:00.3492620 ***
*** Measure Report DONE in 00:00:00.3523046 ***
*** Arrange Report STARTED ***
*** Arrange Report STARTED ***
*** Arrange Report STARTED ***
*** Arrange Report DONE in 00:00:00.0082247 ***
*** Arrange Report DONE in 00:00:00.0107413 ***
*** Arrange Report DONE in 00:00:00.0128169 ***
*** RenderReport #0 DONE in 00:00:01.5407080 ***
But, are we're talking a Kim Kardashian sized but here, if I put the three required groups on the report the report now takes 19 seconds before I even see the first page and it generates 12511 events in the debug window, so many in fact that I've included a paste bin URL for you
http://pastebin.com/rBv10mJw
The groups are headers only, i.e. hidden footers, they have a single text box on them and the group expression is a simple =Fields.WhatEverGroupFieldIsRequired
Also I've noticed that with or without groups my constructor is hit 3 times before it fetches data??
Can someone explain just what is happening and why it should take so long? Please, this is an urgent matter (I know I'm only on a trial license but please take pity on me I'm quite happy to sacrifice a goat or give over my first born if that will help??)
Mark