Open
YouTube |
Watch our video tutorial on importing reports from Crystal Reports. Subscribe to the Stimulsoft channel to be the first to learn about new tutorials. Leave your questions and suggestions in the video comments.
|
The Open section in the File menu contains commands for loading reports into the designer.
A report can be loaded into the Report Designer from:
The Recent tab, which stores links to the most recently opened reports;
Import from other report development platforms;
The user's local storage.
Stimulsoft Reports allows importing reports from other report development platforms. The import process can be done directly in the Report Designer or using the Import Utility. To import reports in the Report Designer, go to the File menu, select Open, then Import, and choose the platform from which you want to import the report.
All imports, except those from Crystal Reports and DevExpress XtraReports, are built-in. This means reports from these platforms can be opened directly in the designer. However, for Crystal Reports and DevExpress XtraReports, reports must first be converted using the Import Utility before being opened in Stimulsoft Report Designer.
Information |
In some Report Designers, the Import option may be missing from the Open menu. In this case, you can use the Import Utility to import reports and then work with them in Stimulsoft products.
|
Run the Import Utility
With the help of import utilities, you can convert reports from other reporting tools. Every file type has its own import utility. To run the import utility, follow the steps below:
Step 2: Download the archive with the import projects and unpack it.
Step 3: Use the development environment, such as Visual Studio, to compile the project.
Step 4: Select the reports that you want to convert to Stimulsoft reports and specify the location where the converted report should be saved.
Step 5: Click the Convert button. The result of the conversion will be displayed to the user.
|
Import Report from Crystal Reports
The utility converts the Crystal Reports templates (*.rpt-files) to the Stimulsoft Reports report templates format (*.mrt-files). The tool is supplied as the C# source code only and requires referencing of some Crystal Reports runtime libraries to be built successfully in Visual Studio 2010, .NET Framework 4.0 or higher. Please download the archive from the link below, unzip it and open in the Visual Studio. The project will be built successfully, once all the required dll libraries are referenced and found in Visual Studio.
The project was created in a way that all the required assemblies would be automatically taken from the GAC (Global Assembly Cache). If * .dll libraries of Stimulsoft Reports are not in the GAC, they will be added to the project from NuGet automatically. If you do not have an Internet connection, you should manually add Stimulsoft.Base.dll and Stimulsoft.Report.dll to the project.
The Crystal Reports report templates’ file format is a proprietary format. Therefore, the tool requires some Crystal Reports special managed assemblies. The tool interacts with these assemblies via some special Crystal Reports interfaces for the special Visual Studio managed dlls.
These assemblies are not always installed in the system together with Crystal Reports, usually the additional and an official installation of these assemblies is required in order for them to work correctly with the import tool.
For example, for Crystal Reports 2013 the Support Pack (developer version for VS: Updates & Runtime) is required and needs to be installed first, and only after that the import tool will be built successfully.
The current Crystal Reports version requires the additional installation of the ‘SAP Crystal Reports runtime engine’ (32 bit or 64 bit). The automatic installer will copy the required assemblies to the GAC. But this installer must be downloaded separately, it is not a part of the standard Crystal Reports installation package.
The project uses the following Crystal Reports assemblies:
These assemblies are not included with the tool. The packages will not work if they are just referenced and copied to the project without the proper installation by the Crystal Reports’ official installer first. Please find the explanation of the required installations:
The above mentioned installers can be downloaded using the following links: http://www.crystalreports.com/crvs/confirm/ http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_20.zip
Please read more about the requirements of those additional installations in the official reply from the Crystal Reports: https://archive.sap.com/discussions/thread/3675145
Run Crystal Reports on client machine without install runtime package? No, the only way to make your app work is to run one of the redist packages on the user’s PC. We don't support nor do we have a way to manually deploy the runtime. Too many Registry entries and registering of the dll's to do this manually.
|
Parameters of Import Utility
If the flag is not enabled then the Line and the Box components will be converted to ordinary primitives (shapes, VerticalLine/HorizontalLine, and Rectangle/RoundedRectangle). If the flag is enabled then the Line and the Box components will be converted to special primitives (VerticalLinePrimitive/HorizontalLinePrimitive and RectanglePrimitive/RoundedRectanglePrimitive). When viewing/printing reports, there are no big differences between graphic and special primitives. Graphic primitives are exported as images when exporting. So it is easier to work with special primitives. But, due to Crystal Reports peculiarity, special primitives cannot work correctly on complex reports. This is why there is the ability to select the option.
In each Formula Field either expression or a data string can be placed. Each Formula Field is converted into the variable in the data dictionary. If the "Use functions for Formula Fields" flag is enabled, then the "Function" flag is set to variable. In other words, when report rendering, Stimulsoft Reports will use the value of a variable as an expression and will try to calculate the value of this expression. If the "Use functions for Formula Fields" flag is not enabled, then the value of a variable will be used as the data string.
|
Problems with conversion
One of the main problems in conversion is that not all object properties are available when working with managed dll. The second problem is the different reporting tools structures, such as data structures, work with bands etc. Therefore, it is not always possible to convert a report automatically, and it is required to correct a report manually.
Crystal Reports often uses their internal libraries when working with data bases. It is possible to get only some properties from .NET and it is impossible to get ConnectionString. So, not all data bases can be identified. By default, for not identified data bases, the StiOleDbDatabase type and ConnectionString template without specifying the provider is used.
В CrystalReports каждый отчет/подотчет имеет свой собственный словарь данных, и одна и та же база данных может быть описана в разных подотчетах по разному. В Stimulsoft Reports используется один общий словарь данных, поэтому все словари объединяются. Если база данных повторяется, то эти повторы не включаются в общий словарь.
Для изображений можно получить размеры и расположение, но невозможно получить содержимое изображения (если изображение сохранено в самом шаблоне).
Expressions and formulas can be placed in these fields. On the current moment, parsing and syntax of these expressions are written “as is”. So in many cases further manual correction is required. {Crystal Reports allows using expressions and formulas in FormulaFields. On the current moment parsing and syntax conversion cannot be done, expressions are written 'as is'. Therefore, in many cases, it is required further manual correction of expressions.}
|