Migrating Access Reports - Professional SQL Server 2005 Reporting Services - page 587

Report Elements

Element Supported Comment

VBA Code Modules Yes

Events No

Parameterized queries Yes

Express functions Yes Reporting Services supports most VBA or Access

SQL functions that are allowed in Access property
expressions. All supported functions are converted to
the Visual Basic .NET equivalents. The most significant
functions commonly used in Access expressions and
not supported by Reporting Services are the domain
aggregate functions.

Access data source — Yes Connection string refers to the original Access database.

Access tables

Access data source — No Connection string refers to the original Access database

linked tables not the source of the linked tables.

Remote data source in Partial ODBC and OLEDB sources are supported, but certain

Access Data Project (ADP) characters are not allowed in names (';', '<', or '>')

Group Section Yes Appropriate sorting and grouping properties are

applied to detail sections. Nested groupings are
created for additional group sections.

Field names and variables Yes Names are converted according to Reporting Services

rules. Field names that are the same as control/item
names are modified, and names containing spaces are
modified. Any variable names that don't correspond to
fields are converted to report parameters.

Image formats Yes All image formats are converted to BMP and stored as

embedded images

During report conversion, the Access database or project is opened during the report conversion process.
Although the conversion engine handles most unsupported conversion issues gracefully, errors can cause
the process to stall under some conditions. In this case, the Access database may be left with open locks
on it, and you won't be able to open the database. In such a case, delete the corresponding 1db file after
closing Visual Studio. In extreme cases, you may need to reboot the computer first.