MS-Access names (controls, fields, parameters, etc.) that do not conform with XML naming rules are renamed with uniqueness ensured.
No attempt is made to convert MS-Access VBA code or Macros. A warning message is issued when the report contains a code Module or Event properties refer to Macros.
The following MS-Access report controls are converted to SSRS Report Items.
SSRS Image elements are created from Access Bound Object Frames. Only Access OLE Objects containing bmp images are properly rendered. A function that extracts the bitmap from the OLE Object is contained in the Code element of reports containing Bound Object Frames. The Image Value property contains a call to the bitmap extraction function, passing the reference of the associated OLE Object Field.
SSRS Rectangle elements are created from Access Box controls. Access controls that are bounded by Boxes are defined within the SSRS Rectangle element. This eliminates Report Item overlaps that cause some renderers to work improperly.
SSRS Chart elements are created from MS-Graph Chart objects. See the Chart topic for conversion details.
All Access images are converted to SSRS EmbeddedImage elements.
Access Linked images supported by SSRS (bmp, jpeg, jif, png, x-png) are converted to Base64 embedded images. A warning is issued for unsupported image MIME Types.
Embedded images with MIME Type "bmp" are extracted from the PictureData property and converted to Base64 embedded images (image/bmp MIME Type).
SSRS TextBox elements are created from Access Label controls. A UTF-8 encoded Value is assigned to the TextBox from the Access Caption property to ensure proper web viewing.
The special characters (&,<,>) are replaced by & < > respectively.
SSRS Line elements are created from Access Line controls.
Page Breaks are implemented for Report Header and Footer sections. Separate rectangles are created for each page.
Access Sub-reports are fully implemented in SSRS. Master/Child linkages are automatically created. Master Reports can contain any number of Sub-Reports and Sub-Reports may contain other (nested) Sub-Reports.
SSRS SubReport elements are created from Access Sub-Reports.
See the Sub-Report Details topic.
SSRS TextBox elements are created from Access TextBox controls.