5 Answers, 1 is accepted
This is not a known issue and we will need some additional information in order to investigate it.
Please elaborate on the steps to reproduce this.
Does it happen in Preview mode of the integrated with Visual Studio report designer or when exporting from this designer?
It will be greatly appreciated if you can provide a sample report and logs from the VS output and VS tracing. The latter is described in the Visual Studio Problems help article.
Please note that Visual Studio 2017 support is still in experimental phase, as stated in the Telerik Reporting installer. Once Visual Studio 2017 is out of its RC stage, we will be able to provide full support for it.
Telerik by Progress
I am using the table wizard of report designer R3 2017 to present a simple list with no formatting or sorting. Displaying the list takes an average of 25 seconds. Running the same query on SQL server take 1 second. Loading the same list on Telerik Data Grid takes < 3 seconds.
The report designer is powerful but it is very slow! Any tips to enhance the performance?
Please let us know how many records are displayed in the list. We will test locally with the same amount of records and with the latest version of Telerik Reporting, and will let you know if the rendering time that you observe is normal or not.
You can also provide us with a sample report with test data (CSV) if you would like us to look at your specific scenario and provide more accurate suggestions and tips.
The record count is about 12k. The report is very simple and included as an attachment (.trdx saved as png just rename extension as .trdx and open) . I also have 2 questions for you:
1. Are the reported parameters are applied using 'and' or 'or' and where in the report designer we can set that?
2. Why the report designer allow setting the page layout after the report runs? It should be enabled in the report designer.
Many thanks and looking forward for your response.
Unfortunately, I am not able to download the attachment as trdx file. Please open a support ticket and attach the report definition to it so we can test it locally.
I have tested to display 12K records using a Table item and the report generation took about 5 seconds on my side. I am attaching the report if you wish to test it on your side.
In general, the rendering mechanism works in a way that the more items are generated in the report the more memory and time it will take to be rendered. In this case, improving the performance can be achieved by narrowing the amount of data retrieved by the data source.
There are certain recommendations for achieving better reports performance, we have listed them in Performance Considerations help article. You can go though them and see what can be applied in your reports.
In regards to your questions:
1. Report parameter values can be used in report expressions both with OR and AND operators. The exact logic of the expressions is defined by the report author. More details on how to build report expressions are provided in the help articles under this section.
2. When previewing report in the designer it is allowed to switch between Print preview and Interactive preview - Interactive vs. Print Layout. The page settings are defined in the report using Report.PageSettings properties.