You can import existing Microsoft Access reports to Microsoft SQL Server 2000 Reporting Services by using Report Designer. Report Designer is a client tool that is used to create report projects. When you import reports from an Access database file (.mdb) or from an Access project file (.adp) to Reporting Services, Report Designer converts each report to a Report Definition Language (RDL) file and then saves the reports in the report project. This article describes how to import existing Access reports to Reporting Services.
Note When you import reports from an Access database or from an Access project, all the reports in the database or in the project are imported. You cannot import a single report from the database or from the project.
You can create a new project in Microsoft Visual Studio .NET 2003 to import existing Access reports. To do so, follow these steps:
Start Visual Studio .NET 2003.
On the File menu, point to New, and then click Project.
Under Project Types, click Business Intelligence Projects.
Under Templates, click Report Project.
On the Project menu, point to Import Reports, and then click Microsoft Access.
Note You can also right-click the project in Solution Explorer, point to Import Reports, and then click Microsoft Access.
In the Open dialog box, click the Access database file (.mdb) or the Access project file (.adp) that contains the reports, and then click Open.
In the Task List window, note any errors that occur when you import the Access report.
To open the Task List window, on the View menu, point to Other Windows, and then click Task List.
Note Reporting Services does not support all Access report features. Therefore, when you import an Access report, Report Designer does not import the Access report features that are not supported. Additionally, you may notice that the features that are not supported appear in the Task List window. The following list includes some of the Access report features that are not supported by Reporting Services:
Check box controls
Command button controls
GUIDFromString conversion function
CreateControl database function
For a complete list of Access report features that are supported, see the "Supported Access Report Features" topic in Reporting Services Books Online.