In This Topic
Importing MS Access Reports in the ActiveReports Import Wizard
- Run the ActiveReports Import Wizard. The wizard can be run from the start menu or by executing ActiveReports.Imports.Win.exe from C:\Program Files (x86)\MESCIUS\ActiveReports 18\Tools location.
- In the ActiveReports Import Wizard that appears, click Next.
- Choose Microsoft Access (mdb or accdb) as the input format and click Next.
- Click the ellipsis button to browse to the location that contains the files that you want to import. A list of files that you can import appears.
- Select the reports to import, click Open, and then click Next to analyze them.
- Use the ellipsis button to select a destination folder to store the converted reports. Also select an output format (Section Report, Page report or RDLX report or Both) for each report in the Output Format column.
- Click Next to start the conversion.
- Once the conversion process is complete, click Finish to close the wizard and go the destination folder to view the converted reports. You may optionally leave the check on for the Open Log file checkbox to see the results log.
The import wizard converts reports to the closest possible ActiveReports format, but due to differences between products and versions, the extent to which your reports are converted depends on your specific report layout. You may have to partially redesign the report and add script or code to get the same output as Microsoft Access Reports.
When converting to Page Reports or RDLX Reports, whether a report is imported as a Page report or RDLX report, depends on the following factors:
- If a report has a single detail section it is imported as a Page report.
- If a report has a CrossTab control and its layout is composed of multiple sections it is imported as an RDLX report.
Note: Sections in a report appear as BandedList.
Please refer to the additional information below, to understand the conversion process in detail.
Importing Microsoft Access Reports
To import Microsoft® Access® reports in ActiveReports, you must have Access 97, 2000, 2002, 2003, 2007, 2010, or 2013 installed on your system.
Microsoft Access report controls are converted in ActiveReports as follows:
| Microsoft Access Report |
Section Report |
Page report/RDLX report |
Note |
| Rectangle |
Shape |
Container |
Controls placed inside the Rectangle control are also imported along with the parent control. |
| CheckBox |
Label |
Textbox |
... |
| Image |
... |
Image |
Image control is not converted while converting to a Section Report. |
| Label |
Label |
Textbox |
... |
| Textbox |
TextBox |
Textbox |
... |
| Line |
Line |
Line |
... |
| Page Break |
PageBreak |
Container |
In Page Reports and RDLX Reports, the PageBreakAtEnd property is automatically set to True on importing a Page Break control. |
| Subform/Subreport |
SubReport |
Subreport |
... |
Limitations in MS Access conversion
- Any controls, functions, and text formats which are not supported by ActiveReports are not imported.
- The shadow property of a control is not imported while converting a report.
- In Microsoft Access reports, VBA code appears in as commented statements in script. You have to modify the code after importing.
