|Published (Last):||12 March 2007|
|PDF File Size:||4.57 Mb|
|ePub File Size:||1.45 Mb|
|Price:||Free* [*Free Regsitration Required]|
For more information, visit the Business Objects homepage. SummaryThis article discusses techniques, tips and best practices that should lead to improved report performance in Visual Studio. NET Dataset A large part of tuning an application for scalability is ensuring that all the reports are designed in a way such that they will perform at an optimum speed. Report size is one of the obvious factors in report performance.
When designing for scalability, consider using smaller reports. Also, reports designed for desktop applications may not be appropriate for web-based applications. Typically, the load of the first report in an application will be slower than all subsequent report loads.
Depending on the complexity of the report, the time to load the first report may be as much as 20 to 30 seconds or longer. Sometimes, report load time will be significantly longer. This is a normal and expected behavior as a number of Crystal Reports assemblies, com files etc. Once these have been loaded, they are reused and thus the performance improves on subsequent report loads.
The only way to improve the end user experience on first report load is to offset the initial load time on application load or some other part of the application where the performance hit is acceptable. Comparison of Report Performance in the Crystal Reports Designer and Custom ApplicationIt is always useful to compare the performance of a report running in an application to performance in the Crystal Reports designer.
Slow report performance in the CR designer will usually not improve when that same report is ran from a custom application. Typically, the opposite will be the case. This is because setting of a database connection in the CR designer happens immediately on report load when it prompts for the database logon parameters. Thus these comparisons need to be done with consideration. Net Developer Guide. Even though the article specifies Web in the title, many of the points for improving report performance will apply to Windows applications.
Next, determine where the performance hit is coming from. With Crystal Reports, there are at least four places in your code where slow downs may occur. These are: report load connection to the data source setting of parameters actual report output, be it to a viewer, export or printer. DateTime startTime, endTime; System.
TimeSpan diffTime; if crReportDocument! Close ; crReportDocument. Now; this. ToString ; if this. Length Report Options forces the report to verify that no structural changes were made to the database. There may be instance when this is necessary, but once again, the option should be used only if really needed. Often, disabling this option will improve report performance significantly. However, this option will only verify stored procedures. Old or Incorrect Runtime If at all possible, use the latest runtime, be it with a custom application or the Crystal Reports Designer.
The latest updates for the current versions of Crystal reports can be located on the SAP support download page. For details of which version of Crystal Reports is supported in which version of VS. NET Wiki. The report engine internally attempts to perform a certain level of database connection pooling. That is, if three users hit the same ASPX page with the same report on it, the same database connection will be used to perform all three queries.
One thing the report engine does not do is pooling of the query itself. For each report job each ReportDocument instance , a database query must be performed. If the query takes a while to process, or if the set of data returned is very large, then performing this query on a per-user basis could turn out to be the bottleneck of the application.
Using ADO. NET datasets may be an option in this case. See the section in this Article titled ADO. NET Datasets. Other factors affecting data retrieval: network traffic the number of records returned If a SQL query returns a large number Recommended.
Crystal Reports Para Visual Studio.net Visual Basic.net Eidos
CRYSTAL REPORTS PARA VISUAL STUDIO .NET
Programacion Visual Basic NET - Eidos