Report designer is extremely slow

[Yavor]

Hello!
I have a report with a lot of textboxes in it (about 500). The problem is that the designer is working extremely slow with all these textboxes. Can you give me any solution, because it works so slow that it's almost impossible to use it.

[Yavor]

Please, give me some workaround for this bug! It takes days to create one report if the report has a lot of textboxes.

[Peter]

Hello Yavor,

We appreciate your explanation, but without a runnable sample project on our end, it is very hard to give appropriate advise especially when it comes down to making something work faster/better. That is why we would appreciate if you open a support thread to send us a sample application that we can run on our end and your computers' hardware and software configuration details as well. Once we review it, we would be able to provide you with more info.

Best wishes,
Peter
the Telerik team

[Yavor]

Hello Peter,
Our support package subscription is expired and that's why I opened a thread in the forum. You can download the report I'm talking about from  http://dox.bg/files/dw?a=83dff2ee32. My hardware configuration is AMD Athlon 64 X2 Dual Core Processor 3800+ with 2GB of RAM. I'm running Windows Vista SP2 and Visual studio 2010 as development environment.

[Peter]

Hi Yavor,

Thank you for the sample report.

We noticed that the report you have made is static while the main purpose of the report is to process data. Thus our suggestion is instead of adding a TextBox item for every single value to prepare a flat datasource (DataTable with 4 rows) and use the ObjectDataSource component to bind a Table item (with static rows for the headers only) to that DataTable. This way you will have 3-5 row Table item with only 20 TextBox items.

You can find more information on what the purpose of our reporting solution is in Telerik Reporting White Paper.

Additionally should you decide to continue working with Telerik Reporting, we highly recommend reviewing the Designing Reports help section to get acquainted with our product.

All the best,
Peter
the Telerik team

[Yavor]

The solution you're offering does not fit our architecture. We're planning feed the report with parameters (I hope that the report can handle such large number of parameters), because each field is calculated with a formula that can be modified by the user and is stored in the database. We have an engine that checks all the report parameters and calculates them based on the formula that is in the database. But for every report parameter we need a textbox. Besides that for the sulution you're ofering we'll need two tables and two ObjectDataSource components - one for active and one for the passive side of the report. Besides that we'll need to use conditional formatting for the subtotals and we'll need to include all the subtotals in the datatable instead of calculating them in the report. I'm aware of most of the options of telerik reports. All the other reports in this software are made with telerik reporting and they're working fine. However it seems that the report designer has really poor performance when having a lot of objects. Do you have any solution for this issue? Because even if I use your solution for this particular case there are other reports that aren't tabular at all. For example VAT Declaration. It also needs a lot of textboxes. Are you planning to work on the poor performance bug in your reports?

[Yavor]

Do you have any comment on my latest post? I need a solution for the disastrous performance when having a large number of textboxes on the report.

[Peter]

Hello Yavor,

We are aware of the performance penalty related to manipulating hundreds of report items in the report designer and we are constantly working on improving Telerik Reporting's performance. 

Currently If you have to use hundreds of report items you have two options to separate the big reports in multiple SubReports or creating/modifying your reports entirely in code behind and avoid the designer.

Please excuse us for the inconvenience.

Sincerely yours,
Peter
the Telerik team

[David Yardy]

Is this still the best work around for poor performance of the designer??

[Stef]

Hi David,

Please elaborate on the issue:

1. If it is a performance issue while designing the report and in which viewer, or on previewing the report (interactive or print preview and which viewer);
2. The number of reporting items and sections in the report;
3. The amount of data bound to the report;
4. If there are any errors occurring on designing the report or previewing it.

Regards,
Stef
Telerik by Progress

[David Yardy]

Hello.

The slow performance is within vs.net 2015 while using the designer (not the previewer).

There are 2 sections.

There is very little data just simple, text, and picture box controls.

The issue is all around the 'designer', just moving controls, aligning lines etc. is very slow.  SO much slow that we grab a border, drag it to a new location then we have to 'wait' until all hour glass's go away before we let go of the mouse button.

I have also found that restarting vs.net every 15 minutes helps (almost like there is a memory leak in the designer)

 

thx-dave

 

 

[David Yardy]

The performance issues, are all related to the designer in particular within vs.net 2015.  We are not previewing the data, just simply putting controls on the form, aligning edges and borders etc.  The report has picture boxes and textboxes, tables and panels.  So nothing related to data at all here..just designer.

No errors that we can see while using the designer.  I have found that restarting vs.net every 10-15 minutes does help significantly.  Also, have found that keeping properties and document outline window closed helps a little however, they are important to us.

 

ideas?

[David Yardy]

Designer only

[David Yardy]

I have typed a paragraph 3 times and each time i hit 'post this reply' it fails.

 

The issue is all within the designer.  I have found that restarting vs.net 2015 every 10-15 minutes helps (almost like there is a memory link in the designer).  This issue has nothing to do with preview or the data..just the designer manipulating controls, panels, picture boxes etc.

[Katia]

Hello Dave,

We performed a number of tests with the report that you attached in a private support ticket# 1089955 and did not notice any performance issues with the Designer.

That was the reason to ask you to send us a short video while working with the report in Visual Studio Designer that demonstrates the issue you are experiencing. This could help us to reproduce the problematic behavior on our side and to understand more clearly the environment on your side. 


Regards,
Katia
Telerik by Progress