ReportViewer super slow at showing reports

Ignition
1

Hello,

I have set up a report in the report module.
While working on it in the report module it loads very fast on preview.
However, when using the reportviewer component in perspective it loads so slow.

I have used tag history bindings for loading the data.

We have made a workaround where we pull all the data in the perspective view and send them as params to the reportingviewer component for visualization to make the load speed faster 4 times faster, but this seems weird to me.

We have no performance issues in pulling the data with other components (multiple dynamic graphs, etc), it is just this reportviewer component that loads report so incredibly slow if the datacollection is set up in it.

Is this a bug? Is the component not working in a separate thread? We are not even pulling large amount of data just a few tags from a range of 2 days. The pdf size is less than 1 mb. We have views that pull so much more than this without any issue.

2

What slows it down is the query, however if I do a similar query outside of the reporting module for more data, there is no problem.

I am using the tag historian query in an attempt to make it as readable for other users as possible. I have a dynamic start and end date that i pass in as parameters.

It takes, on our hardware, almost two minutes (1minute and 47 seconds on my stopwatch) to generate a report with 9 tags being queried. Are there any measures i can do to speed up the process?

Our workaround is to gather the data in the perspective view and pass it on to report as paramaters, this takes max 30 seconds for much larger reports

image
image729×187 14.8 KB

image
image1055×477 28.1 KB

3

Ok, so the "problem" is somewhat solved.

By unchecking "Ignore Bad Quality" and "Prevent Interpolation" I got the speeds i was expecting. In addition, I now use an onChange sample size. This reduced loading times to 5 seconds. I didnt time all changes but "Ignore Bad Quality" added at least 30 seconds