I learned a neat trick from one of my colleagues today, something I wasn’t aware that it was even possible.
Did you know that you can take an existing MS Access report and convert it to a SQL Server Reporting Services(SSRS) report? Me neither! And it fact, it’s quiet easy. Let me show it…
- Create a new SSRS project using the SQL Server Data Tools for BI(SSDT).
- Click on the PROJECT menu item, choose Import Reports and click on the Microsoft Access… menu item.
- Select the Access application you want to load the reports from and click OK.
- That’s it!
Remark: Note that it is still possible you have to fix some errors after the import because not all Microsoft Access Report features are supported in SSRS.